Password dont save in Connection

Todd C

2009-02-13 17:52:05 UTC

This is not a bug. It is by design. MS started getting more secure and this
is a side benefit(?).

Since you are using SQL 2005 or 2008 and BIDS, you are using SSIS, not DTS,
dorrect?

Try this: Open a package and look at the package properties pane. look for
an entry "Package Protection Level".
--
Todd C

[If this response was helpful, please indicate by clicking the appropriate
answer at the bottom]

Post by GC
Hi,
I work with Sql Server Business Intelligence Development
I import a DTS coming from SQL 2000 server and the importation work with
succes
Now I want to edit a connection that is in the connection manager
I try to use a Sql Server Authentication and I click the radio button save
Password
I test the connection and the connection succes
I click OK and close the Connection Manager Window
When I try my DTS that use the connection, the connection failed
I open the Connection Manager for that connection and I realize that the
Connection Manager did not save my password even if I click the radio button
Save password
Is that a bug or am I doing something wrong?
If I use the Windows authentication it works well but I would prefer to use
Sql Authentication because when I will release those DTS to my client server
I dont want to have to edit every DTS.
Do you have and idea of how I can get through this problem?
Thanks in advance I have a nice Day!