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

How to: Enable or Disable a Server ...

Switch on low bandwidth view

Community Content

In this section

Statistics Annotations (0)

Click here to expand

Collapse All

Other versions are also available for the following:

SQL Server 2005

SQL Server 2008 Books Online (June 2009)

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.

To enable a server network protocol

In SQL Server Configuration Manager, in the console pane, expand SQL Server Network Configuration.
In the console pane, click Protocols for <instance name>.
In the details pane, right-click the protocol you want to change, and then click Enable or Disable.
In the console pane, click SQL Server Services.
In the details pane, right-click SQL Server (<instance name>), and then click Restart, to stop and restart the SQL Server service.

Tasks

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

Help and Information

Getting SQL Server 2008 Assistance

Tags

: Add a tag

Community Content

Add new content

Annotations

Screen captures

Texasshutterbug | Edit | Show History

I am working with SQL for the first time. These tips would be much more helpful if screen shots of the steps would be added. For instance, without a "guided tour" first, I'm having to poke around a lot to find things annotated in the steps. Which is the console pane? Which is the details pane? etc.