[dba-SQLServer] Can't find the principal

Well, after getting the error while trying to mount two databases on
Stonehenge from my laptop M90, I decided to go to Stonehenge directly and
both databases were actually mounted.  I then refreshed the database
collection on M90 and they were there.  So the issue is not as serious as I
thought, just a trivial error of some sort while doing the mount.


John W. Colby
Colby Consulting
www.ColbyConsulting.com 
-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Arthur
Fuller
Sent: Thursday, January 03, 2008 3:05 PM
To: dba-sqlserver at databaseadvisors.com
Subject: Re: [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?
>
_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com