Error: DB Connection: Unknown User Failure

Issue

While attempting to connect to an Azure SQL Database, the following error appears:

DB Connection: Unknown user failure

Environment

Destination: Azure SQL Database

Resolution

To resolve this issue, do the following:

1. Verify that the User name and Password you provided when setting up your connection are correct and not expired.
2. Ensure the User name you provided doesn't include a domain or host name. For example, use fivetran instead of fivetran@hostname.
3. Confirm that the user account exists in the Azure SQL Database and has the necessary permissions, including read access. For more information, see our Azure SQL Database Setup Guide.
4. Check that the database is online and accepting connections.
5. Review Azure SQL diagnostic logs for additional error details. For more information, see the Microsoft documentation on monitoring Azure SQL Database.

Cause

This issue occurs due to one or more of the following reasons:

• Incorrect or expired credentials
• Insufficient user permissions
• Misconfigured or unavailable database
• Unsupported User format