SQL Error – The database owner SID recorded in the master database differs from...
source link: https://sqlwithmanoj.com/2016/01/09/sql-error-the-database-owner-sid-recorded-in-the-master-database-differs-from-the-database-owner-sid/
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
SQL Error – The database owner SID recorded in the master database differs from the database owner SID
Today we got an email from our support team that they are not able to execute Stored Procedures on a particular Database and getting following error:
The server principal “domain\user” is not able to access the database “dbXYZ” under the current security context.
The database owner SID recorded in the master database differs from the database owner SID recorded in database ‘dbXYZ’. You should correct this situation by resetting the owner of database ‘dbXYZ’ using the ALTER AUTHORIZATION statement.
The Database was restored by a backup from Production box to a separate Dev box. I checked the Properties of the Database and the Owner property shows the Prod service account, which cannot be created on Dev machine.
So, we just need to change the Owner Name of the database by using “ALTER AUTHORIZATION” statement of sp_changedbowner system SP, as shown below:
USE [DatabaseName]GO-- Option #1EXEC sp_changedbowner 'sa'GO-- OR---- Option #2ALTER AUTHORIZATION ON DATABASE::[DatabaseName] TO [sa]GOAnd the issue got resolved !!!
Related
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK