Sometimes you want to test a database connection from an application server. This is useful whether you are testing an SQL alias you’ve created or to see if the SQL server is accessible over the network.
A quick solution is to use a Microsoft Data Link, or .udl, file. Creating a Microsoft Data Link file is a snap:
- From your desktop, right click on the desktop and choose New > Text file
- A new file named New Text Document.txt appears in the directory.
- Rename this file to “TestDBConnection.udl”, removing all spaces. Be sure to change its file extension to .udl.
- Open the file and, under Connection, type either the SQL server name or, if you are testing an SQL alias, the alias name.
- Under 2, chose “Windows Authenticated security”
- Click “refresh”
- If the connection was successful, list of databases should appear in the dropdown menu under #3.