Hi, Every time I create a connection to a SQL server in BIDS, using SQL Server Authentication and checking the Save my password box and I go out of the project, the username and password disappears. Can anybody please assist as it is really frustrating to contineully have to retype the user name and password.

Hi Henkv1, Actually, there is checkbox called Save My password, please select it, If I misunderstand you, please feel free to let us know, and give the detail steps about your process of this issue. Thanks, Challen FuPlease remember to mark the replies as answers if they help and unmark them if they provide no help.

Or in Report Manager --under Data Sources click on your data source and type the password under chosen credentialsBest Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/