We're facing an issue opening a random SQL Dashboard in SCOM 2012 R2 CU6. When logging in as a user in the 'Operator' or 'Author' role no states are displayed in the dashboard. The following error is logged in the Operations Manager Eventlog:

Log Name:      Operations Manager
Source:        OpsMgr SDK Service
Event ID:      26319

An exception was thrown while processing GetSettingsDataSet for session ID uuid:87224f94-d9d9-4427-97e7-4a84f98300c7;id=1.
 Exception message: The creator of this fault did not specify a Reason.
 Full Exception: System.ServiceModel.FaultException`1[Microsoft.EnterpriseManagement.Common.UnauthorizedAccessEnterpriseManagementException]: The creator of this fault did not specify a Reason. (Fault Detail is equal to Microsoft.EnterpriseManagement.Common.UnauthorizedAccessEnterpriseManagementException: The user domain\user does not have sufficient permission to perform the operation.).

The end-user is seeing the following screen:

Thanks in advance.

Regards,

Remco

Hi,

Please try the following steps:

ADSI Edit -> OpsMgrSDKConfig account properties -> security -> advanced -> permissions -> SELF -> edit -> Properties -> This object only -> select and allow two permissions:

1. Read servicePrincipalName

2. Write servicePrincipalName

click OK three times -> Close ADSIEdit

Hi,

Thanks for your feedback, the SDK service is running under the local system account. I've updated the Computer account to allow read/write access to the servicePrincipalName and rebooted the server. Unfortunally this did not solve the issue.

Below an screenshot of the SCOM services:

Regards,

Remco Ottens

• Edited by Remco Ottens 22 hours 36 minutes ago

Hi,

Thanks for your feedback, the SDK service is running under the local system account. I've updated the Computer account to allow read/write access to the servicePrincipalName and rebooted the server. Unfortunally this did not solve the issue.

Below an screenshot of the SCOM services:

Regards,

Remco Ottens

• Edited by Remco Ottens Friday, July 31, 2015 8:35 AM

Hi,

Thanks for your feedback, the SDK service is running under the local system account. I've updated the Computer account to allow read/write access to the servicePrincipalName and rebooted the server. Unfortunally this did not solve the issue.

Below an screenshot of the SCOM services:

Regards,

Remco Ottens

• Edited by Remco Ottens Friday, July 31, 2015 8:35 AM

Hi,

Please make the user as the local admin, possibly, then local admin will be having the right to access the SDK service. Additionally, provide the read only access to your user on the SCOM databases. 

As a best practice, your SDK and config service must run through SCOM SDK and config accounts and these accounts must be added in the SCOM administration users and these users must be having read only rights on the SCOM DBs.

Hi,

Thanks for your feedback.

I tried:

• Manually adding the SDK and Config Account to the 'Operations Manager Administrators' role
• Validated the accounts had at least SQL Read Only Rights
• Removed the local Administrator group from the 'Operations Manager Administrators' role
• Adding the user account to local admin on the SCOM server
• Reboot the server

Unfortunally this did not fix the issue.

Regards,

Remco Ottens

Hi Remco,

Let me know if your services SDK and Config are running through SDK and config account or through local service accounts?

As you removed your built in account from SCOM administrator role, then SDK and config services must be running with SDK and config accounts ?

Additionally, please perform al these tests in test or dev environment. Please refrain from implementing the same in your production environment.

There is another thread with the same exact issue. Also still not resolved. 

https://social.technet.microsoft.com/Forums/systemcenter/en-US/6df9f506-1f07-4a6c-9ab4-4d0e627659bf/event-id-26319-no-data-showing-in-sql-summary-dashboards?forum=operationsmanagerdeployment&prof=required