?
Solved

CRM 2011 Reporting Extensions install Error: Reports will not be published for some organizations...

Posted on 2011-04-27
10
Medium Priority
?
6,222 Views
Last Modified: 2013-11-24
Trying to install Reporting Extensions with CRM 2011 Server using SQL Server 2008r2 with Windows Server 2008 R2.
 
Receive this error: "Warning: Reports will not be published for some organizations because the Report Server instances used by these organizations differ from the instance selected during Microsoft Dynamics CRM Reporting Extensions Setup."  Upon entering Deployment Manager it reports Reporting is not enabled and One or more server roles are missing from this deployment.  The proper URL for reporting services shows under properties for the organizaton.
 
A review of the SRSDCsetup log shows:
 
08:38:59|   Info| CrmAction execution time; CollectAction; 00:00:00.0156000
 08:38:59|   Info| CrmAction execution time; CollectAction; 00:00:00.0156001
 08:39:00|Verbose| Retrieving Base Language Id Provider=SQLOLEDB;Data Source=servername;Initial Catalog=CQcrm_MSCRM;Connection Timeout=60;Integrated Security=SSPI ...
 08:39:00|   Info| Base Language Id of CQcrm_MSCRM: 1033.
 08:39:00|Warning| Instance Name needs to be escaped. Management Exception: Invalid namespace
 08:39:00|   Info| Escaped Instance Name is RS_MSSQLSERVER
 08:39:00|Warning| Could not find a local RS instance corresponding to the reporting url https://servername.domain.local/reportserver for organization CapitalQcrm
 08:39:00|   Info| CrmAction execution time; CollectAction; 00:00:01.2012021
 08:39:00|Warning| Instance Name needs to be escaped. Management Exception: Invalid namespace
 08:39:00|   Info| Escaped Instance Name is RS_MSSQLSERVER
 08:39:00|   Info| CrmAction execution time; CollectAction; 00:00:00.1404002
 08:39:00|   Info| CrmAction execution time; ValidateAction; 00:00:00.0156000
 08:39:00|Verbose| Method entry: Microsoft.Crm.Setup.SrsDataConnector.SrsDataConnectorSetup.RunInternal
 08:39:01|   Info| Setup thread-routine provided to progress wizard
 08:39:01|   Info| ActivatePage(SqlServerPage)
 08:39:01|   Info| Window Left: 548
 08:39:01|   Info| Window Top: 308
 08:39:13|Verbose| Retrieving Base Language Id Provider=SQLOLEDB;Data Source=servername;Initial Catalog=CQcrm_MSCRM;Connection Timeout=60;Integrated Security=SSPI ...
 08:39:13|   Info| Base Language Id of CQcrm_MSCRM: 1033.
 08:39:13|Warning| Instance Name needs to be escaped. Management Exception: Invalid namespace
 08:39:13|   Info| Escaped Instance Name is RS_MSSQLSERVER
 08:39:13|Warning| Could not find a local RS instance corresponding to the reporting url https://servername.domain.local/reportserver for organization CapitalQcrm
 08:39:13|   Info| ActivatePage(SsrsInstancePage)
 08:39:19|Warning| Instance Name needs to be escaped. Management Exception: Invalid namespace
 08:39:19|   Info| Escaped Instance Name is RS_MSSQLSERVER
 
There is no option to name the Reporting Server instance.  We have a default install and in the Set up wizard are choosing the server hosting CRM/SQL. Everything is on same box.  SQL Reporting Service account  is member of PrivReporting and PrivUsers.
 
 
 
Tried config file:
 

<?xml version="1.0"?>
 -<crmsetup> -<srsdataconnector> <configdbserver/> <autogroupmanagementoff>false</autogroupmanagementoff> </srsdataconnector> </crmsetup>
 
with autogroup management on and off.  I have seperate service accounts for all functions in CRM and SQL.  CRM website is working and am able to import organization into it.  Just no reports.
 
Where do I go from here??
0
Comment
Question by:erm4
  • 6
  • 3
10 Comments
 
LVL 30

Expert Comment

by:Feridun Kadir
ID: 35477149
Is Reporting Services installed in the default instance of the SQL Server? Or are you using a named instance?
The error messages seem to be complaining about the reporting services server name which might be to do with the server name, instance name or the url.

I would uninstall Reporting Extensions, verify that reporting services is working (browse to the report server in IE), verify all names are ok and then install Reporting Extensions.
0
 

Author Comment

by:erm4
ID: 35477177
Reporting services is installed as the default.  I can browse to ReportServer and see the CRM organization folder.
0
 
LVL 30

Expert Comment

by:Feridun Kadir
ID: 35477190
What about the names used for the computer and the URL?
0
Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

 

Author Comment

by:erm4
ID: 35477257
I can navigate to the URL as shown in the Deployment Configuration for the Organization.  Works with no issues.
0
 
LVL 27

Expert Comment

by:Chinmay Patel
ID: 35477703
Hi erm4,

Have you checked this KB?

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

Regards,
Chinmay.
0
 

Author Comment

by:erm4
ID: 35477712
Yes to no avail.
0
 
LVL 30

Expert Comment

by:Feridun Kadir
ID: 35478358
Do you have other reporting services instances on your server that are not fully configured? If so, then this post may be of relevance.
0
 

Author Comment

by:erm4
ID: 35478511
There is only one instance of Reporting Server running.
0
 

Accepted Solution

by:
erm4 earned 0 total points
ID: 35479685
Uninstalled an reinstalled using Network Service for all except Sandbox.  Applied roll up 1 and imported org.  reports present.
0
 

Author Closing Comment

by:erm4
ID: 35503416
self source solution
0

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Automatically creating a Trello card using data from a Microsoft Dynamics CRM record turned out to be an easy project that yielded great results.  Here's how I did this for an internal team at General Code.
"Disruption" is the most feared word for C-level executives these days. They agonize over their industry being disturbed by another player - most likely by startups.
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…
Suggested Courses

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question