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