When installing CA Service Desk Manager (CA SDM), receive a 'Creation of CDB failed' error.
The INSTALL_MDB.LOG file has the following error:
select (mdbmajorversion * 100) + mdbminorversion + 2 from mdb_version
Invalid object name 'mdb_version'. select (mdbmajorversion * 100) + mdbminorversion from mdb
Invalid object name 'mdb'
One of the most common causes of the "Invalid object name 'mdb'" error is that a blank MDB is created prior to running the CA SDM installer.
As part of the CA SDM install process, it checks to see whether a MDB exists, and if it does, it queries some of the MDB tables before proceeding.
If those tables are not present, then the install will fail.
Delete any existing MDB databases that were manually created and allow the CA SDM installer to setup the MDB database.
During the CA SDM installation process, need to ensure that the installer is either pointed at a MDB instance that does not exist yet, and will be created by the installer, or at an existing MDB database (for migration/upgrade purposes).