Chapter 4

Client Connectivity

In This Chapter

Enabling Server Connectivity

Using SQL Native Client's Development Features

Understanding Client Software Connectivity

SQL Server follows Microsoft's philosophy of “secure by default” and reduces the surface area of the application. The initial installation enables local access only and no network connections for express and developer additions. (That is, remote client applications cannot connect.)

f02uf001 Chapter 3, “Installing SQL Server” 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. As Windows Server by default comes with a firewall enabled, there will often be issues.

With network access allowed on the SQL Server, SQL Server provides clients with a new means to access functionality and features through the SQL Server Native Client (SNAC).

Before getting into the SNAC, you must enable network access for the new server.

What's New in SQL Server Native Client 11.0
Listed here are the significant new features in the SQL Server Native Client 11.0.
  • Support for LocalDB.
  • Metadata Discovery ensures that column or parameter ...

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.

Start your free trial