Cannot deploy SQL to NET4

When using the publish feature in VS2010, I cannot deploy the database using the crediantials supplied. I receive and error stating invalid username/password. I am able to deploy the web files with the same info. Note I have also tried the DB Publish from the Server Mgr in VS2010 and the connection will not work. I am able to connect to the db via SSMS 2008. Please advise.

 

Are you sure that you are using the correct SQL credentials? Bare in mind that the SQL Server is a separate server from the web server. We did this so that it gives our customers an extra level of security and performance. So the SQL credentials you use to connect to our SQL server will be a different login then what you use to connect to your hosting control panel.