During Service Catalog installation, the error "Configuring mdb failed." is received.

Products

• CA Service Catalog
• CA Service Management - Asset Portfolio Management
• CA Service Management - Service Desk Manager

Issue/Introduction

During the installation of Service Catalog, the procedure fails with error -3: “Configuring mdb failed.”

In the %temp%/casm/install.log file, the following errors are seen:

[CommonProcessUtilities] Deploy module 'mdb' failed with return code - -3
[CommonProcessUtilities] Command terminated with exit code: -3
[ConfigureSLCMMDB] SLCM MDB Configuration Exit Code: -3
[ConfigureSLCMMDB] Configuring mdb failed. Firing Task Error.
[ProgressPage] Task State Changed. TaskID: task.configuring_mdb,Configuración de CA Service Catalog: CA MDB, Old State: running, New State:failed
 

In the USM_HOME\logs\view.log file, the following error is visible:

ERROR [main] [ConfigureSQLServer] Could not connect to the database.
com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'sa'. ClientConnectionId:
ERROR [main] [ConfigureSQLServer] Unknown exception.
com.ca.catalog.deploy.exceptions.OperationFailedException
ERROR [main] [CmdDeploymentManager] Deployment of the module 'mdb' failed 

Environment

CA Service Catalog and CA Service Management
SQL Server – all supported versions

Resolution

The password of the ‘sa’ and/or 'mdbadmin' user for the Database server contains a special character.

It is strongly recommended to avoid special characters and other symbols that might interfere with script execution (i.e. ampersand, spaces, semicolons or single/double quotes).