可能未正确配置连接，或者您可能无法在此连接上拥有正确的权限 [英] Connection may not be configured correctly or you may not have the right permissions on this connection

问题描述

您好，

我在SSIS中有一个将平面文件加载到Netezza服务器的软件包。当我在我的机器上本地运行它时，它运行顺畅，没有错误。但是，当我在SQL Server中部署它并使用服务器代理执行它时，我得到2个错误：

1）无法获取连接"连接名称"。可能未正确配置连接，或者您可能无法在此连接上拥有正确的权限

2）  SSIS错误代码DTS_E_OLEDBERROR。发生了
OLE DB错误。错误代码：0x80004005。

OLE DB记录可用。来源："Netezza OLE DB

Provider" Hresult：0x80004005描述："客户端

无法建立连接"。

在工作步骤中，我进入了配置>连接管理器并手动添加密码值以连接到Netezza。这仍然无济于事。

任何帮助都会很棒，谢谢！

解决方案

您好，

运行时服务器上的SSIS版本是什么？

Hello,

I have a package in SSIS that loads a flat file into a Netezza server. When I run it locally on my machine, it runs smoothly and without error. However, when I deploy it in SQL Server and execute it with a Server Agent, I get 2 errors:

1) Failed to acquire connection "Connection name". Connection may not be configured correctly or you may not have the right permissions on this connection

2)  SSIS Error Code DTS_E_OLEDBERROR. An
OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Netezza OLE DB
Provider" Hresult: 0x80004005 Description: "Client
unable to establish connection".

In the job step, I went to Configuration > Connection Managers and manually added in the value for the password to connect to Netezza. That still didn't help.

Any help would be great, thanks!

解决方案

Hi there,

What is your SSIS version on the run-time server?

这篇关于可能未正确配置连接，或者您可能无法在此连接上拥有正确的权限的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！