make sure the SQL Database firewall allows the integration runtime to access

Hi Gunti GUNTI,

Thanks for posting your query on Microsoft Q&A!

The error message indicates that the login failed due to "Azure Active Directory only authentication" being enabled.

This means that your SQL Database is set to allow only Azure AD authentication, and regular SQL authentication won't work with the provided credentials. Additionally, if your integration runtime is not whitelisted, it may not have access to the database.

Steps to Resolve the Issue

1. Check Firewall Rules:
   • Go to your Azure SQL Database on the Azure portal.
   • Navigate to Networking under the settings pane.
   • Ensure that the firewall rules allow the IP address of your Azure Data Factory’s integration runtime. You can add the public IP of the integration runtime. You might want to select Add client IP to quickly allow your current IP if you are testing from the portal.
2. Verify Azure Active Directory Authentication:
   • Ensure that the login credentials you are using are Azure AD accounts since the server is configured for Azure AD authentication.
   • If needed, confirm your Azure AD setup and ensure that the user has sufficient permissions.
3. Configure Integration Runtime:
   • If you are using a self-hosted integration runtime, make sure that the IP address of the machine hosting the integration runtime is allowed in the SQL Database firewall settings.
4. Review Linked Service Configuration:
   • Double-check your linked service settings in Azure Data Factory to ensure that everything is configured properly, especially the connection string, username, and password.

Please refer the following Microsoft document for more details.

• Configure Microsoft Entra Authentication
• Set Firewall Rules for Azure SQL Database
• Troubleshooting SQL Authentication Issues in Azure Data Factory

I hope this helps, please let us know if you have further queries.

Thanks!

Kalyani

The error message is pretty clear. It seems that you are trying to use SQL authentication, but the server is not configured to permit SQL authentication. If you are in charge of the Azure server yourself, you can change this if you want to.

If you are not in charge of the server, you will need to talk to the admin and ask for instructions on how you should connect to the database. Most likely, you should use Entra authentication in some shape of form.