SQL Azure Data Sync Failed Error Code -2146232060.

Applies to: Azure SQL Databases.
 

Problem Description.
 

A user had an on-premises SQL database and he wanted to sync with his Azure SQL Database and SQL Azure Data Sync kept throwing an error message each time a sync was attempted. age.

"Sync failed with the exception "GetStatus failed with exception:Sync worker failed, checked by GetStatus method. Failure details:SqlException Error Code: -2146232060 - SqlError Number:3952, Message: Snapshot isolation transaction failed accessing database 'XXXXX(My Azure Database Name)' because snapshot isolation is not allowed in this database. Use ALTER DATABASE to allow snapshot isolation. " For more information, provide tracing ID ‘b7e64cf2-825c-4ae1-8093-2e1191acb6a7’ to customer support."

Cause.

Read committed snapshot isolation is the default isolation level on SQL Azure. You cannot change the default isolation level.

SQL Data Sync is trying to enable on SQL Azure database the same isolation level your database has on premises, 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.

For more information:

http://social.technet.microsoft.com/wiki/contents/articles/1639.handling-transactions-in-windows-azure-sql-database.aspx 
 

.Send mail to webmaster@sqlcoffee.com with questions or comments about this web site.