Tuesday, December 21, 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.