[Sage X3 Console] Configure Application: ERROR - Error while executing x3v12_CrUsr.bat : NOK. (LibAdm.RunCreateUserSQLMainNT)

SOLVED

Sage X3 Console.

Mistake on writing the Manual configuration of the SQL Server.

When Configure Application, I got this error.

```

10/31/2023 7:43:06 PM : WARN -
10/31/2023 7:43:06 PM : ERROR - Error while executing x3v12_CrUsr.bat : NOK. (LibAdm.RunCreateUserSQLMainNT)
[31;1mWrite-Error: [0mD:\Sage\X3V12\runtime\ebin\common_modules\application-mgr-sql.ps1:341[0m
[31;1m[0m[36;1mLine |[0m
[31;1m[0m[36;1m[36;1m 341 | [0m [36;1mAdd-To-Log -line $error_line -file $($env_params.log_name) -error[0m …[0m

[31;1m[0m[36;1m[36;1m[0m[36;1m[0m[36;1m | [31;1m ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~[0m
[31;1m[0m[36;1m[36;1m[0m[36;1m[0m[36;1m[31;1m[31;1m[36;1m | [31;1mA network-related or instance-specific error occurred while establishing a connection to SQL Server. The server[0m
[31;1m[0m[36;1m[36;1m[0m[36;1m[0m[36;1m[31;1m[31;1m[36;1m[31;1m[36;1m | [31;1mwas not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured[0m
[31;1m[0m[36;1m[36;1m[0m[36;1m[0m[36;1m[31;1m[31;1m[36;1m[31;1m[36;1m[31;1m[36;1m | [31;1mto allow remote connections. (provider: TCP Provider, error: 0 - No such host is known.)[0m
The process cannot access the file because it is being used by another process

```

Parents
  • +1
    verified answer

    Reading from `D:\Sage\X3V12\folders\X3\FILPLAT\x3v12_CrUsr.bat`.

    ```

    REM
    REM Usage : x3v12_CrUsr.bat [SQLAdmin password (sa)] [Db folder password]
    REM
    Call "D:\Sage\X3V12\runtime\bin\env.bat"
    Call "D:\Sage\X3V12\runtime\ebin\adcrapss7.bat" X3 x3v12 %ADXDIR%\tmp X3 sa "%1" "%2" NO 100 100 SQLSERVER NO
    Echo x3v12_CrUsr.bat > D:\Sage\X3V12\folders\X3\FILPLAT\x3v12_CrUsr.end

    ```

    Use Notepad++:

    At Application Server, path: `D:\Sage\X3V12\folders` for me, edit `solution.xml`.

    Update: `<component.database.servername>` xml tag content.

    At runtime server, path: `D:\Sage\X3V12\runtime\bin` for me, edit `env.bat`.

    Update: `SET CONNECTSTR` and `SET DB_NAM`

    At regedit path: Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Adonix\X3RUNTIME\X3V12

    Edit `CONNECTSTR` to corrected SQL Server connection path.

Reply
  • +1
    verified answer

    Reading from `D:\Sage\X3V12\folders\X3\FILPLAT\x3v12_CrUsr.bat`.

    ```

    REM
    REM Usage : x3v12_CrUsr.bat [SQLAdmin password (sa)] [Db folder password]
    REM
    Call "D:\Sage\X3V12\runtime\bin\env.bat"
    Call "D:\Sage\X3V12\runtime\ebin\adcrapss7.bat" X3 x3v12 %ADXDIR%\tmp X3 sa "%1" "%2" NO 100 100 SQLSERVER NO
    Echo x3v12_CrUsr.bat > D:\Sage\X3V12\folders\X3\FILPLAT\x3v12_CrUsr.end

    ```

    Use Notepad++:

    At Application Server, path: `D:\Sage\X3V12\folders` for me, edit `solution.xml`.

    Update: `<component.database.servername>` xml tag content.

    At runtime server, path: `D:\Sage\X3V12\runtime\bin` for me, edit `env.bat`.

    Update: `SET CONNECTSTR` and `SET DB_NAM`

    At regedit path: Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Adonix\X3RUNTIME\X3V12

    Edit `CONNECTSTR` to corrected SQL Server connection path.

Children