Follow-On Topics

Related Topics

# Server > Store > Configuration

If Performing the Initial Configuration:

The Configuration pane displays the following options when creating a new Store after first installing the product:

Choosing a Store Type

Two Store types are available:

|  | Internal Store — Holds the Store locally on the installed machine's hard drive. Typically, this is `c:\iwdb`.

|  | Microsoft SQL Server Store — Holds the Store in a SQL database. This can be in a local or remote SQL Server installation.

| Internal Store | Microsoft® SQL Server Store
--- | --- | ---
Requirements | Available space on disk only | Microsoft® SQL Server™ 2000 or higher For a detailed list of supported versions, see King Task Centre Database.
Speed | Very fast, but can slow as usage increases | Fast and scalable, even on busy servers
Reliability | Reliable, but corruption can occur in rare circumstances | Very reliable, relies on SQL Server Integrity
Maintenance | Maintenance takes time to run due to de-fragmentation | Maintenance is very quick as de-fragmentation is performed by the database administrator
Backup | Backup must be made by backing up the Backup sub-folder of the King Task Centre Internal Store | Backup is left to the database administrator who is maintaining the SQL Server backup

Supported SQL Server Versions

Supported SQL Server editions are listed below:

|  | Microsoft SQL Server 2005

Express, Standard, and Enterprise editions

32- or 64-bit

|  | Microsoft SQL Server 2008

Express, Standard, Workgroup, Developer, and Enterprise editions

32- or 64-bit

|  | Microsoft SQL Server 2008 R2

Express, Standard, Web, Workgroup, Parallel Data Warehouse, Fast Track, Datacenter, Evaluation, Developer, and Enterprise editions

32- or 64-bit

|  | Microsoft SQL Server 2012

Express, Standard, Web, Workgroup, Parallel Data Warehouse, Fast Track, Datacenter, Evaluation, Business Intelligence, Developer, and Enterprise editions

32- or 64-bit

|  | Microsoft SQL Server 2014

Express, Evaluation, Standard, Web, Developer, Business Intelligence, and Enterprise editions

32- or 64-bit

|  | Microsoft SQL Server 2016

Express, Evaluation, Standard, Developer, and Enterprise

64-bit

|  | Microsoft SQL Server 2017

Express, Evaluation, Standard, Enterprise, Developer, and Web Edition

64-bit

|  | Change store configuration — Leave this enabled. King Task Centre must have a store to function correctly.

|  | Connect to / Create a new Microsoft SQL Server Store — Select this to hold the Store in an SQL database, either remote or local

|  | Connect to / Create a new internal store — Select this option to hold the store directly on this machine's hard drive

If Changing the Store Type:

|  | Change store configuration — Enable this to change the existing store type.

Choosing a Store Type

Two Store types are available:

|  | Internal Store — Holds the Store locally on the installed machine's hard drive. Typically, this is `c:\iwdb`.

|  | Microsoft SQL Server Store — Holds the Store in a SQL database. This can be in a local or remote SQL Server installation.

| Internal Store | Microsoft® SQL Server Store
--- | --- | ---
Requirements | Available space on disk only | Microsoft® SQL Server™ 2000 or higher For a detailed list of supported versions, see King Task Centre Database.
Speed | Very fast, but can slow as usage increases | Fast and scalable, even on busy servers
Reliability | Reliable, but corruption can occur in rare circumstances | Very reliable, relies on SQL Server Integrity
Maintenance | Maintenance takes time to run due to de-fragmentation | Maintenance is very quick as de-fragmentation is performed by the database administrator
Backup | Backup must be made by backing up the Backup sub-folder of the King Task Centre Internal Store | Backup is left to the database administrator who is maintaining the SQL Server backup

Supported SQL Server Versions

Supported SQL Server editions are listed below:

|  | Microsoft SQL Server 2005

Express, Standard, and Enterprise editions

32- or 64-bit

|  | Microsoft SQL Server 2008

Express, Standard, Workgroup, Developer, and Enterprise editions

32- or 64-bit

|  | Microsoft SQL Server 2008 R2

Express, Standard, Web, Workgroup, Parallel Data Warehouse, Fast Track, Datacenter, Evaluation, Developer, and Enterprise editions

32- or 64-bit

|  | Microsoft SQL Server 2012

Express, Standard, Web, Workgroup, Parallel Data Warehouse, Fast Track, Datacenter, Evaluation, Business Intelligence, Developer, and Enterprise editions

32- or 64-bit

|  | Microsoft SQL Server 2014

Express, Evaluation, Standard, Web, Developer, Business Intelligence, and Enterprise editions

32- or 64-bit

|  | Microsoft SQL Server 2016

Express, Evaluation, Standard, Developer, and Enterprise

64-bit

|  | Microsoft SQL Server 2017

Express, Evaluation, Standard, Enterprise, Developer, and Web Edition

64-bit

If you have an existing internal store, you can:

|  | Migrate from Internal to Microsoft SQL Server Store — Select this option to migrate an existing internal store to a local or remote SQL Server. For more information, see our knowledge base article How to migrate an Internal store to a Microsoft SQL Server store

|  | Connect to / Create an alternative internal Store — If required, you can create additional internal stores and switch between them.

If you have an existing SQL Server store, you can

|  | Connect to / Create an alternative Microsoft SQL Server Store — If required, you can create additional SQL database stores.

|  | Connect to / Create an alternative internal Store — If required, you can migrate an existing SQL Server store to an internal store.

Click Next to configure the store — For an SQL Server store, see Server > Store > SQL Login Details; for an internal store, see Server > Store > Internal Store Location

Copyright © 2018 Quadrant Software B.V. All rights reserved.