I had a sql server express db managing my roles, etc. I need to change the data source from sql express to sql server because my hosting provider does not have sql express.

I want to make the changes locally first to ensure everything is working before I publish the database.

I successfully ran the asp.net configuration tool creating a new database with all the membership tables.

The new connectionstring inside my web.config file is below. Even though the password is shown here with the asterisks, I can assure you that it is spelled out correctly. I just obviously substiture it here for security reasons.
Data Source=bill-pc;Initial Catalog=ApplicationServices;Persist Security Info=True;User ID=wyeager;Password=*********

I then went into my Visual Studio 2010 project and deleted the sql server express db inside my app_data folder.

I then went into IIS 7 and added the above connectionstring to the asp.net connectionstrings. However, when I add the connectionstring, it always substitutes the asterisks for the password.

I believe the below error is because the asp.net configuration tool cannot successfully read the password for the connectionstring.

I then ran the asp.net configuration tool for my project and now gives me the below error.  I know it seems to be reading from the IIS connectionstring setting, because before, I didn't have any userid in there and just said "failed for user """. I added my userid and password and got the below error.

How can I successfully connect the asp.net membership tool with my new database?

There is a problem with your selected data store. This can be caused by an
invalid server name or credentials, or by insufficient permission. It can also
be caused by the role manager feature not being enabled. Click the button below
to be redirected to a page where you can choose a new data store.

The following message may help in
diagnosing the problem: Login failed for user 'wyeager'.