SCCM 2012 – Unable to view reports via SCCM, Log on failed

SCCM 2012 – Unable to view reports via SCCM, Log on failed

Hi All,

recently i was at a customer site trying to run reports from the SCCM console and it was failing with login failed.

Looking at the reporting logs, i saw the following “ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedExecution: Logon attempt for user ‘xxxxxx’ failed., Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException: Log on failed. Ensure the user name and password are correct. –> System.ComponentModel. Win32Exception: Logon failure: the user has not been ranted the requested logon type at this computer.

And looking at the error, it seems obvious, i typed the wrong username/password. I’ve checked it and tested and everything should be working, however, I was not sure about the AD replication. Anyway, i waited many hours just to be sure and the issue was still there.

After this, i used rsop.msc to check what policies where being applied and noticed that the Logon Locally policy was set and looking at the membership rules, i noticed that the SQL Server Execution Account was not there as well as nor any of the groups that account was member of.

Adding the account to the correct group, everything started working, so, if you’re getting this, remember to add the account to the “Allow logon locally” as well as make sure the account are not part of the “Deny log on locally”.

About

Raphael is a 9 times Microsoft MVP with over 20 years of experience in IT, in which 13 years have been dedicated to System Center and Automation. His extended experience has been developed through several IT roles, from first-line support to principal consultant, towards a wide range of clients and sectors. One of the four MVPs in Enterprise Client Management in the UK, Raphael holds more than 30 Microsoft certifications and is an MCT (Microsoft Certified Trainer). Since 2008, Raphael has been providing Microsoft trainings from basic to advanced levels in several categories. Throughout his career, Raphael has joined as speaker in well-known events such as TechEd and Gartner Security Risk Management. He also organised community events and lectured around the world, sharing best practices and knowledge within the industry. Bilingual in English and Portuguese, Raphael has authored diverse articles published in Microsoft's TechEd, served as the editor-in-chief of a magazine focused on System Center in Brazil and wrote two books: "Understanding System Center 2012 SP1 Configuration Manager: The walkthrough book" and "System Center 2012 R2 Configuration Manager: Automation from Zero to Hero".

Tagged with: , , , , , , ,