3

I have two SQL Server named instances, InstanceA and InstanceB on one computer, and they correctly show up under Sql Server Configuration Manager | SQL Server Network Configuration.

However, when I try to configure SQL Native Client 11.0 Configuration | Client Protocols, there is no option to specify to which instance the setting will be applied. It appears that this is server (machine) level setting that would apply to every instance installed on it.

Am i missing something here? How to allow one protocol, say Named Pipes only for InstanceA and TCP/IP only for InstanceB? (without using aliases, preferably)

Thanks

2

You are confusing Server Network Protocols and Client Network Protocols. Essentially, Server Network Protocols change the way in which SQL Server listens for incoming requests and Client Network Protocols change the way in which an application sends a request to SQL Server.

As the Client Network Protocols are a shared component and apply to all applications that use that library you cannot set a different protocol per instance that you wish to connect to.

Direct from the Client Network Protocols link below:

At the simplest level, a SQL Server client can reside on the same machine as an instance of SQL Server. Typically, however, a client connects to one or more remote servers over a network. The client/server architecture of SQL Server allows it to seamlessly manage multiple clients and servers on a network. The default client configurations suffice in most situations.

More information regarding the two can be found in the links below:

Server Network Protocols

Client Network Protocols

4
  • thanks. So it is not possible to restrict application connections to an instance to be using a particular protocol in sql Server Configuration Manager? – John Smith Jun 3 '17 at 12:05
  • It could be done, but you would have to use multiple client machines with each one configured for a specific protocol. You could not do it with a single machine. – World Wide DBA Jun 3 '17 at 13:27
  • Thanks. What is a Client Tool Connectivity? It seems like something that can be used to configure what protocols to use when the clients are connecting to a server. – John Smith Jun 4 '17 at 12:29
  • Installs components for communication between clients and servers, and network libraries for DB-Library, ODBC, and OLE DB. – World Wide DBA Jun 4 '17 at 18:24

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.