3.3 Installing and Configuring Microsoft SQL Server

The Secure Configuration Manager database computer requires that Microsoft SQL Server or Microsoft SQL Server Express use mixed-mode authentication. Non-U.S. language versions of SQL Server and SQL Server Express are not supported. For more information about supported SQL Server versions, see Database Computer Requirements.

Follow the instructions provided in the Microsoft SQL Server documentation to install the database software.

NOTE:Named instances cannot contain special characters. If you are using a named instance that contains special characters, rename the database instance so that it does not contain special characters.

3.3.1 Configuring the SQL Server Browser Service

To complete the Secure Configuration Manager installation, the Browser Service must be running in SQL Server or SQL Server Express.

To verify the SQL Server or SQL Server Express Browser Service is running:

  1. Open SQL Server Configuration Manager.

  2. In the left pane, select the SQL Server services.

  3. In the right pane, ensure that SQL Server Browser is set to Running.

  4. (Conditional) If the SQL Server Browser is stopped, select SQL Server Browser, and on the Action menu, click Start.

3.3.2 Configuring the SQL Server TCP/IP Protocol

To complete the Secure Configuration Manager installation, the TCP/IP protocol must be enabled in SQL Server or SQL Server Express.

To verify the SQL Server TCP/IP protocol is enabled:

  1. Open SQL Server Configuration Manager.

  2. In the left pane, expand SQL Server Network Configuration and select Protocols for MSSQLSERVER.

  3. In the right pane, ensure that TCP/IP is set to Enabled.

  4. (Conditional) If the TCP/IP protocol is disabled, select TCP/IP, and on the Action menu, click Enable.