a noob database setup..help

EDIT: it's fixed .. I had a problem in the connection string and just fixed it by changing the astriks to the actual password..
I guess I should save the web.config and publish it and hope no one sees the password.. right?

/////
Hi there,
I'm a total noob and wanted to see if someone can be patient and help me out..

I built an asp.net website with a database.. the website works fine on my computer..

now I'm trying to put it online.. I've setup an account with discountasp and added the database add on.

I've also managed to connect to the database on the server and I can see it in the server explorer.. using visual studio 2008 sp1.

now do I need to add it to app_data? I just deleted my local one that I already copied to the server (I also made a local copy of it for backup)..

changed my connection string in my web.config to:
<connectionStrings>
<add name="MASDatabaseConnectionString" connectionString="Data Source=sql2k801.discountasp.net;Initial Catalog=SQL2008_647997_mas;Persist Security Info=True;User ID=SQL2008_647997_mas_user;Password=***********"
providerName="System.Data.SqlClient" />
</connectionStrings>

I copied this connection string from the server explorer properties for the connected database

When I try to run the website, I get :
Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'SQL2008_647997_mas_user'.

am I missing other steps?

 

...Good job. Don't worry about posting when you need help, we are all new at everything, at one time or another. ;-)
All the best,
Mark

 

thanks.. much appreciated