0

I am having difficulty verifying my Availability Group Listener configuration. I would like to create an ODBC connection which points to the listener. When I configure the system DSN and try to test the connection at the end, I get timeout errors. However, when I change the server to point to the instance name instead of the listener name, the connection works. How can I test the listener using ODBC? What other method can I use to test the listener?

Note: I do not have access to an application to test client connectivity.

  • You can use SQLCMD.exe -S <AG listener> -D <AG database> -E. What port is your Listener configured to listen ? you may want to specify AGlistener,port_no to see if you can connect to the listener. – Kin Shah Nov 11 '14 at 19:53
1

Converting my comment to answer :

You can use SQLCMD.exe -S <AG listener> -D <AG database> -E.

You may want to specify AGlistener,port_no to see if you can connect to the listener.

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.