Workload Automation

 View Only

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

Apr 29, 2016 09:40 AM


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.






0 Favorited
0 Files

Tags and Keywords

Related Entries and Links

No Related Resource entered.