SAP Knowledge Base Article - Preview

2319654 - Database permission errors during PREP_INSTALL/SHDINST_DB_PREP

Symptom

When upgrading the SAP system with Software Update Manager (SUM), during the configuration step PREP_INSTALL/SHDINST_DB_PREP, you get the following errors:

Checks after phase PREP_INSTALL/SHDINST_DB_PREP were negative!
Last error code set: Process E:\usr\sap\ED8\SUM\abap\bin/SAPuptool exited with 20, see 'C:\usr\sap\<SID>\SUM\abap\log\SQLSTMTSTD.OUT' for details.

The results in the file SQLSTMTSTD.OUT shows:

FATAL ERROR: DBSL error 99 (db code 15151):
Cannot alter the role 'db_ddladmin', because it does not exist or you do not have permission.
SAPup> Process with PID 9652 terminated with status 20 at 20160511195920!

Or:

Cannot alter the role 'db_owner', because it does not exist or you do not have permission.

This may also fail with other commands like sp_grantdbaccess,  sp_addrolemember, etc.
 


Read more...

Environment

  • SAP Systems based on SAP NetWeaver;
  • Microsoft SQL Server 2005 and higher;

Product

SAP NetWeaver all versions

Keywords

upgradation, upgrade, upgrading, error, sum stop, sum stop after, during upgradation, during upgrade, while upgrading, can't alter role, ddl_admin, SHDINST_DB_PREP, shadow instance, shadow database, PREP_INSTALL, prep install, shdinst db prep, msql, mssql, ms_sql, microsoft sql server, sidadm, <sid>adm, <sapsid>adm, sapsid, shd_sid, shd_<sid>, shd_<sapsid>, sp_grantdbaccess,  sp_addrolemember, authorization, permission, roles, db_owner , KBA , BC-DB-MSS , SQL Server in SAP NetWeaver Products , BC-UPG-TLS-TLA , Upgrade tools for ABAP , BC-DB-MSS-UPG , SQL Server Upgrades in SAP NetWeaver Products , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.