SAP Knowledge Base Article - Preview

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


  • 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>.



  • Microsoft SQL Server
  • NetWeaver 


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


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.