I search the forum and connot find anything related to this issue.
I have Replication Exec 3.1 SP1 HotFix 7 on all the servers that does replication
The RSA on my RMS server failed to start since last week, it had work previously. The error I am getting is
In Application Log
Event: ID 1030
Source: Replication Exec RSA
Description: Replication Exec service initialization failed. : Initialization failed. : The database could not be initialized.
In System Log
Event ID 7024
Source: Service Control Manager
Description: The Replication Service Agent service terminated with service-specific error 8201 (0x2009).
RSA trace log:
Thu Dec 06 08:50:00 2007-0x00000fe8 [DBMS] RMSDB::RMSDB: Starting...
Thu Dec 06 08:50:00 2007-0x00000fe8 [DBMS] RMSDB::RMSDB: Allocated a valid ODBC environment, about to initialize ODBC/SQL states...
Thu Dec 06 08:50:00 2007-0x00000fe8 [DBMS] RMSDB::RMSDB: About to make the first connection (with retry logic)...
Thu Dec 06 08:50:00 2007-0x00000fe8 [DBMS] RMSDB::RMSDB: Made the the first connection, testing...
Thu Dec 06 08:50:00 2007-0x00000fe8 [DBMS] RMSDB::RMSDB: Failed to get a valid Connection object!
Thu Dec 06 08:50:00 2007-0x00000fe8 [DBMS] -103: 28000: [Sybase][ODBC Driver][Adaptive Server Anywhere]Invalid user authorization specification: Invalid user ID or password
Thu Dec 06 08:50:01 2007-0x00000fe8 [DBMS] RmsStoreInit: About to validate the RMSDB instance...
Thu Dec 06 08:50:01 2007-0x00000fe8 [DBMS] RmsStoreInit: Failed to get a valid RSA database instance! Wrong ODBC version?
Thu Dec 06 08:50:01 2007-0x00000fe8 [JCD] JcdDeinitialize
I have tried remove the rsa.db rsa.log and do a repair installation and also remove the ODBC connection for RSA and have the repair installation recreated. I tested the RSA connection in the DataSource and it tested succesfuly.
Has anyone encounter this issue before?
Your help is appreciated.