Server 'myLinkedServer' is not configured for RPC

最新推荐文章于 2023-11-11 22:20:27 发布

转载最新推荐文章于 2023-11-11 22:20:27 发布 · 689 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：https://www.cnblogs.com/johnblogs/p/6893549.html

文章标签：

#sql server #链接服务器

Sql Server 专栏收录该内容

18 篇文章

订阅专栏

本文详细介绍了当遇到跨库连接错误'Server 'myLinkedServer' is not configured for RPC'时的解决方案。通常，这表明RPC未在链接服务器上正确配置。通过执行特定的SQL命令，可以在客户端服务器上为链接服务器启用RPC和RPCout选项，从而解决此问题。

跨库连接报错Server 'myLinkedServer' is not configured for RPC

Solution: Problem is most likely that RPC is not configured for your linked server. That is not a default option, after all. You can see what settings are configured with exec sp_helpserver, run on the client server (not the linked server).

If 'rpc,rpc out' is not in your results, then the the linked server isn't configured for RPC. To do so, run these two commands on the client server:

exec sp_serveroption @server='myLinkedServer', @optname='rpc', @optvalue='true' exec sp_serveroption @server='myLinkedServer', @optname='rpc out', @optvalue='true'