The login configurations of a combined CMS/CPA server must be kept in synchronization. That is, both must be configured for integrated login or neither must be so configured. This creates a problem with restoring old databases that are backup images taken before the server was reconfigured to use integrated login.
To restore a combined CMS/CPA server
-
Restore the CMS database from a pre-integrated login backup image. The CMS server does not start.
-
SetIntegratedLogin determines that the CMS and the CPA differ and returns an error.
Currently the only way to overcome this error is to restore both the CMS and CPA databases from the same backup image set. That is, both databases must be backed up at the same time, and the backup images should be kept and restored together as a set.
-
Restore the CMS and CPA databases from a pre integrated login backup image set.
-
Modify the ODBC DSN for the CMS and the CPA to use standard logins.
-
SetIntegratedLogin (step 2) succeeds and the CMS and the CPA services will now run in integrated login mode.
More Information
Database maintenance utilities
Issues with integrated logon and database backups