Working with SQL Servers

Configure Microsoft SQL Servers before setting up the Control Room database.

Configuring SQL Server Settings

SQL Server settings can be configured in the SQL Server Configuration Manager.

  1. Enable protocols for Named Pipes and TCP/IP in SQL Server Network Configuration > Protocols for MSSQLSERVER.
  2. Double-click TCP/IP to open the properties window.
  3. Input the default or custom port number for IPAll in the IP Addresses tab of the TCP/IP Properties window.

    The default port number is 1433.

  4. Click OK.
  5. Restart the MSSQLSERVICE for the updates to take effect.
Note: Ensure the Control Room database uses SQL_Latin1_General_CP1_CI_AS as the default database collation.

Database and Services Matrix

See Database requirements for a list of supported Microsoft SQL Server versions.
Service Credentials Windows Authentication SQL Authentication
Local System Account
  • Current logged in user account is used to create:
    • Database
    • Tables
  • Installer gives db_owner permission to NT AUTHORITY\SYSTEM account.
SQL User account is used to create:
  • Databases
  • Tables
Domain User Account
  • Current logged in user account is used to create database.
  • Domain user account is used to create tables.
  • Installer gives db_owner permission to domain user account.
SQL User account is used to create:
  • Databases
  • Tables
Service User Account For Microsoft Azure installations, the service account user needs to have read/write access to the remote Microsoft Azure repository share path.