SQL2008 R2 Copy Database error "Cannot find the principal SQL2000\Administrator"
Posted on 2011-10-09
I'm trying to copy a database from a SQL 2000 box to a SQL 2008 R2 server using SA on both servers. I am not trying to copy the logons as it's easy enough to recreate them in this case.
The copy is throwing an error:
Executing the query "EXEC dbo.sp_changedbowner @loginame = N'SQL2000\Ad..." failed with the following error: "Cannot find the principal 'SQL2000\Administrator', because it does not exist or you do not have permission."
I am not sure how that login is getting in the script as I didn't specify it anywhere.
Why is it trying to use the Administrator acct on the SQL 2000 box? How do I prevent that from happening?