CRM 2011 – SSRS – The target principal name is incorrect

2017-12-11T16:16:48+00:00 January 28th, 2013|CRM|0 Comments

Encountered this issue a few times when deploying CRM over multiple servers then trying to run reports/custom reports through the standard report builder , solution:

– Open IIS on the server CRM 2011 is installed on
– Expand the server name
– Click ‘Application Pools’
– Look for ‘CRMAppPool’ and the account it’s running on (e.g. DOMAINCRMApp) and note down the account name.
– Log into your CRM SSRS server
– Open CMD Prompt as administrator and run the following command: ‘setspn -a http/SERVERNAME DOMAINIISACCOUNT’ (IIS Account being the application pool account you noted down from IIS)

Once you’ve done this, you should be able to run reports without getting the Target SPN error in the SSRS logs.

Cheers,

Jason.

Leave A Comment

like what you see? 

Sign-up to our newsletter and never miss out on the latest blogs, events and tech news from the world of risual
SUBSCRIBE!
Give it a try, you can unsubscribe anytime.