Step 16 - Enable SQL Server Network Protocols

Applies To: Windows Server 2008, Windows Server 2008 R2, Windows Server 2012

This step explains how to enable the allowed network protocols for SQL2. This is done so that the AD RMS Server can communicate with the database server.

To enable SQL Server Network Protocols

  1. Log on to SQL2.fabrikam.com as fabrikam\Administrator.

  2. Click Start, select All Programs, click Microsoft SQL Server 2008, click Configuration Tools, and select SQL Server Configuration Manager. This will bring up the SQL Server Configuration Manager.

  3. In SQL Server Configuration Manager, on the left, expand SQL Server Network Configuration and click Protocols for MSSQLSERVER. This will populate the right pane with four protocols and their status.

  4. On the right, right-click Disabled next to Named Pipes and select Enable. This will bring up a pop-up box that says Any changes made will be saved; however, they will not take effect until the service is stopped and restarted. Click OK.

  5. On the right, right-click Disabled next to TCP/IP and select Enable. This will bring up a pop-up box that says Any changes made will be saved; however, they will not take effect until the service is stopped and restarted. Click OK.

  6. In SQL Server Configuration Manager, on the left, click SQL Server Services. This will populate the right pane with three services and their state.

  7. On the right, right-click SQL Server (MSSQLSERVER) and select Stop. This will stop the SQL Server service.

  8. On the right, right-click SQL Server (MSSQLSERVER) and select Start. This will start the SQL Server service.

  9. Close SQL Server Configuration Manager.