CODEWITHSUNDEEP
sql-serversql-server-2008
engtuncay
engtuncay

Reputation: 887

What is the difference between SQL Server Network Configuration and SQL Native Client Configuration?

When we set up SQL Server configuration, there are two options:

sql server configuration manager screen

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?

Upvotes: 11

Views: 3985

Answers (1)

Svein Fidjestøl
Svein Fidjestøl

Reputation: 3216

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

Upvotes: 8

Related Questions