SCCM reporting service point SQL authentication

[A.Kassem]

How can I use SQL user authentication for SCCM 1606 reporting service point it's only available with Windows account authentication like attached image

 

 

[GarthMJ]

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

[A.Kassem]

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)

 

[GarthMJ]

So did you enable remote errors like it suggests?

https://www.enhansoft.com/blog/turn-on-remote-error-reporting

[A.Kassem]

23 hours ago, GarthMJ said:

So did you enable remote errors like it suggests?

https://www.enhansoft.com/blog/turn-on-remote-error-reporting

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 ??  

[GarthMJ]

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.

[A.Kassem]

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 . 

[GarthMJ]

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.