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 .