Skip to main content

SCOM Custom reports Event ID 18456

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 provided an account that had permissions on OperationsManager DB


Hope this Helps.

Labels:

Comments

Post a Comment

Popular posts from this blog

Group Policy Object did not apply because it failed with error code '0x80070534 No mapping between account names and security IDs was done

One of our servers was losing the Local Admin settings as we control them using GPO (restricted Groups) We were receiving the following event on this particular server : Event ID 4098 Application Event Log The computer 'Administrators (built-in)' preference item in the 'Servers Local Admins {odjd9DBD-22AF-48EA-ADF5-F42ADE4182hst}' Group Policy Object did not apply because it failed with error code '0x80070534 No mapping between account names and security IDs was done.' This error was suppressed. To fix the issue we deleted all the folders from the following location and rebooted the server C:\ProgramData\Microsoft\Group Policy\History Hope this helps.
Post a Comment
Read more

iDRAC 7 Shows no Signal in Virtual Console Preview

Recently i logged on to iDRAC for one of our Dell R720 servers,however somehow the console redirection did not work at all. I kept on seeing No Signal on the Virtual console Preview. I tried Rebooting the server but that did not help. Finally i clicked on Reset iDRAC and this did the trick. It may take around 2 -5 minutes before you can access iDRAC page again. I had to power on the server through iDRAC before anything showed up on console. Hope this Helps.
3 comments
Read more

Citrix XenApp 6.5 Discovery fails Event 3989

Citrix XenApp 6.5 Service account password change caused console discovery to fail and we saw event ID 3989 in System Event logs "Citrix XenApp failed to connect to the Data Store. ODBC error while connecting to the database: 28000 -> [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed. The login is from an untrusted domain and cannot be used with Windows authentication." After changing the service account password needed to run the following command on the delivery controllers. DSMAINT CONFIG /user:abc\ABCSVCCitrix /pwd:nP@ssword /dsn:"C:\Program Files (x86)\Citrix\Independent Management Architecture\mf20.dsn" Restart IMA service You should now be able to run the discovery successfully Hope this helps
Post a Comment
Read more