Was this page helpful?
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

How to: Enable or Disable a Server Network Protocol (SQL Server Configuration Manager)

All network protocols are installed by SQL Server Setup, but may or may not be enabled.

Use SQL Server Configuration Manager to enable or disable network protocols. The Database Engine must be stopped and restarted for the change to take effect.

  1. In SQL Server Configuration Manager, in the console pane, expand SQL Server 2005 Network Configuration.

  2. In the console pane, click Protocols for <instance name>.

  3. In the details pane, right-click the protocol you want to change, and then click Enable or Disable.

  4. In the console pane, click SQL Server 2005 Services.

  5. In the details pane, right-click SQL Server (<instance name>), and then click Restart, to stop and restart the SQL Server service.

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

Community Additions

© 2015 Microsoft