[dba-SQLServer] Can't find the principal

Supposedly you can just change owners, but I've never been able to make that
work correctly (could be my stupidity rather than an MS problem). But I've
gotten around this by creating a new database and then importing everything
from the other one. Then the ownership stuff on the new database is fine,
and then you can delete the old one.

A.

On 1/3/08, jwcolby <jwcolby at colbyconsulting.com> wrote:
>
> I have databases that I created on one machine.  When I move the database
> file to a different machine I get a "can't find the principal" error when
> trying to mount the database on the new machine.  The reason appears to be
> that the owner is the user under which the database was created on the old
> system.
>
> How do i get around this?
>