Microsoft has built a SQL Connectivity tool right into Windows with the creation of Microsoft Universal Data Link files (*.UDL). UDL test enables you to test connectivity to your SQL database outside of AirWatch tools like Enterprise Discovery Utility or an AirWatch Installer.
Create the data link (UDL) file
- Right-click the Windows desktop, point to New, and then click Text Document. A new file is created by default (New Text Document.txt).
- 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. For Windows Server 2008, you can access Folder options by opening Windows Explorer, clicking Organize and then Folder and search options.
- Right-click the Text Document you created in step 1, choose Rename, and then change the name and extension of the file to: AirWatch.udl
- A warning might appear, explaining that changing file extensions could cause files to become unusable. Disregard this warning.
- You can store the (AirWatch.udl) file anywhere on your system.
- Double-click the (AirWatch.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.
NOTE: If you are using Windows Authentication to test connectivity and are not logged into the server with those Windows credentials, open the (AirWatch.udl) file by hitting ‘Shit+Right Click. In the credentials prompt, enter the Windows Authentication that you want to test with.
Testing connectivity to a SQL server
- When you have opened the data link properties make sure you are on the Connection tab.
- Enter the SQL server’s hostname (or IP Address)
Follow SQL server name by a backslash (\) in the first box if you are connecting to a named instance. E.g. windows2012R2server\ AirWatch
If you are using a custom port to connect to the database, follow the hostname with comma (,) port number. E.g. windows2012R2server,5433
- 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.
- Under ‘Select the database on the server’ click on the drop down list to view the databases that are available.
- Select the require database and click the ‘Test Connection’ button.