Pages

Thursday, December 29, 2011

How to: Enable Network Access in SQL Server Configuration Manager

To enable a network protocol


On the Start menu, choose All Programs, point to Microsoft SQL Server and then click SQL Server Configuration Manager.

Optionally, you can open Computer Manager by right-clicking My Computer and choosing Manage. In Computer Management, expand Services and Applications, expand SQL Server Configuration Manager.


Expand SQL Server Network Configuration, and then click Protocols for InstanceName.


In the list of protocols, right-click the protocol you want to enable, and then click Enable.

The icon for the protocol will change to show that the protocol is enabled.


To disable the protocol, follow the same steps, but choose Disable in step 3.
To configure a network protocol


On the Start menu, right-click My Computer, and then choose Manage.


In Computer Management, expand Services and Applications, expand SQL Server Configuration Manager, expand Server Network Configuration, expand Protocols for InstanceName, and then click the protocol you want to configure.

No comments:

Post a Comment