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.)
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.
- 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.