The SSIS package keeps forgetting the password

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server Newbies » The SSIS package keeps forgetting the...

The SSIS package keeps forgetting the password

Rate Topic

Display Mode

Topic Options

Author

Message

montse 22199

Posted Wednesday, March 06, 2013 11:57 AM

Grasshopper

Group: General Forum Members
Last Login: Monday, April 22, 2013 2:08 PM
Points: 19, Visits: 63

I have a SSIS Package that is giving me an error connection

'Test connection failed because of an error in initializing provider. Login failed for user.....

The package does not remember password.

Im connecting to a SQL Server 2005 box using its user_password with sysadmin role.

The SSIS package runs fine when you first set up the connection in bids

The bottom line is that SSIS keeps forgetting the password I feed into
the two Connections that I'm using. I double-click a connection,
type the password in, check "Save my password" and hit "OK" but the
password disappears from there whenever I run the package or
double-click the connection again.

Is anyone know what to do!! please help!! I have a very short time to deploy this package in production.

Post #1427568

Rick Krueger

Posted Wednesday, March 06, 2013 3:00 PM

SSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 8:50 AM
Points: 262, Visits: 576

The first thing I would check is the Package ProtectionLevel. The appropriate setting for you will be specific to the environment you are running in, but it sounds like you still have it set to DontSaveSensitive - which won't save passwords. For more information, see Setting the Protection Level of Packages.

Rick Krueger

Follow @dataogre

Post #1427654

« Prev Topic | Next Topic »

Permissions