Search Our Database
Test/Verify Microsoft SQL Server Remote Connection (MSSQL)
Introduction
This article provides a steps to test/verify remote connection for Microsoft SQL Server (MSSQL)
1. Create a new text file (such as test.txt), and then rename the extension from .txt to .udl. (Select Yes to the warning message about changing the file name extension.)
2. Open the .udl file
3. On the Connection tab,
- Specify the SQL Server IP Address, Instance name , and the port number under Select or enter a server name. For example,
<IP Address>\<Instance Name>,<Port Number>
192.168.0.1\SQLEXPRESS,1433
- Enter the SQL Server login and click “Test Connection”
For further help or if you encounter any issues, please contact our support team at support@ipserverone.com.