Dynamics Ax AOS Server Installation Error

Finance and Operations/AX Developer Forum
1

Hi,

I am trying to install AOS Server locally with an existing SQL Server 2008 R2 . When i provide the database name and the next step is leading to following error

Property DbSqlServer set to: ‘(local)’
Connected to SQL Server: ‘(local)’
Exception: System.InvalidCastException

Message: Unable to cast object of type ‘System.DBNull’ to type ‘System.String’.

FullText: System.InvalidCastException: Unable to cast object of type ‘System.DBNull’ to type ‘System.String’.
at Microsoft.Dynamics.Setup.InstallSqlServer.GetDatabaseCollation(String databaseName)
at Microsoft.Dynamics.Setup.InstallSqlServer.ValidateDatabaseCollation(String databaseName)
at Microsoft.Dynamics.Setup.MainForm.s141_Next(Object sender, AxTabPageNextEventArgs e)
at Microsoft.Dynamics.Setup.AxTabPage.OkToContinue()
at Microsoft.Dynamics.Setup.MainForm.mainFormButtonNext_Click(Object sender, EventArgs e)
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

2

Hi Sreenivasulu,

This error is from database which you attaching to the Dynamics AX…for this error you have to add login user in USERLOG table in database…Do this first go to the db and find USERLOG table in it and delete all user…and find the db which u install in SQL Server and find the USERLOG table and see the user…and import that user to db(which u want to install with ax)…

with regards,

harivalla