CRM 4 unable to generate reports - An error occured

We migrated from CRM 3 to CRM 4 a week or two ago and all functionlity was working after deployment.  We especially took notice to ensure our Reports were generating properly.

Now when we generate reports we get the error which I attached from a screeen shot.
crmreporting.jpg
sknoll84Asked:
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.

sknoll84Author Commented:
I realized that CRM reporting was working fine until we had to make some URL changes because the Outlook addin install was failing.  Now our Outlook addin is working properly because we were able to sort out the certificate problems, but reporting is broken.

I hopped into Deployment Manager and disabled the organization.  I then did an EDIT on the organization.  Here it asks for the Microsoft Dynamics CRM SRS Data Connector URL.  Currently we have http://servername/reportserver listed, but this doesn't even work in a browser so I know this is incorrect.

If I browse to https://organizationname.companyname.com/reportserver this works fine.
But when I list that URL into Deployment Manager, it fails to validate the specified Reporting Services Report Server.  The request failed with HTTP status 401: Unauthorized.

0
WilyGuyCommented:
SRS is on the same box as CRM or different?

Is the same redirector being applied to that website?
0
sknoll84Author Commented:
srs is on the same box, yes.  No redirection is in place for the https://organizationname.companyname.com/reportserver url as it is the primary crm url (organization name---needed for the external facing deployment).  We only have a redirection in place for https://crm.companyname.com as it is easy for our sales people to remember.  

for whatever reason when we try to update the srs url in the deployment manager it throws the unauthorized error.
0
Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

WilyGuyCommented:
there is a registry key in the HKLM|Software|Microsoft|MSCRM that has the same information (look for the old SRS URL and try to update it there).

Do you have the two app pools running with different identities?  if so, did you install the SRS Data Connector?
0
sknoll84Author Commented:
I did update the registry keys for [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSCRM\ServerUrl] and [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSCRM\SQLRSServerURL] to reflect the correct url.

I will check on the app pools and get back with you
0
sknoll84Author Commented:
i just verified that both the crm website and reportingservices virtual directory (under the crm site) both are in the same app pool.  however when i run a test connection on the report server, it fails during the authorization test...see error below....

The server is configured to use pass-through authentication with a built-in account to access the specified physical path. However, IIS Manager cannot verify whether the built-in account has access. Make sure that the application pool identity has Read access to the physical path. If this server is joined to a domain, and the application pool identity is NetworkService or LocalSystem, verify that <domain>\<computer_name>$ has Read access to the physical path. Then test these settings again.
0
WilyGuyCommented:
I assume you didn't set the ServerUrl to the SRS url, right?

so you have specified that SSL is required on the website that encompasses both? (is that website on port 80 or is your redirect site)?
0
WilyGuyCommented:
And all the current work is being done on the server (you are testing using the Internet Explorer on the CRM server?)

That's a good place to start, but be sure to test from external clients AFTER that.

Likely you will have to alter the DataSource in Report Manager, but don't do that yet.
0
sknoll84Author Commented:
Your assumption is correct, the correct urls are in the registry. Yes, ssl is required, hence port 443.  The other website on the server listens on port 80 and redirects to the correct mscrm url.
0
WilyGuyCommented:
I know we had the SQL query in a previous post, can you refresh my memory on those results?
0
sknoll84Author Commented:
organizationname.companyname.com
organizationname.companyname.com
organizationname.companyname.com
https



0
WilyGuyCommented:
You may have to reconfigure SRS as when you set it up, likely you weren't using SSL and the relative paths aren't correct.

Can you open https://organizationname.companyname.com/reports ?

There is a flag in the configuration to indicate you are using SSL and it prompts you for the cert.
0
sknoll84Author Commented:
when we browse to that url we get:
Error
The attempt to connect to the report server failed.  Check your connection information and that the report server is a compatible version.

what route would you go to reconfigure SRS?
0
WilyGuyCommented:
There should be a SQL Reporting Services configuration wizard in the Start | Programs | Microsoft SQL Server (or something like that)

