Tips for detecting whether SQL Server 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 named udl after saving (1.udl).

Note: UDL (Universal data link) is a universal data connection file that uses a Universal Data Link (UDL) file to hold the connection string (which can be queried by Baidu).

2. Open this file to enter the server's IP (2016, the port number, if you use the default port 1433, only the input IP) and the user name password can test the connection.

Reference: http://www.jb51.net/article/61425.htm

Tips for detecting whether SQL Server database can be connected