CA SAM 12.7 install fails on database creation

Document ID : KB000048721
Last Modified Date : 14/02/2018
Show Technical Document Details

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'