We help IT Professionals succeed at work.
Get Started

Dynamics 2011 SSRS Data Connector

Matthew Ayers
on
264 Views
Last Modified: 2015-09-19
I am trying to install an op-premise installation of Ms Dynamics 2011 for our development team. I have two boxes, one running SQL Server 2008R2, the other with the Dynamics 2011 Server (Updated to rollup 6).

We have an existing organisation (hence the old version of dynamics) which I am trying to import. The import wizard tells me that the CRM reporting extensions are not installed on the SSRS server. So I'm trying to install the CRM reporting extensions.

On the SQL server everything goes fine until the system checks when it tells me that (under the environment checks) that there is no such object on the server and the log file shows:

11:42:03|   Info| Group Microsoft SQL Serverâ„¢
11:42:03|   Info| SQL Server Version: 10.50.6220.0
11:42:03|   Info| SQL Server Edition: 2
11:42:03|   Info| Check SqlServerValidator: Success
11:42:03|   Info| Check SqlInstanceNameValidator: Success
11:42:03|   Info| Check ConfigDatabaseExistsValidator: Success
11:42:03|Verbose| Retrieving config database version Provider=SQLOLEDB;Data Source=DEVDB;Initial Catalog=MSCRM_CONFIG;Connection Timeout=60;Integrated Security=SSPI ...
11:42:03|   Info| Config database version: 5.0.9690.4150.
11:42:03|   Info| Check ConfigurationDatabaseVersionValidator: Success
11:42:03|Verbose| Retrieving information from database Provider=SQLOLEDB;Data Source=DEVDB;Initial Catalog=MSCRM_CONFIG;Connection Timeout=60;Integrated Security=SSPI ...
11:42:03|   Info| PrivilegeUserGroup: CN=PrivUserGroup {ef03eab6-2f7a-43d5-8cb3-0765c1dcc7d5},<Domain path>
11:42:03|   Info| SqlAccessGroup: CN=SQLAccessGroup {ef03eab6-2f7a-43d5-8cb3-0765c1dcc7d5},<Domain path>
11:42:03|   Info| ReportingGroup: CN=ReportingGroup {ef03eab6-2f7a-43d5-8cb3-0765c1dcc7d5},<Domain path>
11:42:03|   Info| PrivReportingGroup: CN=PrivReportingGroup {ef03eab6-2f7a-43d5-8cb3-0765c1dcc7d5},<Domain path>
11:42:03|   Info| Check PrivReportingGroupActiveDirectoryRightsValidator: Success
11:42:03|   Info| Check CrmSqlDomainValidator: Success
11:42:03|   Info| Check ReportServerInstanceValidator: Success
11:42:03|   Info| Check CanPublishReportsValidator: Success
11:42:03|   Info| Group Environment Checks
11:42:03|   Info| Check ReportServerValidator: Success
11:42:03|   Info| Check ReportingAccountValidator: Success
11:42:03|Verbose| Retrieving information from database Provider=SQLOLEDB;Data Source=DEVDB;Initial Catalog=MSCRM_CONFIG;Connection Timeout=60;Integrated Security=SSPI ...
11:42:03|  Error| Check ReportingAccountMemberOfSecurityGroupValidator : Failure: There is no such object on the server.

Looking through google I can see other ReportingAccountMemberOfSecurityGroupValidator errors but not this specific one. I have tried the various solutions that have been presented for the other errors including adjusting permissions and editing the registry, but I'm still lost.

Some of the links I've looked at to help:
https://technet.microsoft.com/en-us/library/hh699807(v=crm.5).aspx
https://support.microsoft.com/en-us/kb/974584
http://error287.rssing.com/chan-5688711/all_p1.html


Can anyone point me in the right direction please? Any help gratefully received.

Thanks

Matt
Comment
Watch Question
Principal Consultant
CERTIFIED EXPERT
Commented:
This problem has been solved!
Unlock 1 Answer and 2 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE