ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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.

book

Article ID: 53728

calendar_today

Updated On:

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: