通过VNET的SQL连接 [英] SQL Connection over VNET

问题描述

我遇到一种情况，需要将Azure SQL实例连接到Azure VM上的SQL.每个实例都在通过VNET连接的不同Azure帐户中.我拥有"帐户A.帐户B是卖方的帐户.我有正确的SQL登录设置 权限和VM实例上的SQL的IP地址.已验证我可以从办公室的SSMS和Azure帐户的VPC登录.

I have a situation where I need to connect an Azure SQL instance to SQL on an Azure VM.  Each instance are in difference Azure accounts connected by a VNET. I 'own' account A.  Account B is a vendor's.  I have a SQL login setup with the correct permissions and a IP Address to the SQL on VM instance.  Verified I can login from SSMS in my office and from a VPC in my Azure Account.

我帐户中的VNET与Azure SQL实例和数据工厂连接到相同的资源组.

The VNET in my account is attached to the same resource group as the Azure SQL instance and Data Factory. 

我需要使用我的帐户中设置的外部数据源或数据工厂建立从帐户中的Azure SQL到供应商帐户中的SQL的连接.  

I need to establish a connection from Azure SQL in my account to SQL in the vendor's account using either an External Data Source or Data Factory provisioned in my account.  

直接从我的Azure SQL实例或数据工厂连接都失败.两者的特定错误是:与SQL Server建立连接时发生与网络相关或特定于实例的错误...未找到网络路径.

Connecting directly from my Azure SQL instance or a Data Factory both fail.  The specific error from both is: "A network related or instance specific error occurred while establishing an connection to SQL Server... The network path was not found.

有人对我需要在Azure中进行设置进行操作有提示吗?我已经用许多不同的方式在Google上进行了搜索，并且只想出了有关通过VNET入站Azure SQL实例的提示.  我的情况相反.

Does anyone have tips on what I need to setup in Azure to make this work? I've googled this as many different ways I could and only come up with tips on inbound to the Azure SQL instance over the VNET.   I have the reverse case. 

谢谢

D

推荐答案

如果正确设置了Azure SQL实例防火墙规则，并且正在从Vendors VM进行故障排除，具体取决于配置方式他们的VNET，您可能要考虑为SQL添加虚拟网络服务点.这是他们本应拥有的东西 在VNET上添加以启用与Azure SQL实例的连接，即使它们阻止Internet连接也是如此.

If you Azure SQL instance firewall rules are setup correctly and you are troubleshooting from Vendors VM, depending on how the configure their VNET, you may want to look at adding a Virtual Network Service point for SQL. This is something they would have to add on the VNET to enable connectivity to your Azure SQL instance even if they are blocking Internet connectivity.

https://docs.microsoft.com/zh-cn/azure/sql-database/sql-database-vnet-service-endpoint-rule-overview

https://docs.microsoft.com/en-us/azure/sql-database/sql-database-vnet-service-endpoint-rule-overview

我希望这会有所帮助.

尊敬的

古斯塔沃·洛佩兹(Gustavo Lopez).

Gustavo Lopez.

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