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.
- Right-click the protocol you want to configure, and then choose Properties.
- In Properties, you can set the protocol-specific options.
No comments:
Post a Comment