Web Installer forgets DB password

I was getting extremely frustrated by a problem with the database selection until I finally started adding more and more error information to the 'login failed' information.  When I started showing myself the connection string, I noticed that the password was always blank on the request following the postback after picking a database.

If anyone is interested (and I notice), then I can post the work around code that I made, which basically just involved writing a page level property to get at a stored copy of the password in the session for temporary use.

Sorry for the inconvenience.  This a known issue that existed only in the ASP.NET 2.0 web installer package when it was first released.  It has since been fixed and the download updated.

If you re-download the CS 2.0 for ASP.NET 2.0 web installer package and try it you should no longer have that problem.

I seem to have the same (or similar) issue. I downloaded a fresh copy of CS_2.0.60217.2664.zip (20060511) and copied the files to my server. I began the web installer process. After it prompted me for DB credentials, the installer presented a list of databases (this tells me the credentials are valid), however, after I select the database and click Next, the following error is displayed:

Number:18456:
Message:Login failed for user 'xxx'.

I have the same problem with the SDK  (CS_2.0.60217.2664_SDK.zip)

Make sure the /Installer/default.aspx file has this in it:

protected string DatabasePassword
{

get
{

string pass = ViewState["dbPass"] as string;
if(pass == null)
{

pass = "";
ViewState["dbPass"] = pass;

}
return pass;

}
set
{

ViewState["dbPass"] = value;

}

}

You may also want to just search the file and look into the following code path:

case WizardPanel.SelectDb