Export (0) Print
Expand All

Step 16 - Enable SQL Server Network Protocols

Updated: March 19, 2013

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.

  1. Log on to SQL2.fabrikam.com as 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.

    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.

    Protocols for MSSQLSERVER
  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.

    Enable Protocols

    Restart box
  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.

    Protocol Summary
  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.

    Restart SQL Service
  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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft