2319654 - Database permission errors during PREP_INSTALL/SHDINST_DB_PREP | SAP Knowledge Base Article

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 ONE Support launchpad (Login required).

Search for additional results

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