SAP Knowledge Base Article - Preview

2972064 - Error in SQLSTMTSTD.OUT: Cannot alter the role 'db_owner', because it does not exist or you do not have permission. - NetWeaver

Symptom

  • System upgrade failed when create a shadow instance
  • Error in SQLSTMTSTD.OUT: Cannot alter the role 'db_owner', because it does not exist or you do not have permission.
  • Error message in MSSDROPSHD.SQL:

========
ERROR:expected dbuser(<sid>) is not the same as the actual dbuser (dbo).
ERROR: schema user <sid> has administrator fixed server role (user_name() is 'dbo').
       This is not allowed.  Please check the Server Roles of user <sid>.
========


Read more...

Environment

  • Microsoft SQL Server
  • NetWeaver 

Product

SAP Supplier Relationship Management 7.0 on SAP enhancement package 1 for SAP NetWeaver 7.0

Keywords

administrator fixed server role, sysadmin role, Cannot alter the role 'db_owner' , KBA , BC-DB-MSS , SQL Server 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.