|
User Task
|
Windows Permissions
|
|
Install/Upgrade
|
local administrator on the server
|
|
Create/Upgrade Database
|
- dbcreator on SQL Server. Only required to create the database; you can create the database manually via SQL Server Management Studio without dbcreator
- dbo on the database, to create the schema inside the database and set up security
- dbo on the database to run the upgrade process
|
|
Control Center Service
|
The account running the service needs to have the following permissions:
- Log on locally and log on as a Service (this will be granted during the installation process)
- Access to the database via Windows Authentication
- db_datawriter on the database
- Permissions to Edit, Create and Delete files in a network share on each Windows Acquire machine if you are using the Control Center account and collection is done using from windows network share option.
Note: If the SQL server is on the same machine, then the “Local System” account can be used to run service. A Windows login to SQL Server needs to be defined for <DOMAIN>\<COMPUTERNAME>$, where COMPUTERNAME is the name of the system where Control Center is running.
|
|
Concentrator Service
|
The account running the service needs to have the following permissions:
Log on locally and log on as a Service
|
|
Scheduler Service
|
The account running the service needs to have the following permissions: - Log on Locally and Logon as a Service (this will be granted during the installation process)
- Access to the database via Windows Authentication
- For reporting: db_datareader on the database
- For Data Management: db_datawriter on the database
- Access to any network shares where reports are to be saved.
If the SQL server is on the same machine, then the “Local System” account can be used to run service. A Windows login to SQL Server needs to be defined for <DOMAIN>\<COMPUTERNAME>$, where COMPUTERNAME is the name of the system where Control Center is running.
|
|
Capacity Team User
|
Used in the day to day administration and use of Syncsort™ Capacity Management, can create new Targets and edit existing Targets for data collection by Control Center.
- Access to the database via Windows Authentication
- db_datawriter on the database
|