Error Recieved When Creating Custom SCCM Report

[tcilmo]

In my SCCM environment, system administrators have two different user accounts. A civilian ID and an administrative ID. When I attempt to create a custom report through the SCCM Console with my civilian ID, I receive the attached error, but when I attempt to create a custom report through the SCCM console with my administrative ID, I don’t receive the error. My administrative ID is assigned the "Full Administrator" Role. My civilian ID is not "usually", but in an attempt to troubleshoot I have given it the "Full Administrator" Role too. I still receive the error when using my civilian ID. (Plenty of time has passed to allow the permissions changes to take effect.)

 

I am assuming there are some separate permissions in SQL that is causing this behavior, but not sure. I personally don't know much about SQL so I hope someone in the community could help me fix and understand why I am receiving this error. The main goal is to be able to allow other individuals the ability to create custom SCCM reports that are not system administrators. I inherited the current configuration was not involved in the initial conception of our environment; thus, I may not be able to answer some questions.

 

 

 

System.NullReferenceException

Object reference not set to an instance of an object.

 

 

Stack Trace:

at Microsoft.ConfigurationManagement.Reporting.Internal.SrsReportServer.DeployReport(String reportName, String reportPath, String reportDescription, String dataSourcePath, Byte[] reportRdl)

at Microsoft.ConfigurationManagement.AdminConsole.SrsReporting.ReportDeploymentAgent.DeployReport()

at Microsoft.ConfigurationManagement.AdminConsole.SrsReporting.CreateReportWizard.ApplyModelBasedProcessing(BackgroundWorker worker)

at Microsoft.ConfigurationManagement.AdminConsole.SrsReporting.CreateReportWizard.PostApply(BackgroundWorker worker, DoWorkEventArgs e)

at Microsoft.ConfigurationManagement.AdminConsole.ProgressPage.backgroundWorkerPostApply_DoWork(Object sender, DoWorkEventArgs e)

at System.ComponentModel.BackgroundWorker.OnDoWork(DoWorkEventArgs e)

at System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object argument)