Error loading statistics

[bbobo]

Hello we recently setup our production environment and are getting the error "Error loading statistics. Please check the database connection string." when on the Home page and the Reports page.

I've gone through all the steps here: [DECIPHER] How do I fix error "Error loading statistics. Please check the database connection string." when opening the Decipher web client interface? with no luck. The environment setup should be the exact same as our test env and we do not get the error there (the only differences is we encrypted data at rest for prod when doing the server install). 

We are using windows auth to connect via a service account. All the connection strings look correct and the service account is set as the user for the Decipher Application Pool in IIS Manager. I can also grab data from the decipher database using queries and authenticating with the same service account.

I should also mention that everything else seems to be working in Decipher besides the statistics data.

[bbobo · Accepted solution]

I figured it out! Really dumb reason... I didn't have a space between "Integrated" and "Security" in the connection string. After adding one it worked.

[Ben.Lyons1]

Hi Ben B,

Easily done, glad you got it working!

Thanks

Ben L