SQL Server Cannot connect to ODBC linked server in SSMS, but can in ODBC Data Sources

bpzcxfmw 于 2023-10-15 发布在其他

关注(0)|答案(1)|浏览(104)

I have a SQL Server instance on a company server which is linked to ServiceNow via their ODBC driver. As of this weekend, the connection fails when trying to test the connection under Linked Servers. At first I thought it was a password issue, but I tried testing the connection via ODBC Data Sources and was able to log in fine. I believe my IT department may have done something to block the traffic, is there anything else I can test to try and find the issue?

来源：https://stackoverflow.com/questions/77082284/cannot-connect-to-odbc-linked-server-in-ssms-but-can-in-odbc-data-sources

1条答案

按热度按时间

I was able to get this to work again by unticking 'Allow in-process' in MSDASQL under Linked Servers --> Providers.

This is apparently what ServiceNow recommends for ODBC connections.

Full instructions in the below videos:

https://www.youtube.com/watch?v=aSxzmXYDQHU https://www.youtube.com/watch?v=BtyMQsE8pvY

赞(0）回复(0）举报 2023-10-15

相关问题

热门标签

Java query python Node 开发语言 request Util 数据库 Table 后端算法 Logger Message Element Parser

最新问答

xxl-job 安全组扫描到执行器端口服务存在信息泄露漏洞
回答(1) 发布于 4个月前
xxl-job 不能和nacos兼容？
回答(3) 发布于 4个月前
xxl-job 任务执行完后无法结束，日志一直转圈
回答(3) 发布于 3个月前
xxl-job-admin页面上查看调度日志样式问题
回答(1) 发布于 4个月前
xxl-job 参数512字符限制能否去掉
回答(1) 发布于 4个月前