[Company Logo Image] 

Home Up Contents Coffee Break Credits Glossary Links Search

 
Database provisioning failed with exception 18456 Login failed

 

 

Home
Analysis Services
Azure
CLR Integration
High Availability
Open Source
Security
SQL Server 2008
SQL Server 2012
SQL Server 2014
SQL Server 2016
SQL Server 2017
SQL Server 2019
Tips
Troubleshooting
Tuning

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.
 

  1. Click on Azure DBClick "Sync to other database".
  2. Click on the sync group which you have created.
  3. Click on the Databases.
  4. Click your hub server.
  5. Enter your username and current password.
  6. 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.

 

 

 

.Send mail to webmaster@sqlcoffee.com with questions or comments about this web site.