Igor Feldman Sharepoint WIKIpedia

Sharepoint 2010 MSDN links => Sharepoint Usefull stuff => Topic started by: Administrator on November 05, 2015, 11:29:44 PM

Title: SQL Alias - Creating and Testing the connection
Post by: Administrator on November 05, 2015, 11:29:44 PM

Testing the alias and database connection - an awesome little trick!

Many folks use some 3rd party tools or some custom scripts to test the connection but many don’t even test the connection assuming that everything is ok. And when the time for the implementation come… bad things may happen. :)

So it is always good to test and double check the configuration before proceed any further!

This method for testing is very helpful because it takes less than a half minute to understand that something is not working and the good thing is that this is an out of the box tool in Windows.

Just navigate to any folder you like and create an empty text file. You can name it "TestSqlConnection" for example. Rename the file extension from txt to UDL and voila…