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.

Resolution:

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).