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

Close Open Files in Isilon

To close Open files in Isilon Sometimes we may have to Close open files on Isilon , This is how we can accomplish it First find all the Open Files using the Following Command: isi_for_array  "isi smb openfiles list" To Narrow the search  we can grep the result  as an example isi_for_array  "isi smb openfiles list" | grep -i abc Once you find the files the 6 digit number is the id for that open file. To close the open file run the following command isi_for_array isi smb openfiles close "123456" -f Hope this helps
2 comments
Read more