Test SQL database connectivity with test.udl file

[Daniele_Purrone]

For database connection issues, you can use the test.udl file to confirm the database credentials used to access the SQL database.

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 below instructions to test connectivity between Qlik Server and Database Server. You need to run 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.

Results:
The Microsoft Data Link dialog box should display 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.