Knowledge Base

Search Knowledge Base

KB #240110: Col-E Error Message: Database owner SID differs from Master




When attempting to encrypt a column using Col-E Column Encryption Manager 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.This can be fixed by resetting 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 attempt to encrypt the column(s) again.

Last modified: 7/8/2016