When copying the Autosys database from the old Event Server machine to the new one, could not connect to the Event Server from the GUI.

Products

• CA Workload Automation AE - Business Agents (AutoSys)
• CA Workload Automation AE - Scheduler (AutoSys)
• Workload Automation Agent

Issue/Introduction

Description

Event Server is on a different machine than the Event Processor. Needed to migrate; the Event Server to a more powerful machine. After installing and moving the database, cannot connect to the Event Server.
Database server is MS-SQL.

Solution

The 'anyone' userid was missing in the new database with its password.

Run the 'sp_changedbowner' and 'sp_change_users_login' stored procedures to give the necessary permissions to the 'AutoSys' and 'anyone' userids.

The syntax of these MS-SQL stored procedures are:

sp_changedbowner @loginame = 'AutoSys'
sp_change_users_login @UserNamePattern = 'anyone' , @Password = 'anything'

For more details, refer to the MS-SQL documentation.

Environment

Release: ATSY1C99000-4.5-AutoSys-Job Management-Class 1 Remote Agent
Component: