Cannot create a connection to data source Data source for shared dataset. Login failed for user NT AUTHORITY\ANONYMOUS LOGON

Issue:

While Configuring the SSRS

• Reporting Database in Report Database Server A
• SSRS was configured and accessed the Report Database Server A from Report Server B.
• Accessed the Server using the windows authentication the same windows AD account was used across all the server.
• The Report Server B is configured and it was accessing Report Database Server A without any issues.
• Using the (sql server business intelligence development studio) Created a new report in Report Server B and tested locally and it was working fine. It was checked with IE too.
• When I tried to access the Report from Other Machines which resides in the same domain received the following error.

----------------------------------------------------------------------------------------------------------------------------------

An error has occurred during report processing. (rsProcessingAborted)

The execution failed for the shared data set 'DataSet1'. (rsDataSetExecutionError)

Cannot create a connection to data source ' Data source for shared dataset'. (rsErrorOpeningConnection)

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

----------------------------------------------------------------------------------------------------------------------------------

• We tried to do all kind of changes on the Windows user account but it got failed.

Solution:

• Created new User with "SQL Server Authentication" and assigned to the Database (Read only) permission.
• Modified the Data Source Configuration in BIDS at (Report Server B) and updated with SQL Server User Authentication
• Rebuild and Deployed the reports
• The reports are started working perfectly and we were able to access the Reports from all the machines.

Hope this will be helpful…

Thanks & Regards,

Karthikeyan Jothi.

"You Never Fail Until You Stop Trying"