Tuesday, December 14, 2010

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.