![DBNETLIB][ConnectionOpen (Connect()).]SQL Server 不存在或访问被拒绝](https://linux22.com/image/676769/DBNETLIB%5D%5BConnectionOpen%20(Connect()).%5DSQL%20Server%20%E4%B8%8D%E5%AD%98%E5%9C%A8%E6%88%96%E8%AE%BF%E9%97%AE%E8%A2%AB%E6%8B%92%E7%BB%9D.png)
将包移至另一台服务器后,我无法使用存储过程xp_cmdshell
或作业来运行它。该包存在于文件系统中,我已将其添加到 SSIS 包存储中。如果我在 BIDS 中运行它,它就会运行。如果我从包存储中运行它,它就可以正常工作。当我尝试从作业或存储过程运行它时,我收到以下错误:
Error: 2016-02-11 15:10:29.80
Code: 0xC0202009
Source: Package Connection manager "MyServer.MyDB"
Description: SSIS Error Code DTS_E_OLEDBERROR.
An OLE DB error has occurred. Error code: 0x80004005.An OLE DB record is available. Source: "Microsoft OLE DB Provider for SQL Server" Hresult: 0x80004005 Description: "[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.".
End Error
Error: 2016-02-11 15:10:29.80
Code: 0xC020801C
Source: Data Flow Task OLE DB Destination [39652]
Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "MyServer.MyDB" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
End Error
Error: 2016-02-11 15:10:29.80
Code: 0xC0047017
Source: Data Flow Task DTS.Pipeline
Description: component "OLE DB Destination" (39652) failed validation and returned error code 0xC020801C.
End Error
Progress: 2016-02-11 15:10:29.80
Source: Data Flow Task
Validating: 100% complete
End Progress
Error: 2016-02-11 15:10:29.80
Code: 0xC004700C
Source: Data Flow Task DTS.Pipeline
Description: One or more component failed validation.
End Error
Error: 2016-02-11 15:10:29.80
Code: 0xC0024107
Source: Data Flow Task
Description: There were errors during task validation.
End Error
DTExec: The package execution returned DTSER_FAILURE (1).
SQL Server 服务和 SQL Server Agent 服务均使用本地系统帐户登录。我已将创建者名称和创建者计算机更改为已移动到的生产服务器。
这是我的包中的连接字符串:
Data Source=MyServer;Initial Catalog=MyDB;Provider=SQLOLEDB.1;Integrated Security=SSPI;Auto Translate=False;
提前感谢您提供的任何帮助。