Safe X3 Console configuration error - Error while creating user ERR_USER_CREATION

SOLVED

Sagex3 V12

SQL Server 2017

Windows Server 2016 Datacenter

Getting the error below when trying to configure the application for the first time after installation.

Installed Sage X3 V12

We have 2 servers a database server and app server

Configured Database server on console without issue

When we are now configuring the application server we are getting the error looks like not able to create SQL user.

Some of the lines on the trace are 

5/01/2020 9:03:57 PM : INFO - Database user X3 and roles are not available. (LibAdm.RunVerifSchemaBaseSqlServer)

5/01/2020 9:03:57 PM : INFO - Database schema check failed. (LibAdm.RunVerifSchemaBaseSqlServer)

5/01/2020 9:04:13 PM : INFO - Database user X3 and roles are not available. (LibAdm.RunVerifSchemaBaseSqlServer)

5/01/2020 9:04:13 PM : INFO - Database schema check failed. (LibAdm.RunVerifSchemaBaseSqlServer)

5/01/2020 9:04:13 PM : ERROR - Error while creating user. Please check file F:\Sage\X3DW\folders\X3\FILPLAT\x3ria_CrUsr.tra on server. (LibAdm.RunCreateUserSqlMainNT)

5/01/2020 9:04:13 PM : INFO - Application configuration failed : main runtime installation status will be reset To 'idle'. (LibAdm. RollbackMain)

5/01/2020 9:04:23 PM : FATAL - Configuration aborted
5/01/2020 9:04:23 PM : FATAL - ERR_USER_CREATION

Parents Reply Children