deploy web application with SQL Database

I have a simple web application with sql database. When I run the application on my localhost, everything is fine and I can access the database. However after I copy the website to the server , I am not able to access the database and ran to an error page. The connection string I use is :

"Data Source=tcp:sql2k510.discountasp.net;Initial Catalog=SQL2005_764602_database;User ID=SQL2005_764602_database_user;Password=******;"


I got the above connection string from MS SQL Database Manager on my account.

When I am on localhost the connection string is (This one Works just fine) :

connectionString = "Data Source=.\\SQLEXPRESS;AttachDbFilename = C:\\Documents and Settings\\Kam Parsen\\My Documents\\Visual Studio 2008\\WebSites\\Kam8\\App_Data\\Database.mdf;Integrated Security=True;User Instance=True";

Thank you

 

What's the error you're getting when viewing the page hosted by us? We'd probably have to check that out in order to see what the problem is.