WINDOWS Live Search

To contact me for any clarifications regarding any posts / information, please mail me at arijit [dot] basu [at] gmail [dot] com


Saturday, December 27, 2008

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. 

3 comments:

Anonymous said...

Thanks! This worked.

Gísli Pétur said...

I moved the .dll to the referred folders and still get the same warning: "You must install the SQL 2005 Reporting Services Extensions..." So What the hell am I doing wrong? I have a Dynamics AX 2009 with SP1 on a 2008 x64 Server VMW machine. As for Sharepoint Server 2007 with the dynamics AX Enterprise Portal locked and loaded. I use a 2008 SQL another 64x server. I have installed the following

DynamicsAX2009-KB956568
wssv3sp1-kb936988 x64-fullfile-en-us

Everything installed and working except for the reporting and analysis services. So could by any chance help me?

Gísli Pétur said...

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