O'Reilly logo

Microsoft® SQL Server® 2008 Bible by Uttam Parui, Mike White, Paul Nielsen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 5. Client Connectivity

IN THIS CHAPTER

  • Enabling server connectivity

  • SQL Native Client development features

  • Client software connectivity

SQL Server 2008 follows Microsoft's philosophy of "secure by default" and reduces the surface area of the application. The initial installation allows local access only—no network connections for the Express and Developer editions (i.e., remote client applications will not be able to connect).

Note

Chapter 4, "Installing SQL Server 2008" discusses SQL Server surface area configuration as part of the installation process.

The Server Configuration Manager tool installed with SQL Server can nearly always communicate with SQL Server so you can configure the server connectivity options and open the server up for network access. The connectivity relies on open paths between the client and server machines. At times, there will be firewall issues to deal with.

With network access allowed on the SQL Server, SQL Server provides clients with a new means of accessing functionality and features through the new SQL Server Native Client (SNAC). Before getting into the SNAC, network access for the new server must be enabled.

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, additional network protocols must be enabled on the server. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required