During a disaster recovery test, "autosys" user mapping on AEDB is lost.

Document created by JeanPaulLucas Employee on Apr 29, 2016
Version 1Show Document
  • View in full screen mode

 

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.

 

 

 

 

 

Attachments

    Outcomes