Test a remote SQL Connection very quickly and easy

I ran across a very useful MSDN blog post today and thought I’d share it. It explained a very quick and easy way to test a SQL connection and verify if you can logon with a specified account.

Here’s how:

Go to any folder on the system from where you want to test the connection, and create a new file

 Then change the extension to .UDL

 When you open that up you can easily see any SQL server within your reach

 

And then easily test the connection for a specified account (is the case the Windows Integrated) by just opening the database list, or pressing Test Connection

I think this is a very usefull way to quickly check a connection without having to configure or install anything.

Credits: http://blogs.msdn.com/b/steverac/archive/2010/12/14/test-remote-sql-connectivity-easily.aspx