'Sql Database sync error in azure Database Sync Group

I'm trying to connect my local database with online database. I've followed the full procedure but Database Sync Group is showing a log error of following type

Database provisioning failed with the exception "SqlException 

Database provisioning failed with the exception "SqlException ID: ebcc6489-1083-4635-aa5e-a34deecb61c1, Error Code: -2146232060 - SqlError Number:18456, Message: Login failed.  

For more information, provide tracing ID ‘3b685498-b462-4bde-b99b-0f1a156369c7’ to customer support."

enter image description here

Moreover hub database is not showing any table to select for sync but sync agent database is showing up.

Kindly please help me out.

sqlsql-serverdatabaseazureazure-sql-database


Solution 1:[1]

Try to verify the SQL login you used to configure the hub database on the sync group has been disabled or the password has been changed.

On the Azure Database, provide the SQL Admin login with its current password. If you have provided this information before try to do this again.

Follow these steps:

  • Click on the Azure DBClick “Sync to other database”

  • Click on the sync group which you have created.

  • Click on the databases.

  • Click on your hub server.

  • Enter your username and current password.

  • Try to sync.

Reference: Configure SQL Data Sync

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1

Related Questions