Don't worry about the Database or the Windows Service.  Focus on the Reports and ReportServer tabs. (likely it will seem to screw up the Web Service, but that is easily fixed).

I believe the SSL is on the ReportServer tab.
0
sknoll84Author Commented:
See attached screen shot.  Within the config wizard there is a Report Server Virtual Directory and Report Manager Virtual Directory tab.

Report Server Virtual Directory gives us an option to check SSL.  I listed the certificate name and applied the changes.  The other tab does not give you any SSL options.

I restarted SQL services and tried to generate a report in CRM but receive the same error.
Maybe additional services need restarted, or did I list the certificate name wrong?
crm1.jpg
0
WilyGuyCommented:
The certificate name should be the organization.companyname.com
0
sknoll84Author Commented:
cert name was changed within the config wizard, services restarted, no dice.
does the cert need to be renamed anywhere else?
0
WilyGuyCommented:
Does Report Manager work?  basically CRM isn't likely to work until Report Manager works.

There is a config file in the Report Manager directory that indicates the URL for the Report Server.
0
sknoll84Author Commented:
while googling the report manager error, I found a site that recommended updating the RSWebApplication.config file under the <sql home>/reporting services/reportmanager.......i updated the reportserverurl.......  output below...note* url has a placeholder for security reasons

<Configuration>
      <UI>
            <ReportServerUrl>https://orgname.companyname.com/ReportServer</ReportServerUrl>
            <ReportServerVirtualDirectory></ReportServerVirtualDirectory>
            <ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
      </UI>
      <Extensions>
            <DeliveryUI>
                  <Extension Name="Report Server Email" Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailDeliveryProviderControl,ReportingServicesEmailDeliveryProvider">
                        <DefaultDeliveryExtension>True</DefaultDeliveryExtension>
                        <Configuration>
                              <RSEmailDPConfiguration>
                                    <DefaultRenderingExtension>MHTML</DefaultRenderingExtension>
                              </RSEmailDPConfiguration>
                        </Configuration>
                  </Extension>
                  <Extension Name="Report Server FileShare" Type="Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareUIControl,ReportingServicesFileShareDeliveryProvider"/>
            </DeliveryUI>
      </Extensions>
      <Add Key="MaxActiveReqForOneUser" Value="20"/>
      <Add Key="DisplayErrorLink" Value="true"/>
</Configuration>
0
sknoll84Author Commented:
how can we test the report manager other than browsing to the url?  Also, on the "Reports" virtual directory, authentication types are "asp .net impersonation" and "windows auth"...keep in mind this is server 2008 and iis7
0
WilyGuyCommented:
OH.....did I miss that in other posts as well.  Server 2008 and IIS7 are relatively new, so that changes the googling a bit.

You may want to close this question, open a new one in the SQL arena (with CC to IIS and Server 2008 groups, not sure on the exact names, maybe even SSL).

I wouldn't make it a CRM question until Reports Manager is working correctly.

Or you can leave this one open and come back to it when all is well there.
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
sknoll84Author Commented:
I will open a new question in the SQL zone, but how exactly should I go about this new question....?

I understand we need to ensure report manager is working properly, but what all should we see working before we begin talking CRM again?
0
WilyGuyCommented:
Well, lay out your OS and IIS versions, the fact that you are requiring SSL for Reporting services.  Your Report Manager doesn't work and gives you X error.

Once ReportServer comes up on the SSL from a different box AND the Reports (Report Manager) come up fine, I think we are safe to come back to CRM.
0
sknoll84Author Commented:
Im going to go ahead and give you the points since you stuck it out so long.  In the end we involved Microsoft.  Their SQL and CRM teams were both involved.  It got pretty in depth and I really can't say what the final solution was.....thanks for your assistance.  After the /reports url was resolved, there was a Data Source that had to be changed.
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
Microsoft Dynamics

From novice to tech pro — start learning today.