Sign In with your
Trend Micro Account
Need Help?
Need More Help?

Create a technical support case if you need further support.

Creating a data link (UDL) file and testing the connectivity to a Microsoft SQL server

    • Updated:
    • 30 Dec 2019
    • Product/Version:
    • Apex Central
    • Apex One All
    • Control Manager All
    • Deep Security 10.0
    • Deep Security 11.0
    • Deep Security 12.0
    • Deep Security 20.0
    • Deep Security 9.6
    • OfficeScan All
    • Platform:
    • Windows 2012 Enterprise

Learn how 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

  1. Right-click on the Windows desktop and navigate to New > Text Document. A new file is created by default (New Text Document.txt).
  2. Open the Windows Explorer.
  3. On the Tools menu, click Folder Options and select the View tab.
  4. Untick the Hide file extensions for known file types check box and click OK.
  5. Right-click the text document you created in Step 1 and select Rename.
  6. Change the name and extension of the file to "TrendDBTest.udl". When a warning message stating that changes in file extension may turn the file unusable, disregard the warning.

The TrendDBTest.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

  1. Right-click the TrendDBTest.udl file and choose Properties to open the Data Link Properties dialog box.
  2. On the Data Link Properties, select the Provider tab.
  3. From the list of OLE DB Provider(s), select Microsoft OLE DB for SQL Server.
  4. Click Next to move to the Connection tab.
  5. Enter the SQL server’s hostname followed by a backslash (\) (e.g. windows2003server\>InstanceName>) in the first box.
  6. 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.
  7. Under the section Select the database on the server, click the drop-down list to view all available databases and select the required database.
  8. Click the Test Connection button.
  9. If necessary, record any error and forward it to Technical Support. Otherwise, click OK to close the Properties Window.
  10. Save the connection settings.
Solution Id:
Did this article help you?

Thank you for your feedback!

*This form is automated system. General questions, technical, sales, and product-related issues submitted through this form will not be answered.

If you need additional help, you may try to contact the support team. Contact Support

To help us improve the quality of this article, please leave your email here so we can clarify further your feedback, if neccessary:
We will not send you spam or share your email address.

*This form is automated system. General questions, technical, sales, and product-related issues submitted through this form will not be answered.