IT博客汇 | The operation could not be performed because OLE DB provider \"SQLNCLI10\" for linked server \"xxx.xxx.xxx.xxx\" was unable to begin a distributed transaction. - Insus.NET

The operation could not be performed because OLE DB provider \"SQLNCLI10\" for linked server \"xxx.xxx.xxx.xxx\" was unable to begin a distributed transaction. - Insus.NET

Insus.NET发表于 2021-08-30 10:55:00

【摘要】需要对执行链接数据库时，出现标题异常。那是因为目标数据没有配置好：目标数据打开以下几个选项： EXECUTE sp_configure 'show advanced options',1; GO RECONFIGURE; GO EXECUTE sp_configure 'remote access' 阅读全文