Microsoft® SQL Server® 2012 Bible

72

Part I: Laying the Foundations

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, “Confi guring SQL Server,” discusses SQL Server confi guration in detail.

Server Confi guration Manager

SQL Server Confi guration Manager is a tool to manage the services associated with SQL

Server, to confi gure the network protocols used by SQL Server, and to manage the network

connectivity confi guration from SQL Server client computers.

Network protocols defi ne the common set of rules and formats that computers and applica-

tions 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 network traffi c

during use. In larger and slower networks, TCP/IP works better.

TCP/IP Transmission Control Protocol/Internet Protocol (TCP/IP), is widely used today.

TCP guarantees the delivery and order of the information sent between com-

puters, while IP defi nes the format or structure of the data sent. TCP/IP also

contains advanced security features that make it attractive to security-sensitive

organizations and users. This protocol works well in larger networks and slower

networks.

The Server Confi guration Manager enables for these various protocols to be enabled,

disabled, and confi gured as appropriate for the operational environment. You can launch

the utility from the Start menu by selecting Start ➪ All Programs ➪ Microsoft SQL Server

c04.indd 72c04.indd 72 7/30/2012 4:12:43 PM7/30/2012 4:12:43 PM

http://www.it-ebooks.info