Disabling Maintenance User Password Protection

Disable maintenance user password protection for the connection to a replicate Adaptive Server database.

1. At the Replication Server, set hide_maintuser_pwd off for the connection to the replicate Adaptive Server database:

   alter connection to data_server.database 
   set hide_maintuser_pwd to ‘off’
   go

2. Log in with the sso_role privilege to isql at the Adaptive Server replicate database and disable replication:

   set replication off
   go

3. At the Adaptive Server replicate database change the maintenance user password to one that is known to the administrator:

   alter login maintenance user ID
   modify password new_maintenance_user_password
   go

4. Log in to Replication Server and change the password for all connections affected by the change to the maintenance user password to be the same as the password at the database:

   alter connection to data_server.database
   set password [to] new_maintenance_user_password

5. Enable replication. At the replicate Adaptive Server database, enter:

   set replication on
   go