Database provisioning failed with exception 18456 Login failed.
Applies to: Azure SQL Database, Azure SQL Data Sync
Date created: January 24, 2021.
Problem Description.
After configuring SQL Data Sync between an Azure SQL database (hub database)
and a SQL Server on-premises database (a member database), the user receives the
following error on the Sync Group page:
Database provisioning failed with the exception
"SqlException ID: 15fe0018-3622-4854-80e7-3d4d5aad53f3,
Error Code: -2146232060 - SqlError Number:18456,
Message: Login failed. For more information, provide tracing ID
‘b1ac6b27-ba93-49fb-84e3-5df49504404e’ to customer support."
You open SQL Server Management Studio from the SQL Server on-premises instance
and you are able to connect successfully to the Azure SQL Database.
How to make Azure Data Sync work properly?
Solution.
Try to verify if the SQL login you used to configure the hub database
(the database in Azure) on the sync group has been disabled or the password has
changed?
On the Azure Database (the Hub database), provide the SQL Admin login with its
current password as as explained in
this article. If you have provided this information before, please do
this again.
- Click on Azure DBClick "Sync to other database".
- Click on the sync group which you have created.
- Click on the Databases.
- Click your hub server.
- Enter your username and current password.
- Try to sync.
On the section named "To add a SQL Server database" on the same
article, please configure the Sync Agent correctly as explained on the
article. On step #3, please provide the "sa" login and password of the
on-premises SQL Server instance (the member database). Review all steps on that
article.