CRM 2011 Reporting Service Failure
First off, I am a novice so please be thorough in your responses. I have migrated my CRM 4.0 production server to a new server and upgraded to CRM 2011. The migration went smooth and nothing seemed to error out (things that did were fixed immediately). Post installation I have the following problem: I cannot run any reports within CRM (customized or built-in). This leads me to believe that the problem is with the SQL Reporting Service. On customized reports, I get the following error: Reporting error the report cannot be displayed (rsReadOnlyReportParameter). On built-in reports, I get the following error: Reporting error the report cannot be displayed (rsProcessingAborted) I looked at the event viewer on my server and there is a 1309 event and 10996 event that is thrown every time. Any help would be appreciated, even suggestions on some of the simple things because I may have overlooked them.
April 7th, 2011 5:51pm

Hi I had the exact same problem, I fixed it by going to the SQL Reporting Service manager -> execution account -> uncheck "specify a execution account" hope that helps Mervyn KingMCP, MCSA, MCSE, MCDBA, MCTS, MCBMSS, MCBMSP, MCT
Free Windows Admin Tool Kit Click here and download it now
April 14th, 2011 3:03am

How is your sistem configured? Under which accounts are your services running (reporting services, CRM services)? There are some changes with IIS 7 which could lead to your problems if you have registered SPN's for your new CRM server. I had simmilar problem in my enviroment, with reports and CRM Outlook client. The following helped me solve both of them: http://social.msdn.microsoft.com/Forums/en/crm/thread/995cf557-ae16-4379-8f9d-d6cd64295ba4
April 14th, 2011 8:19am

Thanks for helping Mervyn but that didn't do it. Same errors still.
Free Windows Admin Tool Kit Click here and download it now
April 15th, 2011 2:50pm

For right now I have all services running under the Domain Administrator. I know this is not best practices, but I just want to get everything working first. I usually play around with permissions after I get it running under the Domain Admin, that way I can systematically lock it down before I put it back into production. As well, I know what breaks when I change it, etc. I read your post that you linked above and I am a little confused by it. If I navigate to C:\Windows\System32\inetsrv\config then I find 3 different config files: 1) ApplicationHost.config 2)Administration.config 3)Redirection.config. I assume you are meaning the ApplicationHost.config file, but I am not 100% sure. As well when I edit the file and search <security> i find a bazillion different places for that. I noticed a correlation between the location path equaling one of my hosted sites, including several for CRM. So my question becomes, what exactly am I supposed to modify and where? Thank you for your help.
April 15th, 2011 3:12pm

If you are running crm under domain user account, you should modify applicationhost.config. You should review installation documentation again while this is better documentated in there. For all folders under the Default Web Site location path, set the value of the WindowsAuthentication element and the useAppPoolCredentials attribute to true. For example: <system.webServer> <security> <authentication> <windowsAuthentication enabled="true" useAppPoolCredentials="true" /> </authentication> </security> </system.webServer>
Free Windows Admin Tool Kit Click here and download it now
April 18th, 2011 3:41am

Thanks a bunch. This worked exactly as stated. Wierd that the execution account worked just fine in the CRM 4.0 instance but not in the 5.0 with no changes besides upgrading the DB to 5.0.
April 20th, 2011 6:53pm

Change is in IIS - enable kernel-mode authentication option
Free Windows Admin Tool Kit Click here and download it now
May 10th, 2011 4:42pm

It'll be some time before I get back to this to test. Thank you for your help, and I will update as soon as I have the ability to. I am out of town on another project at the moment.
May 18th, 2011 1:49pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics