SqlDbx
You are not logged in.
Pages: 1
We have a few servers in our environment which require the MultiSubNetFailover=true in the connection string, without which, the connection attempt takes an extremely long time to complete. I tried specifying this in the Options field on the Login dialog, but I am met with an error message. How would I go about connecting to these servers?
Offline
1. Please go to Options->Servers->Microsoft SQL Server and make sure that "Driver Load order" looks like below:
SQL Server Native Client 11.0, SQL Native Client, SQL Server
2. Looks like you have to specify MultiSubNetFailover=yes and not true
Try to connect and make sure that if you open Tools->Application Log you see line like this:
Using driver: SQL Server Native Client 11.0 (C:Windowssystem32sqlncli11.dll
Offline
Thank you, that worked!
Offline
Pages: 1