SBX - Search With Button

SBX - Forum Post Title

AX 2009 Report extension installation on SQL server 2008

Microsoft Dynamics AX Forum

Michel Auger asked a question on 29 Jan 2009 8:11 AM

Question Status

Suggested Answer

HI everyone,

I am trying to install this extension. When I run the Setup, I get the following message : "You must install SQL server 2005 Reporting Services Service Pack 2 before installing the report extensions".

According to the AX 2009 requirements, SQL server 2008 should be OK. I have installed the hotfix 957312 as recommended by Microsoft.

Has anyone experienced the same problem ?

 Thanks

 Michael 

 

Reply
Mohammed Rasheed responded on 29 Jan 2009 12:19 PM
My Badges

Hi Michael,

do you have AX 09 sp1 installed? also make sure you follow all the steps specified here:

https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?WTNTZSMNWUKNTMMYXUPYZQPOUXNXSPSYTVYVQTWQRWWVOSKSYVPMKKXSQOKOWTQM

regards,

Mohammed Rasheed

Reply
Michel Auger responded on 29 Jan 2009 1:09 PM

Thanks Mohammed,

I was not aware of this link. I downloaded the new hotfix, installed the dll files in both Components32 and Components64 directories as detailled in the article. But when I run the setup to try to install the Report extension, I still get the same error!!!

 

Michel

Reply
Michel Auger responded on 30 Jan 2009 10:50 AM

Hi Mohammed,

 

I have opened a case with MS and I got this answer :

The fix you mentioned (957312) does offer SQL 2008 compatibility for AX 2009 RTM. The key factor for installing reporting extensions is to copy the .dll supplied in the hoftix into a shared location containing the AX 2009 install media. Please ensure that this has been completed.

Even with the DLL in place we have seen this type of error on server that have previously had SQL 2005 installed, or a server that has any SQL 2005 components currently installed. It seems even if SQL 2005 has been uninstalled there are sometimes some remnants left behind that cause the installer to throw this error. Verify that there are no SQL 2005 components installed and especially watch for SQL express (as Visual Studio and some other apps may install this if a full install is done on the machine). Remove any such components and verify that there are no SQL 2005 pieces left behind, such as assemblies in the GAC (C:\Windows\Assembly)

My DBA has checked all this and he told me that Server 2005, SQL express and VS have never been installed on this server.

So we're still enable to deploy this report extension.

 Anything else that I could check ?

 

Thanks

Michel


Reply
Pornsak responded on 20 Mar 2009 1:20 AM

Installing AX 2009 Reporting Extensions in MSSQL 2008 & WIN 2008 When we try to install AX 2009 SP1 Reporting Services on a PC running SQL 2008, we get an error saying that MSSQL 2005 SP2 is required. Well there is a solution to this issue which is as follows:

1. Locate the AX Reporting services dll from the extracted AX 2009 SP1 folder [\\AX2009SP1\support\axsetupresources\microsoft.dynamics.setup.reportingservices.dll;File Version - 5.0.1000.52]

2. Extract the AX 2009 .iso to a shared folder

3. Copy the microsoft.dynamics.setup.reportingservices.dll into the folder: \\DynamicsAX\Msi\Components32\Program Files\Microsoft Dynamics AX\50\Setup \\DynamicsAX\Msi\Components64\Program Files\Microsoft Dynamics AX\50\Setup

4. It will ask to replace the existing dll having File Version - 5.0.593.0. Say Yes and replace.

5. Then Install AX Reporting Services extensions. It works fine and the Reporting Extensions are installed nice.

 

Pornsak

Reply
Gisli Petur Hinriksson responded on 19 May 2009 9:41 AM

 This works for some people but not for me. I've tried everything possible to make the, now most dreaded error of my existence, You must install SQL Server 2005 Reporting Services Service Pack 2 before installing the reporting extensions. Disappear! But no success!

I started out by installing a Microsoft Server 2008 x64 on a Vmware virtual machine

Updated the OS and installed Dynamics AX 2009 with a 2008 MSSQL SP1 x64 Server

Installed a EP & Role Center on Windows Sharepoint Server 2007 on the same machine as the DAX 2009

Got the dreaded "You must install SQL Server 2005 Reporting Services Service Pack 2 before installing the reporting extensions" I have installed the following on the DAX 2009 Vmware virtual machine

Microsoft SQL Server 2008 Reporting Services Add-in for Microsoft SharePoint Technologies

Microsoft SQL Server 2008 Analysis Services 10.0 OLE DB Provider

Microsoft Analysis Management Objects

Microsoft ADOMD.NET

KB959494

KB960158

KB957312

KB956568

Now I have tried pretty much everything know to man to make this work. Can anyone tell me if this is just wrong from the start or am I getting warm in configuring this thing? Is there something I am forgetting? Could there be something I haven't done on the SQL. Please help me?

 kind regards, gphinriks 

Reply
David Gachet responded on 2 Jul 2009 2:59 AM

Hello,

We 've got the same problem here:"You must install SQL Server 2005 Reporting Services Service Pack 2 before installing the reporting extensions"

We installed Dynamics AX 2009, then  we updated it to SP1.We installed the 957312 hotfix and patch the dll.

