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.

Tuesday, May 10, 2011

Rendering HTML in SSRS 2008 Reports

Some of the data in my report was stored with simple HTML formatting tags.  It turns out that the expressions I had on my report was already a “placeholder” and SSRS Placeholders have the ability to set the Markup Type to “HTML – Interpret HTML tags as styles”.

Note:  I had to click THREE times on the expression to drill past the Rectangle and Text Box containers to finally select the expression placeholder.