CA SAM 12.7 install fails on database creation

book

Article ID: 48721

calendar_today

Updated On:

Products

CA Automation Suite for Data Centers - Configuration Automation CA Client Automation - Asset Management CA Client Automation - IT Client Manager CA Client Automation CA Client Automation - Remote Control CA Client Automation - Asset Intelligence CA Client Automation - Desktop Migration Manager CA Client Automation - Patch Manager CA IT Asset Manager CA Software Asset Manager (CA SAM) ASSET PORTFOLIO MGMT- SERVER CA Service Management - Asset Portfolio Management CA Service Management - Service Desk Manager

Issue/Introduction

Description:

The database fails to be created with the following message when installing CA SAM 12.7


Setup database
Status: failed

asp_db->x_query():failed. error: query error:     
code: 1, message:array (0=> array (0 => '42000', SQLSTATE' =>'4200', 1=>262, 'code'=>262, 
[Microsoft][SQL Server Native Client 11.0][SQL Server] CREATE 'message'=>'Microsoft][SQL Server Native Client 11.0][SQL Server

\'sam_prod\'.',0,0 Layer message is Invalid SQL; 
CREATE FUNCTION utf8_bytelength (@nstring nvarchar(4000))
RETURNS int
AS
BEGIN

Solution:

The user who has created the CA SAM database must have 'sysadmin' privileges.

The DBuser created for the CA SAM database must be db_owner and have the default schema of 'dbo'

Environment

Release: UAPMAC990JPP-12.6-Asset Portfolio Management-Asset Configuration
Component: