In a Disaster Recovery Solution, the same AEDB database is replicated from a first MSSQL Server to another one.
To start the Disaster Recovery test, the SQL Server replication is stopped between these both SQL Servers
The startup of the application server on the remote site fails with error message:
CAUAJM_E_18600 Database function call <SQLDriverConnect> failed in <connect SQLDriverConnect Failed>
By looking into the remote SQL Server, the "autosys" account and "ujoadmin" role were present
But the "autosys" account lost its user mapping on AEDB
Trying to re-established this user mapping fails with SQL Server error:
User, group, or role ‘autosys” already exists in the current database. (Microsoft SQL Server, Error: 15023)
Solution is to run this SQL command:
ALTER USER autosys WITH LOGIN = autosys
This command re-map the user's Security Identifier (SID) to match the sql server login's SID.