Enterprise 11: Working with SQL Servers
- Dernière mise à jour2022/08/10
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.
- Enable protocols for Named Pipes and TCP/IP in .
- Double-click TCP/IP to open the properties window.
- Input the port number for IPAll in the IP Addresses tab of the TCP/IP Properties window.
- Click OK.
- 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 |
|
SQL User account is used to create:
|
Domain User Account |
|
SQL User account is used to create:
|
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. |