Jump to content


A.Kassem

SCCM reporting service point SQL authentication

Recommended Posts

11 hours ago, GarthMJ said:

You can't, it need to be a AD/Windows account.

I got that error when trying to authenticate with domain user although it has log in access on DB and have all security needed .

 

Quote

An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot impersonate user for data source 'AutoGen__5C6358F2_4BB6_4a1b_A16E_8D96795D8602_'. ---> Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException: Log on failed. Ensure the user name and password are correct. ---> System.Exception: For more information about this error navigate to the report server on the local server machine, or enable remote errors

-------------------------------
Microsoft.ConfigurationManagement.ManagementProvider.SmsException
An error has occurred during report processing.


Stack Trace:
   at Microsoft.ConfigurationManagement.AdminConsole.SrsReporting.ParameterPresenter.GetParameters()
   at Microsoft.ConfigurationManagement.AdminConsole.SrsReporting.ParameterPresenter.LoadParameters(IReport report, Collection`1 navigationParameters, IResultObject resultObject)
   at Microsoft.ConfigurationManagement.AdminConsole.SrsReporting.ReportViewerPresenter.Worker_DoWork(Object sender, DoWorkEventArgs e)
   at System.ComponentModel.BackgroundWorker.OnDoWork(DoWorkEventArgs e)
   at System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object argument)

 

Share this post


Link to post
Share on other sites

7 hours ago, A.Kassem said:

Thanks for help , It only worked with domain admin account or a user that allowed to log on locally on SQL server . I don't know why it requires local admin privileges ??  

The account does NOT require admin rights that is for sure.

Share this post


Link to post
Share on other sites

23 hours ago, GarthMJ said:

The account does NOT require admin rights that is for sure.

Then what is the explanation it only worked with admin rights , In data store when trying AD user with SQL privileges required it fails to authenticate but when using windows integrated it successfully authenticate . 

Share this post


Link to post
Share on other sites

1 hour ago, A.Kassem said:

Then what is the explanation it only worked with admin rights , In data store when trying AD user with SQL privileges required it fails to authenticate but when using windows integrated it successfully authenticate . 

I'm not following you, please post a screenshot.

 

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...


×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.