连接到Azure SQL数据库 [英] Connect to Azure SQL Database

问题描述

我可以在不启用允许Azure服务选项的情况下从Data Factory连接到Azure SQL数据库吗?

Can i connect to Azure SQL Database from Data Factory without enabling Allow Azure Services option ? 

推荐答案

你好，

Azure文档指出，您需要允许Azure SQL DB防火墙中的Azure应用程序访问，尽管它没有特别提到允许访问Azure服务".框:

The Azure documentation states you need to allow Azure applications access in the Azure SQL DB firewall, although it does not specifically mention the "Allow access to Azure services" box:

https://docs.microsoft.com/zh-cn/azure/sql-database/sql-database-firewall-configure#connecting-from-azure

https://docs.microsoft.com/en-us/azure/sql-database/sql-database-firewall-configure#connecting-from-azure

https://docs.microsoft.com/zh-cn/azure/data-factory/connector-azure-sql-database#supported-capabilities

https://docs.microsoft.com/en-us/azure/data-factory/connector-azure-sql-database#supported-capabilities

在我自己的测试中，当我取消选中允许访问Azure服务"时，ADF中的Azure SQL DB链接服务开始无法通过测试连接.框，尽管在我取消选中它和连接之间有几分钟的延迟 开始失败.

In my own testing, my Azure SQL DB linked service in ADF began to fail test connections when I unchecked the "Allow access to Azure services" box, although there was a couple of minutes of lag between the time I unchecked it and the time the connections started failing.

这篇关于连接到Azure SQL数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！