CA SAM 12.7 install fails on database creation

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: