CODEWITHSUNDEEP
azure-sql-databaseazure-data-factory
Sowmya b
Sowmya b

Reputation: 1

Error while creating Azure IR:Check the linked service configuration is correct

Error while creating an Azure IR data factory.

Cannot connect to SQL Database: 'mysqlserversowmya.database.windows.net', Database: 'master', User: 'adminuser'. Check the linked service configuration is correct, and make sure the SQL Database firewall allows the integration runtime to access.

Upvotes: 0

Views: 2917

Answers (1)

Leon Yue
Leon Yue

Reputation: 16431

Make sure you have open the SQL database firewall: add client ip and Allow Azure services and resources to access this server On portal:

enter image description here

To see: Server-level IP firewall rules

Hope this helps.

Upvotes: 1

Related Questions