Menu
When we set up SQL Server configuration, there are two options:
both of them have four same connection options.
When we read the help manual of SQL Server for native clients, it states:
The settings configured in SQL Server Native Client Configuration, are used on the computer running the client program. When configured on the computer running SQL Server, they affect only those client programs running on the server.
I do not understand this definition fully.
What is the difference between SQL Server Network Configuration and SQL Native Configuration and when are they used?
609
SQL Server Native Client is the network library that client computers use to connect to SQL Server, starting with Microsoft SQL Server. The settings configured in SQL Server Native Client Configuration, are used on the computer running the client program.
SQL Server Network Configuration involves enabling the protocols that manage the connection to the SQL Server and configuring the available options for these network protocols.
SQL Server Native Client is a stand-alone data access application programming interface (API), used for both OLE DB and ODBC, that was introduced in SQL Server 2005 (9. x). SQL Server Native Client combines the SQL OLE DB provider and the SQL ODBC driver into one native dynamic-link library (DLL).
A "client" is a front-end application that uses the services provided by a server such as the SQL Server Database Engine. The computer that hosts this application is referred to as the client computer. At the simplest level, a SQL Server client can reside on the same machine as an instance of SQL Server.
SQL Server Network Configuration is for configuring the SQL Server process, i.e. the actual database server, which is a Windows Service.
SQL Server Native Client Configuration is for configuring the SQL Server Client tools, e.g. SQL Server Management Studio, which is an executable program.
Keep in mind that SQL Server Client tools can connect either to the local machine (localhost or .), or to a remote machine.
66
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
