-
Title
Error accessing reports: "Unable to open database connection: [DBNETLIB][ConnectionOpen (Connect( -
Description
Error when trying to access the Reports remotely from the IIS Server:
"Unable to open database connection:
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied"
-
Cause
Users Group doesn't have rights to access the QMSReports.udl File used to render Reports.OR
The Path to the QMSReports.udl file is not properly specified in the registry
-
Resolution
Confirm that the Users Group has Read and Read & Execute permissions to the QMSReports.udl file created to connect to the remote Database Server from the Reports Server. The QMSReports.udl file is located in the MessageStats installation directory:
Program Files\Quest Software\MessageStats for 32bit servers
OR
C:\Program Files (x86)\Quest Software\MessageStats for 64bit servers.Also Confirm that the following Registry Key contains the correct path to QMSReports.udl:
HKLM | Software | Quest Software | MessageStats | ClientDB | SQLConnect