我们在两个不同的AZURE帐户中有两个SQL数据库服务器 . 我们希望从Server1中的数据库向Server2添加外部数据源 . 数据源被添加,但在尝试访问外部表时,我们得到:

Msg 46823, Level 16, State 2, Line 1
Error retrieving data from one or more shards.  The underlying error message received was: 'A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)'.

似乎server1上的防火墙不允许连接 . 我们已经添加了“允许Azure服务访问”,甚至尝试将服务器的IP添加到防火墙中,但没有任何作用 .

我们如何在两个不同的帐户中 Build 数据库服务器之间的连接?