Share via

Cannot sync data from local DB to Azure

LD 1 Reputation point
2020-06-10T17:42:37.517+00:00

I get the following error when syncing local db to Azure:

Database provisioning failed with the exception "SqlException 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 ‘1516da52-5206-4694-b534-e5a345c66b06’ to customer support."

I can login to both the local DB and Azure DB. The tables show correctly, but no data is transfered.

Azure SQL Database

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Navtej Singh Saini 4,221 Reputation points Microsoft Employee
    2020-06-10T21:23:46.753+00:00

    Hi @LD-8962

    The issue here looks like to be case of getting correct privileges for your account. The document explains which privileges are required for different sync tasks.

    9774-capture.jpg

    Hope this helps.

    Thanks Navtej S

  2. Manu Philip 17,021 Reputation points MVP
    2020-06-11T18:56:17.477+00:00

    Hello,

    The reason for this issue can be the user with which you are trying to run the database provisioning does not have the 'sysadmin' privilege. If you logged in as domain admin user, domain admin user does not have the 'sysadmin' privilege by default.

    To grant 'sysadmin' privilege, connect SSMS and give the 'sysadmin' privilege to the user. Only a database administrator can give 'sysadmin' privilege to other users

    Please mark as "Accept the answer" if the above steps helps you. Others with similar issues can also follow the solution as per your suggestion

    Regards,

    Manu

    0 comments