Dynamics AX 2009 Enterprise Portal requires Analysis Management Objects (AMO) for SQL Server

I was recently installing a new Dynamics AX 2009 environment where I was having Enterprise Portal installed on a separate machine.

When running the Dynamics AX Setup for the Enterprise Portal and Role Center role the installation completed with warnings.

The DynamicsSetup.txt contained the following error messages:

Entering function CurrentUserAlias 
    Leaving function CurrentUserAlias 
    Creating new Enterprise Portal Site with following the parameters:\n URL: http://server/sites/DynamicsAx\n Title: EP Site\n LCID: 1033\n OwnerLogin: domain\administrator 
    Administration Web Service URL: http://server:1234/_layouts/ep/WSSAdmin.asmx 
    Information: Debugging mode is off. 

    An error occured while Setup was creating a new site. 
    The underlying connection was closed: An unexpected error occurred on a receive. 
    ... 
    Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host.

At the same time there was the following error message showing up in the Application event log:

Event Source: .NET Runtime 2.0 Error Reporting
Event Category: None
Event ID: 1000
Description:
Faulting application w3wp.exe, version 7.0.6001.18000, time stamp 0x47919ed8, faulting module kernel32.dll, version 6.0.6001.18000, time stamp 0x4791ada5, exception code 0xe053534f, fault offset 0x000000000002649d, process id 0x%9, application start time 0x%10.

The root cause of this issue was that the Analysis Management Objects (AMO) for SQL Server had not been installed on the Enterprise Portal server.

By downloading and installing the Microsoft SQL Server 2005 Management Objects Collection (Microsoft SQL Server 2005) or Microsoft Analysis Management Objects (Microsoft SQL Server 2008) the Enterprise Portal site could be successfully created.

More information:

The AX 2009 installation guide has been updated with this requirement.

Install SQL AMO version based on which version your Analysis Server is running (SQL 2005 or 2008) and install the correct processor type based on what Operating System type your EP server is running (x86 or x64)

Side-by-side install of SQL 2005 and 2008 AMO objects is not supported and will cause other issues.

You can download the SQL AMO objects from SQL Server Feature Packs:
- SQL Server 2008: Feature Pack, April 2009
- SQL Server 2005 Feature Pack, December 2008

–author:	Alexander Lachner
–editor:	Alexander Lachner
–date:	28/04/2009

Tags