跨库连接报错Server 'myLinkedServer' is not configured for RPC
2024-08-28 22:50:54
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'
最新文章
- ant windows环境配置
- C++ 中的std::vector介绍(转)
- 网络编程——基于TCP协议的Socket编程,基于UDP协议的Socket编程
- 内省操作javabean的属性
- [ ] 字符组(Character Classes) (转)
- 不学就吃亏的underscorejs类库学习示例 ——(集合篇)
- cf D. Levko and Array
- mysqlbackup
- transfer model derived to fk model format
- LaTeX数学模式&;上下标&;代码块
- c++ 面试题(算法类)
- ROS教程2 编写简单的消息发布器和订阅器 (C++ catkin)
- 创建SpringBoot项目pom.xml文件第一行报错:Non-parseable POM E:\maven\repository\org\springframework\securit
- Java理论学时第三节。课后作业。
- cloudstack secondary vm starting
- python 函数式编程学习笔记
- table中超过长度的列,显示省略号
- IP相关的方法
- PHP下ajax跨子域的解决方案之document.domain+iframe
- 数据库实例: STOREBOOK >; 表空间 >; 编辑 表空间: USERS