Microsoft® SQL Server® 2012 Bible

(Ben Green) #1

71


CHAPTER


4


Client Connectivity


IN THIS CHAPTER


Enabling Server Connectivity

Using SQL Native Client’s Development Features

Understanding Client Software Connectivity

S


QL 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 confi guration as part of the
installation process.

The Server Confi guration Manager tool installed with SQL Server can nearly always communicate
with SQL Server, so you can confi gure 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 fi rewall 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 signifi cant new features in the SQL Server Native Client 11.0.

■ (^) Support for LocalDB.
■ (^) Metadata Discovery ensures that column or parameter metadata returned from a query is identical
or compatible with the metadata format specifi ed before the query was executed.
■ (^) UTF-16 Support.
■ (^) Asynchronous Execution on connection-related operations.
■ (^) C Data Type Extensibility.
■ (^) Deprecation announcement of SNAC OLE DB provider.
c04.indd 71c04.indd 71 7/30/2012 4:12:41 PM7/30/2012 4:12:41 PM
http://www.it-ebooks.info

Free download pdf