How do I add a SQL Server database as a linked service in Azure Data Factory?

amzzz 61 Reputation points
2022-08-12T15:03:19.08+00:00

I have tried using Connection String and entered the information and my login information but the error I get is:

Cannot connect to SQL Database: (server name), Database: (database name), User: (username). Check the linked service configuration is correct, and make sure the SQL Database firewall allows the integration runtime to access.

If the SQL Database firewall doesn't allow the integration runtime to access is there another way I can connect to the database as a linked service?

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,488 questions
0 comments No comments
{count} votes

Accepted answer
  1. Samy Abdul 3,366 Reputation points
    2022-08-12T15:23:48.27+00:00
    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful