We came across an issue where by after installing the Dynamics AX 2009 Analysis Extensions sucessfully, no database is created! Even if you manually try to create the Dynamics AX Analysis database from the analysis script file DynamicsAX.xmla (found under the installation media in "\support\Analysis Services\Scripts\" folder), you get the following error message:
We got this issue on a SQL Server Analysis Server (SSAS) 2008 where the default collation was set to Turkish_CI_AS. The same will apply if you were running SQL Server 2005 and also with Turkish_CS_AS collation. This is by design as the Analysis extensions (OLAP framework tools and Default Cubes) have been tested only in the following AX language/collation combinations:
Language SSAS CollationEnglish US Latin1_General_CI_AS Danish Danish default collation German German default collation Chinese Chinese default collation Arabic Arabic default collation
You maybe able to workaround the issue as follows:
- In SQL Server Management Studio, connnect to SSAS and right click on the server name to change the properties of collation . - Set your collation to Latin1_General for instance and restart SSAS - Run the AX setup to add the "Analysis extensions". - When the DynamicsAX database and its cubes have been created, you could either change back SSAS collation to Turkish_Cx_Ax, or first backup the database, then change SSAS collation to Turkish_Cx_Ax and restore the backup.