Skip to main content

Qlik Sense or QlikView reload fails on rim node: ErrorMsg: SQL Server does not exist or access denied

No ratings
cancel
Showing results for 
Search instead for 
Did you mean: 
Sonja_Bauernfeind
Digital Support
Digital Support

Qlik Sense or QlikView reload fails on rim node: ErrorMsg: SQL Server does not exist or access denied

Last Update:

Aug 4, 2023 3:10:21 AM

Updated By:

Sonja_Bauernfeind

Created date:

Aug 4, 2023 3:10:21 AM

An app or document reload fails on a rim node, with the following error being logged in the document log:

ErrorSource: Microsoft OLE DB Provider for SQL Server, ErrorMsg: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied

This only happens on the rim node. The reload works when executing on a central node.

Resolution

The error indicates a network communication issue. Firewalls or specific application security on the database server prevent the rim node from accessing it.

Contact your database administrator to have the permissions or rules adjusted to match those for the central node. 

For more information: Troubleshoot connectivity issues in SQL Server | Learn.microsoft 

 

Environment

Qlik Sense Enterprise on Windows 
QlikView 

Labels (1)
Version history
Last update:
‎2023-08-04 03:10 AM
Updated by: