Problem restoring a SQL Server backup
Posted
by Elmex
on Stack Overflow
See other posts from Stack Overflow
or by Elmex
Published on 2010-04-23T07:14:11Z
Indexed on
2010/04/23
7:33 UTC
Read the original article
Hit count: 554
I have a SQL Server 2008, which is part of a domain. Now I make a backup of a database of this server and restore it on a SQL Server, which is not part of a domain. I have an C# application, which uses this database. On the NON-Domain machine I get now exceptions like this:
"Cannot execute as the database prinzipal because the principial "dbo" does not exist, this type of principal cannot be impersonatedm or you don not have the permission"
I think, the problem is, that the database owner is a domain user and this user doesn't exist on the target machine (backup machine)!? How can I solve this ?
© Stack Overflow or respective owner