Permissions required in SQL Server to create and maintain a TaskCentre SQL store

Introduction

The TaskCentre Configurator uses the credentials of a SQL Server account to either create a new store or connect to one that already exists. Sufficient permissions on the account must be in place to allow these actions. The SQL account provided will be used by TaskCentre to maintain the store, i.e. read from the database and write to it.

This knowledgebase article outlines the permissions required for a SQL Server account to create or connect with a TaskCentre SQL Server store.

Capture1

Figure 1. Configurator – Specifying the store location.

If sufficient permissions are not active on the account then this will prevent the store from being created or connected with. An error message similar to the following will appear:

Capture2

Figure 2 – Configurator – Limited SQL account permissions preventing the store from being created.

Create and connect to a new Microsoft SQL Server store

Within SQL Management studio:

  1. Create a new database that will contain the TaskCentre store data.
  2. Create a new SQL login. You can use either Windows Authentication or SQL Server Authentication.
    – See notes on Authentication below.
  3. For SQL Authentication, ensure that Enforce password expiration is disabled to prevent the login expiring.
  4. Map the login to the database and grant it the db_owner role.

Within the Configurator:

  1. Under Store->Configuration select Connect to / Create a new Microsoft SQL Server Store followed by Next.
  2. Within SQL Login Details enter the server and database name, and the login credentials followed by Next.
  3. Within SQL Store Location confirm the location of the log files followed by Next.
  4. Within Store Password provide a password for the TaskCentre Administrator account*.
  5. Click Save to complete.

Connect to an existing Microsoft SQL Server store

Within the Configurator:

  1. Under Store->Configuration select Connect to / Create an alternative Microsoft SQL Server Store followed by Next.
  2. Within SQL Login Details enter the server and database name, and the login credentials followed by Next.
  3. Within SQL Store Location confirm the location of the log files then click Save to complete.

Authentication

Windows Authentication can be used where the TaskCentre Server and SQL Server are located on the same host. This is because the TaskCentre Server service account runs as Local System, this means that you have only one choice of SQL login to choose from: NT AUTHORITY\SYSTEM

SQL Server Authentication can be used where the TaskCentre Server and SQL Server are either located on the same host or separate hosts.