Microsoft CRM 3.0 Error when clicking on Reports

We have a MS CRM 3.0 setup and when we go to the Reports section in the CRM interface we get an error message, See Below. Any help on this would be great as I have gone over every Microsoft article I could find to try and figure this out. What our setup looks like is we have a server with CRM installed and a 2nd server with SQL 2005 and Reporting services installed. If I connect to the Reporting services server I can login and look at the reports that I should be able to run from the CRM interface.

Error:
------------------------------------------------------------------------
Microsoft CRM Unhandled Error Details:
Server Error in '/' Application.
--------------------------------------------------------------------------------

The request failed with HTTP status 401: Unauthorized.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Net.WebException: The request failed with HTTP status 401: Unauthorized.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.  

Stack Trace:


[WebException: The request failed with HTTP status 401: Unauthorized.]
   System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall) +1296
   System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters) +218
   Microsoft.Crm.ReportingServices.ReportingService.GetResourceContents(String Resource, String& MimeType) +48
   Microsoft.Crm.Reports.ReportCache.get_CategoryList() +401
   Microsoft.Crm.Reports.Home.ConfigurePage() +918
   Microsoft.Crm.Application.Controls.AppPage.OnPreRender(EventArgs e) +20
   System.Web.UI.Control.PreRenderRecursiveInternal() +62
   System.Web.UI.Page.ProcessRequestMain() +1499

 
Jesse_SparksAsked:
Who is Participating?
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.

bmosoftwareCommented:
This looks very much like an authentication problem. My immediate concern is that you say you can login to the report server and see the reports, you should not have to login if it is correctly using integrated authentication, if you are needing to login then CRM will not be able to access the report server and would give the error you are referencing here.
0
Jesse_SparksAuthor Commented:
Sorry for the confusion I see what you are saying. Integrated Auth is working and I can open each site without needing to enter a login crm = http://crm, and Report server = http://sqlsrv/reports 
0
bmosoftwareCommented:
Can you confirm that you have looked through the following Microsoft articles : 907487, 921546 and http://www.microsoft.com/downloads/details.aspx?FamilyID=51bf9f20-bd00-4759-8378-b38eefda7b99&DisplayLang=en
0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

Jesse_SparksAuthor Commented:
We fall under Path A in this document and I have done everything that it said. We installed the CRM and SQL server logged in as a domain admin and the CRM App on IIS is using the Network Service identity. Our Domain level is 2000 mixed as well.
0
Jesse_SparksAuthor Commented:
Okay I have rebooted both servers and now when I go to reports the list of reports does show up. Now the problem is that when I click on a report to run it it asks for the vaules for the report and then on the next screen it askes for a username and password, no matter what I put in that field it will not work.
0
bmosoftwareCommented:
Have a look at this, it has solved a similar problem for us before : http://support.microsoft.com/kb/871179
0
Jesse_SparksAuthor Commented:
Okay I found an article that talks about Checking the connection string value in the Reporting services setup and I have gone into that area and the connection string for the CRM is blank but I do not know what should be in that box. Please help.
0
bmosoftwareCommented:
Here is a sample Data Source Screen for CRM
Untitled.jpg
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
Jesse_SparksAuthor Commented:
Thank you very much that did it now they work again. Thanks.
0
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
Enterprise Software

From novice to tech pro — start learning today.