In this blog article, we will address a common issue encountered during database reprovisioning with Azure SQL DataSync. Specifically, we'll explore the error message "Database re-provisioning failed with the exception 'SqlException ID: XYZ-XXX-XXX-XXX-XXX86c961f, Error Code: -2146232060 - SqlError Number: 18456, Message: Login failed. For more information, provide tracing ID 'XYZ-XXX-XX-XXX-XXXX' to customer support.'" We'll provide a detailed explanation of the error, focusing on incorrect login credentials, and discuss how to resolve this issue in Azure SQL DataSync when working with both Azure SQL Database and SQL Server On-Premises environments.
Error Description:
When attempting to reprovision a database with Azure SQL DataSync, you may encounter an error indicating that the database re-provisioning has failed. The error message highlights a 'SqlException ID' along with an error code (-2146232060) and a SqlError number (18456). The message itself states, "Login failed. For more information, provide tracing ID 'XYZ-XXX-XX-XXX-XXXX' to customer support."
Explanation:
The error message suggests that the login process during database reprovisioning has failed due to incorrect login credentials. When Azure SQL DataSync attempts to authenticate and establish a connection to the database, it encounters a login failure, preventing successful database reprovisioning.
Resolution Steps:
To resolve the login failed error during database reprovisioning in Azure SQL DataSync, follow these steps:
-
Verify Login Credentials:
- For Azure SQL Database: Check the login username and password used for the Azure SQL Database. Ensure that the provided credentials are correct, including the spelling, case sensitivity, and special characters.
- For SQL Server On-Premises: Confirm the login credentials for the SQL Server instance. Ensure that the login username and password match the ones specified in the connection configuration.
-
Check User Mapping:
- For SQL Server On-Premises: If using SQL Server logins, ensure that the login is mapped to the appropriate database and has sufficient permissions to perform the required operations during database synchronization.
-
Retry Database Reprovisioning:
- After ensuring the correct login credentials and addressing any firewall or authentication issues, attempt to reprovision the database again using Azure SQL DataSync.
Microsoft
