Error while configuring console in Sage X3 installation

By | November 29, 2019

In Sage X3 two tier installation for a client, we came across an error of user creation in database. While configuring the application server in console, we got an ERROR – Error while creating user. Please check file E:\Sage\X3V12\folders\X3\FILPLAT\x3v12_CrUsr.tra on server.(LibAdm.RunCreateUserSqlMainNT).

Also, Refer the below screen shot for the same error.

Console Error Trace
Console Error Trace

                                                                                  

We investigated the error in back end files and got to know that this error occurs because of missing the Microsoft ODBC drivers. After installation of the same ODBC driver in a SQL and Application server, this error got resolved.