[-]
  
  
  
  
[-]
  
[-]
  
  
  
  
[-]
  
  
  
 
 
 
[-]
  
  
  
  
  
  
  
  
  
  
  
  
  
[-]
  
  
[-]
  
  
 
 
 
 
 
[-]
 [+]
 [+]
Updated on 10/10/2018
True Control Center Installation Guide
Providing access to SQL for the Control Center
Direct link to topic in this publication:

Providing access to SQL for the Cireson Control Center 

From a SQL perspective, if the Cireson Control Center is to be installed using the Installer, the SQL login for the user account used by the Control Center needs to initially have the sysadmin server role to be able to create the Control Center database and run the required SQL scripts to configure it.

Post installation, the sysadmin server role can be removed from the Control Center’s SQL login provided it is granted the Public Server Role and the following User Mapping database role memberships:

Database

Role Membership

ConfigMgr (CM_xxx)

db_datareader

public

TrueCC

db_owner

public

MDT

db_datareader

db_datawriter

public

ReportServer

db_datareader

public