Knowledge Base

KB #240110: Database owner SID differs from Master

Type:

Information

Summary:

When attempting to encrypt a column using Col-E Column Encryption Manager, or when trying to install Encryptionizer API’s you receive the following popup:“The database owner SID recorded in the master database differs from the database owner SID recorded in database ‘database’. You should correct the situation by resetting the owner of the database ‘database’ using the ALTER AUTHORIZATION statement.”

Additional Information:

This can occur when using CLR APIs and the database has been copied or restored from a different instance or machine. If you received this message while installing API’s using from the Main Menu, you can typically click Yes or Agree on the pop-up which will change the owner to match the current instance.

Or you can reset the owner of the database using one of the following commands:

• exec sp_changedbowner, or
• alter authorization

For example, to reset the owner of Northwind:use northwind;
declare @dbowner nvarchar(128);
set @dbowner = (select suser_sname(owner_sid) from sys.databases where name = db_name());
exec sp_changedbowner @dbowner;


To set the owner to SA:

use northwind
exec sp_changedbowner 'sa'


After resetting the owner you should be able to install the API’s or attempt to encrypt the column(s) again if you have the Column Encryption feature enabled.

Last modified: 6/5/2023