Error: Error Code 22300 - Cannot connect to SQL Database: 'db-learn-azure.database.windows.net', Database: 'learn-azure-athul', User: 'athul'. Check the linked service configuration is correct, and make sure the SQL Database firewall allows the integration runtime to access. Cannot open server 'db-learn-azure' requested by the login. Client with IP address '20.xx.xx.xxx' is not allowed to access the server.
Cause: This happens because the IP address of the Azure Data Factory instance is not known by the Azure SQL Database.
Resolution:
1. Go to the Azure SQL Database instance in Microsoft Portal > Go to Firewall Settings >
2. Change the 'Allow Azure Services and Resources to access this server' to 'Yes' and save the firewall settings
3. Now try connecting again.
No comments:
Post a Comment