Testing the connectivity to a Microsoft SQL server
To perform a UDL test to check the connectivity from a Windows server to a Microsoft SQL server instance and database.
Create a data link (UDL) file
- Right-click on the Windows desktop and navigate to New > Text Document. A new file is created by default (New Text Document.txt).
- Open the Windows Explorer.
- On the Tools menu, click Folder Options and select the View tab.
- Untick the Hide file extensions for known file types check box and click OK.
- Right-click the text document you created in Step 1 and select Rename.
- Change the name and extension of the file to "TestSQLConnectivity.udl". When a warning message stating that changes in file extension may turn the file unusable, disregard the warning.
- The TestSQLConnectivity.udl file can be stored anywhere on your system or network. You are now ready to connect to your data source.
Testing the connectivity to a SQL server
- Right-click the TestSQLConnectivity.udl file and choose Properties to open the Data Link Properties dialog box.
- On the Data Link Properties, select the Provider tab.
- From the list of OLE DB Provider(s), select Microsoft OLE DB for SQL Server.
- Click Next to move to the Connection tab.
- Enter the SQL server’s hostname followed by a backslash (\) (e.g. windows2003server\>InstanceName>) in the first box.
- Under the section Enter information to log on to the server, select the appropriate radio button:
- If the SQL server uses Windows authentication, select Use Windows NT Integrated security.
- If the SQL server uses SQL authentication, select User a specific user name and password.
- Under the section Select the database on the server, click the drop-down list to view all available databases and select the required database.
- Click the Test Connection button.