enabling protocols for accessing DB engine from another machine

Posted by Professionaluser under Sql Server category on | Points: 40 | Views : 767
If you are to be access the DB engine from same machine/computer where your SQL Server instance is installed, you do not have to enable additional protocols. Management Studio will connect to the Database Engine by using the shared memory protocol. This protocol is already enabled.

For connecting to Database Engine from other computers , you must enable a protocol, such as TCP/IP

1. On the Start menu, point to All Programs , point to Microsoft SQL Server <Version> , point to Configuration Tools , and then click SQL Server Configuration Manager.

2. In SQL Server Configuration Manager , expand SQL Server Network Configuration , and then click Protocols for <InstanceName>.

3.In the list of protocols, right-click the protocol you want to enable (TCP/IP ), and then click Enable .

Comments or Responses

Login to post response