This tool is available on all Windows machine and can be used by creating an empty txt file on your Machine. The file can be named anything you want. You just need to make sure the extension is set to as UDL. Then, double-click on the file and up pops a SQL connectivity window to allow testing of remote SQL connections.
Here is an example as seen below:
If it can't connect to the machine, you would get this error:
If it can't find or locate the database name, the error would be that it "Cannot open datebase "<database-name>" requested by the login. The login failed."
On success, the prompt should look like this:
Another test to ensure is to check:
- Open SQL Server configuration manager
- Select SQL Server Network Configuration
- Select protocol for MSSQLSERVER
- Check whether tcp/ip is enabled or not. If not, enable it.