Tips for SQL Server to detect whether a database can be connected

Sometimes it may be necessary to detect whether a machine's service is up, or if a certain library of a machine can be connected and not open to ssms or log on to the server.

1. Right-click on the desktop to create a text, and then change the suffix called UDL after the Save (1.udl), as to what is the UDL you can Baidu here is not elaborate.

2. Open this file after entering the server's IP (because I am this machine so with the instance name) and user name password can test the connection, is not very convenient.

Tips for SQL Server to detect whether a database can be connected