Microsoft SQL Server settings and service credential matrix - Configure Microsoft SQL Server settings and review the service credential and authentication options before setting up the Control Room database.

Automation 360

Configure Microsoft SQL Server settings and review the service credential and authentication options before setting up the Control Room database.

Configuring SQL Server settings

Configure SQL Server settings in SQL Server Configuration Manager.

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

    The default port number is 1433.

  4. Click OK.
  5. Restart the MSSQLSERVER service so that changes take effect.
Note: The Control Room database must use SQL_Latin1_General_CP1_CI_AS as its default database collation.

Database and services matrix

For supported Microsoft SQL Server versions, see Database requirements for On-Premises installation.

Service credentials Windows authentication SQL authentication
Local system account
  • The currently logged-in user account is used to create:
    • Databases
    • Tables
  • The installer gives the db_owner permission to the NT AUTHORITY\SYSTEM account.
The SQL user account is used to create:
  • Databases
  • Tables
Domain user account
  • The currently logged-in user account is used to create the database.
  • The domain user account is used to create tables.
  • The installer gives the db_owner permission to the domain user account.
The SQL user account is used to create:
  • Databases
  • Tables
Service user account Not applicable For Microsoft Azure installations, the service account user must have read and write access to the remote Microsoft Azure repository share path.