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.

Document ID : KB000053728
Last Modified Date : 14/02/2018
Show Technical Document Details

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.