Igor Feldman Sharepoint WIKIpedia

Please login or register.

Login with username, password and session length
Advanced search  


SMF - Just Installed!

Author Topic: SQL Alias - Creating and Testing the connection  (Read 1639 times)


  • Administrator
  • Newbie
  • *****
  • Karma: +0/-0
  • Posts: 9
    • View Profile
SQL Alias - Creating and Testing the connection
« 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…