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.”
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:
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:
exec sp_changedbowner 'sa'
After resetting the owner you should attempt to encrypt the column(s) again.
Last modified: 7/8/2016