As an administrator of ePolicy Orchestrator from time to time I need check connectivity to Microsoft SQL server to validate that my ePO server can connect to the database. An easy way to test the connectivity is by creating a Microsoft Data Link file (udl).
Today I am going to show you how to create a udl file and how to test the connection from ePO server to SQL server.[adsense float=’center’]
- To create a .udl file right click on your desktop, select “New”, then select “Text Document”.
- Rename the file from .txt to test.udl.
- Windows will prompt if you really want to change the extension of the file, select “Yes”.
- Next double click on the test.udl file.
- On the provider tab, make sure to select “Microsoft OLE DB Provider for SQL Server.
- On the connection tab, for line 1. Insert the name of the SQL server or IP, line 2 the user and password and online 3 click on the drop down menu.
- The drop-down menu should show all the database available to that user.
If the ePO database is showing on the drop-down menu the user and password used can connect to the SQL database. If you don’t see the ePO database either the user don’t have the require permission or the UDL test is unable to connect to the database on the default port.
Note: using the SQL server host-name or IP address only verifies that we can connect to the SQL server database on the default port (1433).
If you want to test the connection on a specific port you must add servername\SQLinstance\portnumber (e.g. ogdc-01\MSSQLSERVER,1433). Once again, you should be able to see the ePO database on the drop-down menu.
This concludes the procedure on how to test the connection to SQL server using a udl file. If you have any questions or comments please let me know.