sql-server - 在 Azure 上添加新的链接服务时，为什么会收到错误 22300？

Question

我是 Azure 新手。我目前正在探索 Azure Synapse。我的笔记本电脑上有一个本地 SQL Server Express 数据库，我想将其作为 Azure Synapse 上的数据源进行连接。我选择了 SQL Server:

现在，当我测试连接时，出现以下错误:

问题是我收到 22300 错误:

Cannot connect to SQL Database: 'DESKTOP-xxxxxx\SQLEXPRESS', Database: 'David', User: 'Bidi'. Check the linked service configuration is correct, and make sure the SQL Database firewall allows the integration runtime to access.
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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified), SqlErrorNumber=-1,Class=20,State=0,
Activity ID: eafe37de-fabf-43d6-914f-25e8685bb149.

我什至尝试在 SQL 配置管理器中启用该端口:

我制定了防火墙规则来允许该端口:

不幸的是，我仍然无法让 Synapse 上的链接服务连接到它。

任何帮助将不胜感激。

Answer 1

您需要安装Self-hosted integration runtime在您的本地网络中，例如在运行 SQL Server 的计算机上:

A self-hosted IR is capable of:

Running copy activity between a cloud data stores and a data store in private network.

参见the docs关于如何安装和配置运行时。