Kitaab

We faced an issue where in the users who were part of the  SCOM 2012 Report Operators were unable to run some Custom Reports. These reports were using a Custom DataSource created for the OpsMgrDB Whenever user tried to open the report ,we received following alert on the SQL Reporting server. he Permission on SSRS is "System User" for 2537B367-6D74-4110-B0B5-1F51C1B1B09E Log Name:      Application Source:        MSSQLSERVER Date:          10-05-2013 15:41:01 Event ID:      18456 Task Category: Logon Level:         Information Keywords:      Classic,Audit Failure Description: Login failed for user 'Domain\User01'. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT: <local machine>] This is what we did and it worked for us: In the Datasource we modified the Connect using:: Windows integrated security  to Credentials stored securely in the report server

We faced this issue with  SOCM 2012 SP1  very recently. I received an alert the Operation manager resource pool has some issue , checked and found that the SDK and Data Access Service (OMSDK) and System Center Management Configuration were stopped on one of the management servers and do not start at all. When i try to start them manually , it comes up with the the message as shown: I saw the following Events on the Management servers: Event ID: 1000 Faulting application name: Microsoft.EnterpriseManagement.Monitoring.Console.exe, version: 7.0.9538.0, time stamp: 0x50903ed4 Faulting module name: KERNELBASE.dll, version: 6.1.7601.18015, time stamp: 0x50b8479b Exception code: 0xe0434352 Fault offset: 0x0000000000009e5d Faulting process id: 0x1d3c Faulting application start time: 0x01ce41887f1cbc6c Faulting application path: X:\Program Files\System Center 2012\Operations Manager\Console\Microsoft.EnterpriseManagement.Monitoring.Console.exe