May 27, 2004 at 7:58 am
What is the best way to test connections to sql servers. ie for Healthchecks I need to test connections. I can test pings usinh query analyser. Should I connect to each database on each sql server, or just to the server itself?
Any help appreciated.
May 28, 2004 at 2:19 am
A quick and easy way is to use a UDL file (universal data link) - create a new text file with .UDL extension, then double click on it and it brings up a dialog for creating and testing connections to any type of database.
Also, if you open the UDL file in notepad, it provides a connection string for the specified connection.
June 1, 2004 at 1:40 pm
I'd like to try that UDL file suggestion. I created a text file named test.udl. When I double click it, I get "File cannot be opened. Ensure it is a valid Data Link file."
What am I doing wrong there?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply