Friday, May 20, 2011

CRM 4.0 SRS Connector "Same Account" Setup Error

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.

No comments: