Database Provisoning Error (Azure SQL - Data Sync)

Kevin Candy 20 Reputation points
2023-07-19T11:56:47.45+00:00

Hi Folks,

We have 2x Azure Managed SQL Databases - both in the same instance.

DB-A (Production)
DB-B (Development / test)

I am attempting to use a Databse Sync group to replicate the content from DB-A to DB-B for testing.

As DBA-A has over 500 tables I've already created the appropriate differing log in / user and set permissions to that it can only "see" 491 of the tables - All good there.

Challenge comes with I run the Sync group - the following errors are producted in the log

I've already

  • Reconfirmed login details for both DBs (inc re-enterting)
  • Re-set up Data sync
  • Made associated DB user sys-adm on both DB-A and DB-B

DB-A

Database provisioning failed with the exception "SqlException ID: fbf8435a-fee6-4804-afc6-272aa45ac120, Error Code: -2146232060 - SqlError Number:15247, Message: User does not have permission to perform this action. SqlError Number:2759, Message: CREATE SCHEMA failed due to previous errors. For more information, provide tracing ID ‘8f643c97-db2c-4b54-ad56-5cd68df7ab44’ to customer support."

DB-B

Database provisioning failed with the exception "SqlException ID: 9fc7d19a-a48f-4c89-bac6-4cc77b21ecf0, Error Code: -2146232060 - SqlError Number:15247, Message: User does not have permission to perform this action. SqlError Number:2759, Message: CREATE SCHEMA failed due to previous errors. For more information, provide tracing ID ‘f4edbcc7-5b7e-4685-8082-c2d20b9dd500’ to customer support."

My SQL knowledge is very basic so appreciate any insight

Many thanks :)

Azure SQL Database
0 comments No comments
{count} votes

Accepted answer
  1. Alberto Morillo 32,706 Reputation points MVP
    2023-07-19T12:58:00.5033333+00:00

    Azure SQL Data Sync is not supported on Azure SQL Managed Instance. See text highlighted in blue here.

    Please consider to use Replication instead. Here is the documentation about replicating data between two managed instances.

    1 person found this answer helpful.

1 additional answer

Sort by: Most helpful
  1. Alberto Morillo 32,706 Reputation points MVP
    2023-07-19T13:28:09.87+00:00

    Try to use the SQL Admin you defined when created the Azure SQL databases for the provisioning and SQL Data Sync setup. If you are using an account with less permissions, please make sure the account has the following permissions: Create/Alter Table, Alter Database, Create Procedure, Select/ Alter Schema, Create User Defined Type.

    0 comments No comments