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.

Improve this question
1
  • 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
    Commented Nov 11, 2014 at 19:53

1 Answer 1

Reset to default
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.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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