DCS Manager upgrade to 6.10 fails with error "Failed to run SQL statement"

Products

• Data Center Security Server Advanced
• Data Center Security Server

Issue/Introduction

DCS Management Server upgrade from version 6.9.3 to 6.10 fails with "Failed to run SQL statement" error:

Error in MSI installation log located in user's profile Temp folder:

Failed SQL Statement:  

'

USE [master];

 

DECLARE @SQL varchar(500);

SET @SQL = 'sp_addsrvrolemember N''' + 'sa' + ''', processadmin';

EXEC (@SQL);

'

DB Installer failed!

Exception thrown:  java.lang.Exception: Failed to run SQL statement. 

 

.......

 

Caused by: java.sql.SQLException: Failed to run SQL statement. 

at com.symantec.dcs.server.install.sql.DbInstaller.executeSql(DbInstaller.java:1208)

at com.symantec.dcs.server.install.sql.DbInstaller.runSqlStatements(DbInstaller.java:1170)

... 8 more

Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Cannot use the special principal 'sa'.

at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:261)

at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1752)

 

Error with installation. Error code:  1

java.lang.Exception: Failed to run SQL statement. 

MSI (s) (34!80) [02:00:39:476]: Product: Symantec Data Center Security Management Server -- Error with installation. Error code:  1

java.lang.Exception: Failed to run SQL statement.

 

Environment

DCS Management Server 6.9.x being upgraded to version 6.10.

Cause

In this case, the ownership of SCSPDB database was changed from default 'scspdba' user to the sysadmin 'sa' user. That 'sa' user was later provided as SQL login during the upgrade process.

This resulted in failure of executing the SQL statement referenced above.

Resolution

Change the SCSPDB database owner back to 'scspdba' user and re-run the upgrade.