Problems with read only (db_datareader) user trying to sync

paule123paule123 Posts: 44
edited May 19, 2011 5:04AM in SQL Compare Previous Versions
Source database: 64-bit SQL Server 2008 R2 on Windows 2008 R2 Ent
Destination: 32-bit SQL Server 2008 R2 on Windows 2003 Ent 32-bit

When a SQL user with db_datareader only access to the source database tries to sync to the destination, various warnings will appear, such as about triggers being encrypted or individual fields being encrypted. Calculated fields will fail. We don't use encryption on our db. If I specify a SQL user with db_owner permissions to the source db, everything works as it should.


  • Brian DonahueBrian Donahue Posts: 6,590 New member
    That sounds about right. You have to be a sysadmin on the source server to decrypt objects because you need access to the keys and permissions to dump pages out of the database.
Sign In or Register to comment.