Trouble Connecting to Azure SQL Database in Azure Data Factory

Question

Hello Azure community,

I'm encountering an issue while trying to connect to an Azure SQL Database from Azure Data Factory. Here are the details:

Error Message: "Cannot connect to SQL Database. Please contact SQL server team for further support. Server: 'server-of-harsha.database.windows.net', Database: 'Database-of-Harsha', User: 'Harsha@jain'. Check the linked service configuration is correct, and make sure the SQL Database firewall allows the integration runtime to access. Cannot open server 'jain' requested by the login. The login failed., SqlErrorNumber=40532,Class=20,State=1."

Linked Service Configuration: I've configured the linked service with the correct server name ('server-of-harsha.database.windows.net') and database name ('Database-of-Harsha'). The user I'm using is 'Harsha@jain'.

Firewall Settings: I've checked the firewall settings of my Azure SQL Database, and it allows access from Azure Data Factory's integration runtime IP addresses.

Despite these configurations, I'm still unable to establish a connection. I've verified the login credentials and reviewed the permissions, but the issue persists.

Could anyone please provide guidance on how to resolve this issue? Any insights or troubleshooting steps would be greatly appreciated.

Thank you in advance for your assistance.