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.
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.