The db owner SID recorded in the master db differs from the db owner SID recorded in db ‘SID’

We are getting below error message while performing the SAP upgrade on Microsoft SQL Server,

Error message: DBSL error 99 (db code 33009):  
The database owner SID recorded in the master database differs from the database owner SID recorded in database 'SID'. 
You should correct this situation by resetting the owner of database 'SID' using the ALTER AUTHORIZATION statement. 

Solution

You can perform the following changes by referring to Option 1 or Option 2. No restart is required.

Option 1

Execute below command.

USE [SID]
GO
EXEC sp_changedbowner 'SAP_OWNER'
GO

Option 2

Right click on the database SID, go to Files. Under Owner, change it to sa (or SAP owner).

Reference

2334183 – The db owner SID in master db differs from the SID within the db

You May Also Like

Leave a Reply?