AppInsight for SQL credentials not working

In my shop we have used AppInsight for SQL on our Solarwinds DBs for quite some time.

Using credentials that I'll call MYDOMAIN\GeneralServiceAccount.

We use the general account for a number of different tasks; I wanted to create a special account for our DB monitoring in order to reduce the fault domain for password lockouts and other issues.

Created an account that I'll call MYDOMAIN\DbMonServiceAccount

I've set up host and DB permissions for the DBMon account exactly the same as for the general account, including downloading and running the sample SQL script from Thwack to set permissions.

Nonetheless, testing credentials for AppInsight for SQL these credentials fail (consistently).

As part of troubleshooting, I set up a custom application and pulled in a whole bunch of SQL components (like about 100) into that application. Testing against the DB server with the DBMon service account all tests successful.

Does anyone in the community have ideas for how I can next-step troubleshooting for this problem? Thanks much.

Find more posts tagged with

appinsight_for_sql

permissions

Accepted answers

All comments

jm_sysadmin

First check permissions
AppInsight for SQL requirements and permissions (solarwinds.com)

Then check the debug logs:
Turn on application debugging for SAM (solarwinds.com)

robert777

Thank you.

I have opened a case with Solarwinds support: ticket #01215578

I've reviewed the permissions requirements in the linked document. To the best of my knowledge permissions set up correctly.

I also generated debug logs for the AppInsight application. The problem is - the debug logs only provide information if the App actually runs under the replacement credentials. I tried modifying the credential for the running account and the test fails. The debug logs do not contain the name of the new account.

Hopefully Solarwinds support can shed some light on the issue.