Sync Group issue after dacpac deployment on Member DB

Question

Hi, the SQL Sync Group was working fine earlier. But after deployment on Member Database via Azure DevOps pipeline, the Sync Job started throwing below error,
"Snapshot isolation transaction failed accessing database because snapshot isolation is not allowed in this database. Use ALTER DATABASE to allow snapshot isolation."

Answer 1

SQL Data Sync is trying to enable on SQL Azure database the same isolation level your database has on premises (snapshot isolation), but it is not possible to change the isolation level of a SQL Azure database. That is the reason the SQL Data Sync process will fail.

Set the isolation level of the database, to the same settings it has before the deployment.

Answer 2

Allowing SNAPSHOT_ISOLATION for Member Database resolved the issue

ALTER DATABASE <Database name>
SET ALLOW_SNAPSHOT_ISOLATION ON