Technical FAQs

Ask a Question

Useful tool for testing SQL Database Connections

Issue
Testing SQL database connections during troubleshooting

Product Line
Windows Operating Systems
 

Causes
A user need to check to application/secondary server with the database server.
 

Resolution
There is a built in Windows utility that can be used for testing SQL Database connections. This tool can be useful when testing username\passwords, as well as connections to remote database servers.

1) On the Desktop, right click and create a New Text Document
Note: "Hide extensions for known file types" must NOT be checked in the Folder Options".
2) Change the .txt extension to .udl.
3) Double Click on the .udl file to bring up the Data Link Properties window.



4) Enter the name of the SQL Server you are trying to connect to. <Servername>\<Instance>



5) Enter the user credentials being tested.



6) Select the database from the drop down list. (If there is no connection to the database server, this step will fail).



7) Click "Test Connection". If successful, you will get a message saying "Test connection succeeded".

Was this helpful?
What can we do to improve the information ?