topic Error loading statistics. Please check the database connection string : how to resolve? in Product Forum

Error loading statistics. Please check the database connection string : how to resolve?

John_GilbertDu1 — Tue, 09 Feb 2021 03:52:50 GMT

We are using different SQL server and did not use the default server from the installation guide (which is to use SQL server express).

The error "Error loading statistics. Please check the database connection string" appears to all of the selections from the Reports tab. After a few seconds, the error message disappears but the dashboard is just loading forever and not displaying anything. Is there a way to configure the DB connection string without reinstalling Decipher again?

Re: Error loading statistics. Please check the database connection string : how to resolve?

ramonnunez — Fri, 12 Feb 2021 02:58:19 GMT

Hi John,

This occurs when you have windows authentication for the SQL User (Integrated Security=True) in your connection string and the identity pool of decipher is using local system. In order for IIS server access correctly the database to do the reporting it needs to run the identity pool under the same user. More information on the article below:

[DECIPHER] How do I fix error “Error loading statistics. Please check the database connection string.” when opening the Decipher web client interface?