SQL Connetivity & Authentication Test

Many times we need to test the connectivity & authentication between a machine and a database server. A very fast and easy tool to do this is the ODBC Data Source Administrator. You can open it from the Control Panel, Administrative Tools.

Open the ODBC Data Source Administrator and click ADD

odbc01

Select “SQL Server” and click Finish

odbc02

At the Name field enter test or anything you want, its just a label
At the Server field add the name or IP of the SQL server you want to test
Click Next

odbc03

Now we can choose Windows authentication or SQL authentication. If we choose SQL authentication we need to enter Login ID (username) and password.
Click next

odbc04

If the SQL server is available and the authentication is successful then we will proceed to the next step that we can select a specific database.
If the connectivity with the database server is unsuccessful we will see the message ” Connection failed… SQL Server does not exists or access denied”. This may mean that the TCP port is disabled or a firewall is preventing the connection, generally it is a connectivity error.
If the authentication is unsuccessful then we will see the message “Connection failed… Login failed for user ‘username’. This means that the user doesn’t have login access to the SQL Server.

odbc05

Finally we can press “Test Data Source”, it the Test completes successfully then there is no connectivity or authentication issue

odbc06

Share

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.