Azure数据工厂-到本地SQL数据库的新链接服务-错误 [英] Azure Data Factory - New Linked Service to On Prem SQL Database - Error

问题描述

仅尝试从Azure数据工厂连接到本地SQL Server，但无法这样做.测试连接说明时出现错误:

Just trying to connect to On Premises SQL Server from Azure Data Factory but unable to do so. Getting an error when testing the connection stating:

错误:{消息":处理您的请求时出错.请稍后再试."，"HttpStatusCode":"InternalServerError"，"XMsServerRequestId":null，"StackTrace":null}

Error: {"Message":"There was an error processing your request. Please try again in a few moments.","HttpStatusCode":"InternalServerError","XMsServerRequestId":null,"StackTrace":null}

不太确定缺少什么.

NB:Microsoft Integration Runtime都运行良好，并且其中的测试连接正常.

NB: Microsoft Integration Runtime is all running fine and test connection within it works fine.

任何帮助都是可取的.只是停留在这一步.谢谢

Any help would be appreciable. Simply stuck at this step. Thanks

推荐答案

你好

想了解更多一点，Integration Runtime是本地安装的吗?源sql服务器上的端口是开放的吗?

Want to understand a little bit more, Integration Runtime is installed on-prem?, what about the ports on the source sql server, are they open.

这篇关于Azure数据工厂-到本地SQL数据库的新链接服务-错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！