Overview

This article shares the process to test the connectivity to SQL Server using ODBC (Open DataBase Connectivity).

Process

Follow these steps to test the connectivity:

1. Login to the GFI Product Server with the account you are using to run your GFI Product.
2. Create a blank text file and name it Test.UDL, and save it on the desktop.
3. Double-click to open the file. 
4. It will open a Data Link Properties box.
5. Go to the Provider tab, choose Microsoft OLE DB Provider for SQL Server.
6. Click Next.
   
   
   
   
7. On the Connection tab, choose (or type in) the ServerName\InstanceName. 
   • In this example, it is: GFITEST\FLIMFLAM  
   • Note: If SQL Management Studio is installed, users can view this on the 'Connect to Server' login window.
     
     
8. Select Use Windows NT Integrated Security.
   •  If you are using Windows Authentication to connect to SQL or Use a specific user name and password choice if the user is using SQL Authentication.  
   • In this example, we are using the 'sa' credentials.
     
     
9. Click the drop-down arrow in 'Select the database on the server' choice and choose a database to audit.  
   
   
10. Click the 'Test Connection' button.