SQL Sync Group not syncing to on-premise db, despite successful connection, schema read, connector showing ping success, db as reachable…

I have an Azure Hub SQL db, an Azure member db, and an on premise db.

All 3 are in the same sync group.

The on premise database lists the connector, the connector is selected, the connector can see the tables and fields, and the log shows successfully reading the table schema.

The two azure databases sync just fine.

The on premise database synced once, and never again. In my Event Viewer on my local machine, I see two entries, Event 770, with the error message of “Message=Object reference not set to an instance of an object.” as well as Event 13801, also with the message of ‘Message=Object reference not set to an instance of an object.’

I’m not sure where else to look especially since Azure can read the connector AND actually pull the schema successfully.

submitted by /u/az987654
[link] [comments]

Leave a Reply