Hi guys!
Im installing a new environment with CAEEM and CA SDM pointing to a remote SQL Server, but for some reason the installation stop after "Installing CA Service Desk Manager Database Schema remotely" step.
I ran the installation of mdb (CASM install media \ products \ sdm \ setup.exe) on the DB server before running the Service Management installer on the application server and I'm using the SQL Server ServiceDesk user, which has sysadmin privilegies.
I'm using a named instance and I see no connection problems with the database server through port 56625.
The install file at C:\Users\albinosv\AppData\Local\Temp\casm show this error messages:
2017/09/26 13.53.14.840 ERROR [DeployThread: Installing CA Service Desk Manager Database Schema remotely] [DatabasePersister] SQLException: Invalid object name 'al_cdb_componentinstallstate'.
2017/09/26 13.53.15.949 ERROR [DeployThread: Installing CA Service Desk Manager Database Schema remotely] [SetupMDB] Setup MDB returns code 801
2017/09/26 13.53.15.968 ERROR [DeployThread: Installing CA Service Desk Manager Database Schema remotely] [SetupMDB] MDB RC : 801
2017/09/26 13.53.15.968 ERROR [DeployThread: Installing CA Service Desk Manager Database Schema remotely] [SetupMDB] MDB Error: Unexpected error. Check logs at D:\CA\SDM\temp\mdb_sql.
2017/09/26 13.53.15.968 ERROR [DeployThread: Installing CA Service Desk Manager Database Schema remotely] [SetupMDB] Check mdb logs at D:\CA\SDM\temp\mdb_sql.
2017/09/26 13.53.15.968 ERROR [DeployThread: Installing CA Service Desk Manager Database Schema remotely] [InstallSDMRemoteMDB] SetupMDB returns code 801
2017/09/26 14.03.57.942 ERROR [DeployThread: Configuring CA Service Desk Manager] [ConfigureSDM] SDM configuration failed with message : 09/26 13:54:39.829 WARN ConfigThread.java 582 Configuration task (Configure MS SQL Server) is failed in step : 11
The install_mdb_msg file D:\CA\SDM\temp\mdb_sql shows only this:
09-26,13:54:39 Unable to determine the Common Component Directory for the MDB.
Can anyone help?