AOS installation error in Dynamics AX

0
votes

i am trying to install tha Dynamics AX in windows server 2012. i have created the databases using Database installation in AX Dynamics setup in SQL Server. Now i am trying to install the AOS feature but i am getting the like thisAOS installation

connected to database

error details the error is "Setup cannot use the database MicrosoftDynamicsAx in server VENKAT because its Collation is incorrect". please help me with this error.

2
axaptadynamics-ax-2012
Please check the following link sinedax.blogspot.com.by/2012/11/… - Aliaksandr Maksimau
What is the collation of the AX databases? - FH-Inway
He answered the question about the current collation in a thread about the same question in Dynamics Community. - Martin Dráb
this is not a programming question - AnthonyBlake
this is not a programming question @AnthonyBlake but the problem is related to Dynamics AX only. - venkat pasumarti

2 Answers

3
votes

the collation error is rectified I have changed the collation to SQL_Latin1_General_CP1_CI_AI to SQL_Latin1_General_CP1_CI_AS in the database. the query is ALTER DATABASE MicrosoftDynamicsAX1 COLLATE SQL_Latin1_General_CP1_CI_AS;

1
votes

You have to execute the follow queries:

ALTER DATABASE MicrosoftDynamicsAX COLLATE SQL_Latin1_General_CP1_CI_AI;

GO

ALTER DATABASE MicrosoftDynamicsAX COLLATE SQL_Latin1_General_CP1_CI_AS;