The database owner SID recorded in the master database

[bdill]

Error when adding a database.

X Installing Test Framework

[Brian Donahue]

Thanks for your post. You are having a problem with your SQL Server because you have restored a master database from another server and the Security IDs are not going to match up, so you will have to reassociate them. You can check the ALTER AUTHORIZATION command in your SQL Server documentation or have a look at this blog post: http://blog.strictly-software.com/2009/09/database-owner-sid-recorded-in-master.html

(please note we do not take any responsibility for incorrect information in either source)
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521

[bradwist]

it strikes me that this is an odd test to run before installing this.

I can (and do) have databases on my system that have different owners, and the owners are not the owners of the master database.

The only reason that I can think of to force the SID to be the same for the Master Database and the User database is because of the CLR usage, which can sometimes run into problems if the SIDs are mismatched.

Is that the reason for this check? i'm curious.

[Brian Donahue]

This is a question about databases originating from a different server so the point is, all of the database security IDs will be different as they are generated by another server. Again, if you have SQL Server questions, I'd recommend asking the SQL Server community, for instance www.sqlservercentral.com.

Thanks!
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521