Workload Automation

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.

 

 

 

 

 

Statistics
0 Favorited
2 Views
0 Files
0 Shares
0 Downloads

Related Entries and Links

No Related Resource entered.