Enterprise 11: Working with SQL Servers

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

Configuring SQL Server Settings

You can use an existing database from a previous Control Room installation. To do so, use the same SQL server connection parameters used in the previous installation.

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 port number for IPAll in the IP Addresses tab of the TCP/IP Properties window.
  4. Click OK.
  5. Restart the MSSQLSERVICE for the updates to take effect.
Note: Do not use a shared SQL server between applications. If you must do so, the recommendation is to use separate databases or instances for each application.

Database and Services Matrix

See Enterprise 11 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.