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

  • ID dell'articolo: 65525
  • Valutazione:
  • 24 di clienti ha valutato questo articolo 4.5 su 6
  • Aggiornato il: 01 mag 2014

This article is to show how to perform a UDL test to check connectivity from a Windows server to a SQL server instance and database.

Applies to the following Sophos product(s) and version(s)

Not product specific

What To Do

Create the data link (UDL) file
  1. Right-click the Windows desktop, point to New, and then click Text Document. A new file is created by default (New Text Document.txt).
  2. Open Windows Explorer, and on the Tools menu, click Folder Options. On the View tab, clear the Hide file extensions for known file types check box and then click OK.
  3. Right-click the Text Document you created in step 1, choose Rename, and then change the name and extension of the file to: sophos.udl
  4. A warning might appear, explaining that changing file extensions could cause files to become unusable. Disregard this warning.
  5. You can store the (sophos.udl) file anywhere on your system or network.
  6. Double-click the (sophos.udl) file or you can optionally right-click it, and then click Properties. This opens the Data Link Properties dialog box. You are now ready to connect to your data source.
Testing connectivity to a SQL server
  1. When you have opened the data link properties select the Provider tab.
  2. From the list of OLE DB Provider(s) select ‘Microsoft OLE DB for SQL Server’.
  3. Click the next button to move to the Connection tab.
  4. Enter the SQL server’s hostname followed by a backslash (\) in the first box. E.g. windows2003server\sophos
  5. Under ‘Enter information to log on to the server’ select one of the radio buttons...
    • ‘Use Windows NT Integrated security’ if the SQL server uses Windows authentication 
    • ‘User a specific user name and password’ if the SQL server uses SQL authentication.
  6. Under ‘Select the database on the server’ click on the drop down list to view the databases that are available.
  7. Select the require database and click the ‘Test Connection’ button.
  8. If necessary record any error seen and forward to technical support. Otherwise click OK to close the properties window and save the connection settings.

Video shows the procedure on a Windows Server 2003


thank you for the feedback

Per maggiori informazioni o per assistenza, vi preghiamo di contattare il supporto tecnico.

Valutate l'articolo

Molto scadente Eccellente