SAP Knowledge Base Article - Preview

2972064 - Schema user <sid> has administrator fixed server role (user_name() is 'dbo').This is not allowed.. - NetWeaver

Symptom

  • 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 for Me (Login required).

Search for additional results

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