I am receiving following error when I click on test connection in the linked service. Linked service is configured using a self hosted integration runtime. IR is up and running without any issue. What could be the reason for this?
Connection failed Cannot connect to SQL Database: 'xxxxxxx', Database: 'xxxxx', User: 'xxxx/xxxx'. Check the linked service configuration is correct, and make sure the SQL Database firewall allows the integration runtime to access. The operation completed successfully Activity ID:
Thanks
