Skip to content

Test connection to SQL server from Windows Server without SQL Server Management Studio

by mstrid on June 19th, 2014

The other day I found a nifty tool for testing the connection to a SQL Server database from Windows Server without having to install the full SQL Server Management Studio.

I can’t find any proper for the tool but you do like this:

  1. Create an empty file and give it any filename but make sure the file extension is “.udl”.
  2. Double-click the file.
  3. A dialog opens where you can enter hostname/ip address, username, etc and test the Connection.

More information in this blog post.

Comments are closed.