web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)

SQL Reporting services errors on new organization

(0) ShareShare
ReportReport
Posted on by 250

I'm at a loss over how CRM 2013 handles server names/name resolution. I did a fresh install including the first organization. During setup the name for the SQL Server Reporting Services that worked was 192.168.0.57/ReportServer . However, when I attempt to add another organization, I cannot seem to find the proper naming convention for the Reporting Services. Different names produce different errors:

- http://servername/ReportServer and 192.168.0.57/ReportServer produce "Error occurred while finding an item on the report server. The request failed with HTTP status 404: Not Found". Adding ":80" to the address does not help.

- http://FQDN/ReportServer produces "Microsoft Dynamics CRM Reporting Extensions must be installed on SQL Server Reporting Services for reports to work".

When entering the first two addresses in a browser, I get a 404. However, when using the FQDN, I am prompted for a username and password. Entering the CRM server admin credentials shows me folders for the existing organization. So my questions are:

- if ip address and servername don't work in a browser producing a 404, it makes sense to me that I can't use either one in the Deployment Manager. However, it tells me my first organization IS working with the ip address url. How?

- the FQDN url works in a browser, does not produce a 404 in the Deployment Manager, but tells me I need to install Reporting Extensions which are obviously already installed?

*This post is locked for comments

I have the same question (0)
  • Rajesh Ravindran Profile Picture
    on at

    You may have to raise a ticket with Microsoft CRM support for further investigation.

    Rajesh. R

  • Community Member Profile Picture
    on at

    Hi, I am having same problem. This is what I have done.

    1. I already had crm 2011 installed, and reports were running fine. SQL Version 2008 R2

    2. I upgraded to crm 2013, reports were running fine. (uninstall / install data connector)

    3. Upgraded SQL version 2008 to SQL 2012.

    4. At the time of importing organization from server to my machine, i am having the same problem. I repair data connector, restarted services/ computer, change Server account (Run as), nothing helps.

    Did your problem get resolved?

    -thanks

  • Verified answer
    WatashiFR Profile Picture
    250 on at

    I reinstalled the SRS data connector and my problems were solved.

  • Suggested answer
    Community Member Profile Picture
    on at

    Thanks, that resolved it. Also, I had SQL SERVER and Express on my machine, I only updated SQL SERVER before. Then I upgraded SQL express, and data connector.

    -Thanks

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans