The database owner SID recorded in the master database differs from the database owner SID
This problem can arise when a database restored from a backup and the SID of the database owner does not match the owners SID listed in the master database. Here is a solution that uses the “ALTER AUTHORIZATION” statement recommended in the error message: DECLARE @Command VARCHAR(MAX) = ‘ALTER AUTHORIZATION ON DATABASE::[<<DatabaseName>>] TO [<<LoginName>>]’ SELECT … Read more