After performing my steps for troubleshooting SSRS issues in CRM, I realized my CRM environment was having a double-hop error saying
Cannot create a connection to data source 'Portal'.
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'
I was getting an error while trying to install the CRM SRS Connector:
A Microsoft Dynamics CRM Server component is using the same account as the instance of SQL Server Reporting Services
My SSRS Service was running as Network Service. I changed it to run as an AD user account that has database permissions and that took care of the setup error and SRS connector completed.
After changing the CRM SSRS Data Source I got an error saying:
Login credentials not being passed for one or more data source
Then I remembered my CRM was on Rollup 11, so I installed the SRS Rollup 11. After an IISRESET my reports finally came up.
Posts
No comments:
Post a Comment