Monday, 28 December 2009

AX2009SP1 - Analysis service install on SQL2008

You might receive this error message if you try to install analysis services component on a machine that has SQL2008.
"You must install SQL server 2005 Anaylsis Services Pack 2 before installing the Analysis extensions".

Find the script and run it manually in "SQL Server Management Studio".
\support\Analysis Services\Scripts\DynamicsAX.xmla

Make sure you change the connection string (ctrl+F for connection).

There is also a good blog
here. This blog suggests uninstalling SQL2005express and going through the install program again.

Good luck.

1 comment:

Blogger said...

BlueHost is definitely one of the best web-hosting company for any hosting plans you need.