Tuesday, December 28, 2010

Replication Error : the principal "dbo" does not exist, this type of principal cannot be impersonated, or you do not have permission

i was having this issue while implementing replication from SQL server 2008 to sql server 2005 . the DB on sql server 2008 was restored from another sql server 2005 server.

While Synchornizing the data with publisher data i have this error .

snapsthost is corrupted or not fully generated

so I just changed the owner of both databses on publisher server and also on subscriber server using this code
USE databsename
GO
sp_changedbowner sa -- to change DB Owner
ALTER AUTHORIZATION ON DATABASE::databsename TO sa --change the authorization schema.

No comments:

Post a Comment