Answered by:
Upgrade CRM 4.0 to CRM 2011 Error when Importing Organization Regarding the Reporting Extensions which I Installed

Question
-
Hi,
I am testing CRM 2011. My current CRM 4.0 environment has CRM on a Windows 2003 32Bit OS and the SQL Database is on SQL 2005.
I created a new CRM 2011 Server on Windows 2008 R2 Enterprise. I also have a SQL 2008 R2 database server for the database.
I am in the process of trying to import the CRM 4.0 organization into my new environment. I get to the part right after the user mapping section where it performs some system checks before the import is finalized. I keep getting the error "Microsoft Dynamics CRM Reporting Extensions must be installed on SQL Server Reporting Services for reports to work"
I have installed the Report Authoring Extension Tool on SQL 2008 R2 Server. File name = CRM2011-Bids-ENU-i386.exe
I rebooted the SQL Sever and my new CRM Server and it keeps giving me that error. Am I missing a step what can I look at next?
Please look below for screenshots
Shows the import organization error http://paulslager.com/wp-content/uploads/2011/04/CRm2011-1.jpg
Details of the Import Organization error http://paulslager.com/wp-content/uploads/2011/04/CRm2011-2.jpg
Shows that I have installed the Report Authoring Extension on the SQL Server http://paulslager.com/wp-content/uploads/2011/04/CRm2011-3.jpg
Says Reporting is not enabled in the CRM Deployment Manager http://paulslager.com/wp-content/uploads/2011/04/CRm2011-5.jpg
Tuesday, April 26, 2011 6:43 PM
Answers
-
"Report authoring extensions" is different than "reporting extensions".
"Report Authoring Extensions" is installed on whatever machine you use BIDS on to develop custom FETCHXML based reports.
"Reporting Extensions" (WHAT YOU WANT) is installed on the SQL Reporting Server box and cannot be downloaded from Microsoft. You can find it in your installation media. It should be here:
In the {uncompressedinstallmediamainfolder}/SrsDataConnector/ folder, double-click SetupSrsDataConnector.exe.
Jamie Miley
http://mileyja.blogspot.com
Linked-In Profile
Follow Me on Twitter!- Proposed as answer by Jamie MileyModerator Tuesday, April 26, 2011 7:56 PM
- Marked as answer by pslager Tuesday, April 26, 2011 8:46 PM
Tuesday, April 26, 2011 7:56 PMModerator -
Hey
You need to install Reporting Extension instead of Report Authoring Extension.
This link explains all :
Hope it helps!!!
Tuesday, April 26, 2011 8:02 PM
All replies
-
Hi
Where is your Reporting services installed?
Is it on same machine as of SQL Server?
Tuesday, April 26, 2011 7:08 PM -
Yes Reporting Services is installed on the SQL 2008 R2 Server.Tuesday, April 26, 2011 7:13 PM
-
"Report authoring extensions" is different than "reporting extensions".
"Report Authoring Extensions" is installed on whatever machine you use BIDS on to develop custom FETCHXML based reports.
"Reporting Extensions" (WHAT YOU WANT) is installed on the SQL Reporting Server box and cannot be downloaded from Microsoft. You can find it in your installation media. It should be here:
In the {uncompressedinstallmediamainfolder}/SrsDataConnector/ folder, double-click SetupSrsDataConnector.exe.
Jamie Miley
http://mileyja.blogspot.com
Linked-In Profile
Follow Me on Twitter!- Proposed as answer by Jamie MileyModerator Tuesday, April 26, 2011 7:56 PM
- Marked as answer by pslager Tuesday, April 26, 2011 8:46 PM
Tuesday, April 26, 2011 7:56 PMModerator -
Ah well that would explain it. I was just a bone head let me give that a try now.Tuesday, April 26, 2011 8:00 PM
-
Hey
You need to install Reporting Extension instead of Report Authoring Extension.
This link explains all :
Hope it helps!!!
Tuesday, April 26, 2011 8:02 PM -
CRMDevlpr, Isn't that the same answer I just proposed?
Jamie Miley
http://mileyja.blogspot.com
Linked-In Profile
Follow Me on Twitter!
Tuesday, April 26, 2011 8:40 PMModerator -
The import is running now, thanks for your help JamieTuesday, April 26, 2011 8:47 PM
-
Agreed Jamie
My sole purpose to mark mine as answer was that someone in future might look at it and use the link for information.
I am not sure if a post can have multiple replies marked as answer.
Tuesday, April 26, 2011 8:49 PM -
Yes they can. I don't usually see people post the same answer in succession. It just didn't make sense to me :)
Jamie Miley
http://mileyja.blogspot.com
Linked-In Profile
Follow Me on Twitter!Tuesday, April 26, 2011 9:10 PMModerator -
To be honest, I really din see your reply .. I had typed the content but was searching for the link .
By the time I found and copied one, you had already been the first one to reply :)
Tuesday, April 26, 2011 9:23 PM