Test SQL database connectivity with test.udl file

[Daniele_Purrone]

To make troubleshooting database connection issues easier, you can use a test.udl file to confirm whether or not the database credentials and settings used to access the SQL database are correct.

Before you begin:

• You must know the SQL database server name and database name on the server.
• If you are troubleshooting Qlik database connection problems, you might see this error:
  
  Login failed for user. The user is not associated with a trusted SQL Server connection

Environment

• Qlik Sense Desktop, any 
• Qlik Sense Enterprise on Windows, any 
• QlikView, any

Please follow the below instructions to test connectivity between the Qlik Server and the Database Server. You need to run the test.udl on the Qlik Server hosted server.

1. On the Qlik application-hosted server, create a file named test.udl
2. Double-click the file you created to display the Data Link Properties user interface.
3. Click the Provider tab, select Microsoft OLE DB Provider for SQL Server from the OLE DB Provider(s) list, then click Next.
4. On the Connection tab, configure this information:
   • Select or enter a server name — Type the server name, instance, and port using this format <servername>\<instancename>,<port>.
     If no named database instance is used, use this format: <servername>,<port>
   • Enter information to log on to the server — Type the SQL database credentials.
   • Select the database on the server — Type the database name.
5. Click Test Connection.

The intended result is a Microsoft Data Link dialog box displaying Test connection succeeded.

The information in this article is provided as-is and to be used at own discretion. Depending on tool(s) used, customization(s), and/or other factors ongoing support on the solution below may not be provided by Qlik Support.