Yet, we still have the problem...

Is there something new about it ?

Thank you.

Regards,

David

 

Reply
Trisha responded on 8 Jul 2009 11:26 AM
My Badges

 Hi,

We have the same issue.  I have SQL Server 2005 Reporting Services installed and double check that Service Pack 2 was in fact installed also.  I tried the above solutions and still am getting the error message.

Any help is greatly appreciated!

Thanks,

Trisha
Reply
David Gachet responded on 9 Jul 2009 1:47 AM

We finally fix it.

We needed to get the kb959494 fix.

remark: The reporting extension need to be installed on the Database server (not on the AOS server).(We firstly try to install it on the Aos Server...),

Regards,

David

Reply
Trisha responded on 9 Jul 2009 7:22 AM
My Badges

Hi,

Thanks for the update.  Unfortunately this did not work for us since we were using SQL server 2005 instead of 2008.  However, after total frustration, I completely uninstalled SQL Server and reinstalled and the error is gone!

Thanks for all of the help!

Trisha

Reply
Sirichot Sirisawad responded on 17 Jul 2009 2:48 AM

TCB5

Hi,

Thanks for the update.  Unfortunately this did not work for us since we were using SQL server 2005 instead of 2008.  However, after total frustration, I completely uninstalled SQL Server and reinstalled and the error is gone!

Thanks for all of the help!

Trisha

I trying to install reporting extension on SQL server 2005
but it have an error when I Install prerequisites IIS Default Components

How shoud I do?

Reply
Max Hamilton responded on 15 Oct 2009 2:22 AM

The same problem with SQL Server 2005 SP3, this fix our problem:

Setup does not recognize that SQL Server 2005 Service Pack 2 is installed When installing the reporting extensions, you may receive an error message that states that you must install SQL Server 2005 Service Pack 2. If you have installed SQL Server 2005 Service Pack 2 and receive this error message, complete the following steps. 1. Open the registry and find the HKLM\SOFTWARE\Microsoft\Microsoft SQL Server key. 2. Right-click the HKLM\SOFTWARE\Microsoft\Microsoft SQL Server key and choose New > Key. 3. Name the key Reporting Services. 4. Right-click the Reporting Services key and choose New > String Value. 5. Name the string value Version. The Version string value will have a type of REG_SZ. 6. Double-click the Version string value and enter 9.00.3042.00 as the value data. Click OK.

Reply
lala zishan responded on 28 Oct 2009 7:15 AM

I am facing a lot of problems in installing SQL server 2005

i tried lot of things but could not do it 

 

flamingoforex

 

Reply
Asiq Ahamed responded on 7 Feb 2012 3:02 AM

1. Locate the AX Reporting services dll from the extracted AX 2009 SP1 folder [\AX2009SP1\support\axsetupresources\microsoft.dynamics.setup.reportingservices.dll;File Version - 5.0.1000.52]

2. Copy the microsoft.dynamics.setup.reportingservices.dll into the folder: \DynamicsAX\Msi\Components32\Program Files\Microsoft Dynamics AX\Setup [since my system is 32-bit so Components32]

3. It will ask to replace the existing dll having File Version – 5.0.593.0. Say Yes and replace. Now, carry on with the installation process.

Reply
AlexDAX responded on 17 Feb 2012 9:20 AM
My Badges

I'm having the same issue as above, and I've installed KB959494, which replaces the two DLLs and also replaces the AXSetup.exe in the support folder with no luck.  I've tried the registry change listed above, albeit I did not restart the machine.

Anybody have a resolution?

Reply
Amith Prasanna responded on 27 Aug 2012 1:52 AM
My Badges
Suggested Answer

I have Faced to Same Problem.there are 2 methods to ignore this massage & Setup it Successfully

First Method

1. Open the registry and find the HKLM\SOFTWARE\Microsoft\Microsoft SQL Server key.

2. Right-click the HKLM\SOFTWARE\Microsoft\Microsoft SQL Server key and choose New > Key.

3. Name the key Reporting Services.

4. Right-click the Reporting Services key and choose New > String Value.

5. Name the string value Version. The Version string value will have a type of REG_SZ. 6. Double-click the Version string value and enter 9.00.3042.00 as the value data. Click OK.

Second Method (For SQL Server 2008)

First Copy all the contents of AX2009 CD to a Shared Folder & then Get The AX2009 SP1 & Extract it  after Extracting go to Support >axsetupresources

and from it Copy microsoft.dynamics.setup.reportingservices.dll & Paste it to

Msi>Components32>Program Files>Microsoft Dynamics AX>50>Setup     &

Msi>Components64>Program Files>Microsoft Dynamics AX>50>Setup

then Start to Install.

Reply
Ravi Theja Madisetty responded on 15 Dec 2015 1:57 AM
My Badges
Suggested Answer

Your solution perfectly worked for me.

Thanks.,

Ravi Theja Madisetty

https://techguns.wordpress.com

Reply
Kangeyan Dhanapalan responded on 12 Aug 2016 10:33 PM
Suggested Answer

Worked for me ... Thanks a ton!!!

Reply

SBX - Two Col Forum

SBX - Migrated JS