Tips for detecting whether a SQL Server database can be connected _mssql

Sometimes it may be necessary to detect the service of a certain machine is not up, or whether a library of a machine can be connected and can not open SSMs also do not want to log on to the server can use this method.

1. Right-click on the desktop to create a text, and then change the suffix name for the UDL after the preservation (1.UDL), as for the UDL is what you can Baidu under here will not elaborate.

Note: UDL (Universal Data Link) is a universal connection file that uses a Universal Data Link (UDL) file to save the connection string.

2. Open this file to enter the server's IP (because I am a native so use the instance name) and user name password can test the connection, is not very convenient.