<div>
<div class="content wysiwyg-content">
We are using transactional replication to replicate 3 tables from a sql 2008 database to a sql2012 database. Replication is is removing permissions from the sql2012 database.<br />
<br />
I thought it was the snap shot at initiation that was causing it but the log shows the snapshot was delivered at 6:00 PM and the permissions were altered some time after 10:00 PM.<br />
<br />
Any ideas on what is happening and how to stop it?
</div>
</div>


We are using transactional replication to replicate 3 tables from a sql 2008 database to a sql2012 database. Replication is is removing permissions from the sql2012 database.

I thought it was the snap shot at initiation that was causing it but the log shows the snapshot was delivered at 6:00 PM and the permissions were altered some time after 10:00 PM.

Any ideas on what is happening and how to stop it?

sql replication removing permissions on database

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.