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