fe_sendauth: no password supplied

More
5 years 9 months ago #12520 by BI beheer
BI beheer created the topic: fe_sendauth: no password supplied
After reactivating the Postgres OLEDB Provider server edition I got below error when trying to execute exported packages from SSIS and opening them in visual studio

[Connection manager "localhost.Mendix.postgres"] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "PostgreSQL Native Provider" Hresult: 0x80004005 Description: "Cannot open DB connection.".
An OLE DB record is available. Source: "PostgreSQL Native Provider" Hresult: 0x00000000 Description: "fe_sendauth: no password supplied
".

We have SSIS 2008 R2 SP1.
In Visual studio 2008 the connection manager can connect to the postgres database after reactivating the key but running the dataflow gives; 'fe_sendauth: no password supplied'
I tried to deploy to MSDB with the DeploymentManifest and typed in the user and password of the postgres database but in vain.

Building a new package does the trick?

Please Log in or Create an account to join the conversation.

More
5 years 9 months ago #12597 by admin
admin replied the topic: Re: fe_sendauth: no password supplied
Please check properties of the package. The properties should allow storing password in the package.

Alternatively, specify the user/password in the "Connection Managers" tab when executing the package.

Please Log in or Create an account to join the conversation.

Time to create page: 0.074 seconds
Powered by Kunena Forum