Datamart installation failed to create the database

book

Article ID: 127237

calendar_today

Updated On:

Products

SUPPORT AUTOMATION- SERVER CA Service Desk Manager - Unified Self Service KNOWLEDGE TOOLS CA Service Management - Asset Portfolio Management CA Service Management - Service Desk Manager

Issue/Introduction

Messages from the install_casm_dm.log:

02-16,17:28:45
02-16,17:28:45 Creating casm_dm...
02-16,17:28:46
02-16,17:28:46 sqlcmd -S "MSSQL-PROD-CA\PRODCA,54397" -d master -U sdm -P *** -e -b [create_sql_casm_dm.sql]
create database [casm_dm]
COLLATE Latin1_General_CI_AS

02-16,17:28:53 Failed to create the database (errorlevel=1)
02-16,17:28:53 Setupmdb_pre exit /B return code=400
02-16,17:28:53 Pre-process failed (errorlevel=400)
02-16,17:28:53 Setupmdb exit /B return code=110

Cause

Microsoft SQL Server database does not have permissions to execute the sqlcmd command.

Environment

CA Service Management 17.1

Resolution

Make sure Microsoft SQL Server database has enough permission to execute sqlcmd and  prompt commands.

Additional Information

sqlcmd Utility