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.
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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
