CRM 4.0 Reporting Error

We have MS CRM 4.0 installed on the same server as SQL Reporting and SRS Data Connector.  When I try to run reports from server or workstation, get "Report could not be displayed" error.  In Event Viewer, get 2 messages MSCRMReporting SoapException Login Failed, and an ASP .Net warning.  Have tried all fixes I have found on the web.  Nothing works!  Help!!
JSRichAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

tbsgadiCommented:
Have a look at the following:

http://support.microsoft.com/kb/946585

Gary
0
WilyGuyCommented:
My initial guess is that you don't have the SRS Data Connector installed?  It is on the CRM Media.  it will kick up a warning if you are running both the SRS App Pool and the CRM App Pool with the same account.  I believe you used to not be able to install it, but if you do the server updates, you can move past that and still install it.

Be sure to IISRESET after installation.
0
JSRichAuthor Commented:
Thank you for your replies!  I have already tried the MS KnowledgeBase article.  The SRS Data Connector is installed, but when I installed it, it said that there was already an instance of Microsoft CRM connected.

When I try to run reports:  On the Workstation I get "Reporting Error: The report cannot be displayed";  In the Server's Event Logs I get 3 entries:  "Error!  Web service request GetDataSources to Report Server http://myserver:8085/reportserver failed with SoapException Error: Logon failed (rsLogonFailed)", "Error!  Web service request GetDataSources to Report Server http://myserver:8085/reportserver failed with SoapException Error: The path of the item '/company_MSCRM/4.0/' is not valid.  The full path must be less than 260 characters long; other restrictions apply.  If the report server is in native mode, the path must start with a slash (rsInvalidItemPath)", and "Warning!  ASP.NET 2.0.50727.0  Event Code: 3005  Event Message: An unhandled exception occurred.  Event Time: timestamp  Event ID: 54eb648a8781453c9dff40d13c413605  Event Sequence: 2052  Event Occurrance: 1  Event Detail Code: 0"

We are running the CRM on a specified port.  And I know that the second error message is incorrect because I can browse to it from http://myserver:8085/reportserver (although this does take a long time to come up).  I have tried setting the permissions on the NETWORK SERVICE, I have tried looking for duplicate entries for MSCRM Extensions, I have even tried editing the connection string in the report itself (it has the MSCRM database as Adventure_Works_Cycle_MSCRM), still no luck.
0
JSRichAuthor Commented:
Finally fixed it!  Was a combination of several things:

Modify the Microsoft Dynamics CRM 4.0 web.config file so that SQL Server Reporting Services ignores the Microsoft Dynamics CRM 4.0 error - http://support.microsoft.com/kb/948012

Do not specify an Execution account in Reporting Services (having a yellow exclaimation is correct)

Creating correct groups in Active Directory Users and Computers - went to http://myserver:8085/reports, clicked on Security, saw what domain groups had permissions (they were listed, but did not actually exist).
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Server Apps

From novice to tech pro — start learning today.