SSIS:ole db 源 [55] 错误 0xC0202009. [英] SSIS: ole db source [55] error 0xC0202009.

问题描述

我们有一个生产 SQL Server 实例 (Enterprise)，所有 SSIS 包都可以在该实例上正常运行.我们最近创建了一个开发服务器(在 SQL Server 开发版上)，并在尝试在 SSIS 中使用 OLE DB 连接时遇到了以下错误:

We have a production SQL Server instance (Enterprise), on which all SSIS packages run fine. We've recently created a development server (on SQL Server development edition) and have run into the below error when trying to use an OLE DB connection in SSIS:

[执行 SQL 任务] 错误:无法获取连接[SERVER NAME]".连接可能配置不正确，或者您可能没有此连接的正确权限.

[Execute SQL Task] Error: Failed to acquire connection "[SERVER NAME]". Connection may not be configured correctly or you may not have the right permissions on this connection.

[连接管理器[SERVER NAME]"] 错误:SSIS 错误代码 DTS_E_OLEDBERROR.发生 OLE DB 错误.错误代码:0x80004005.OLE DB 记录可用.来源:Microsoft SQL Server Native Client 11.0" Hresult:0x80004005 描述:由于打开服务器连接延迟，无法完成登录过程".

[Connection manager "[SERVER NAME]"] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80004005 Description: "Unable to complete login process due to delay in opening server connection".

值得注意的是，使用 ADO NET 连接可以正常工作.通过SSMS查询数据库也没有问题.

It might be worth noting that using an ADO NET Connection works fine. Also there are no problems when querying the database through SSMS.

推荐答案

将连接管理器超时限制更改为 0 以外的值，然后将其改回 0 以将超时设置为无限制解决了该问题.

Changing the connection managers timeout limit to something other than 0 then changing it back to 0 to set the timeout to unlimited solved the issue.

这篇关于SSIS:ole db 源 [55] 错误 0xC0202009.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！