Enabling Server Connectivity

When initially installed, SQL Server enables the Shared Memory protocol and disables the remaining protocols. This provides the greatest default security because only applications running locally to the SQL Server can connect.

To broaden SQL Server availability, you must allow additional network protocols on the server.

f02uf001 Chapter 19, “Configuring SQL Server,” discusses SQL Server configuration in detail.

Server Configuration Manager

SQL Server Configuration Manager is a tool to manage the services associated with SQL Server, to configure the network protocols used by SQL Server, and to manage the network connectivity configuration from SQL Server client computers.

Network protocols define the common set of rules and formats that computers and applications use when communicating with one another. Table 4.1 lists the protocols available in SQL Server.

Table 4.1 Three Available Protocols for SQL Server

Protocol Description
Shared Memory This is an in-memory protocol and thus is only suitable for applications running on the same machine as the SQL Server.
Named Pipes This is an interprocess communications protocol (IPC) that enables a process to communicate with another process, possibly running on a different computer, through the use of shared memory. This protocol typically works well in small and fast local area networks because it generates additional ...

Get Microsoft SQL Server 2012 Bible now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.