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

Filed under:
|
|
|

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

Related posts about sql-server

Related posts about backup