Membership Site DB Not Found

Hi, I just build a membership web site in Visual Studio using the standard log in controls. I've uploaded everything and attached the database, but the login form can't find the aspnetdb.mdf to verify username and password.

This is the error: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

And this is the connection string in the web.config:

<connectionStrings>
<add name="MyConn" connectionString="Data Source=tcp:sql2k513.discountasp.net;Initial Catalog=SQL2005_686809_aspnetdb;User ID=****;Password=****; encrypt=true" providerName="System.Data.SqlClient"/>
</connectionStrings>

I know the username and password are correct because I can log in from my local. I know the code is functional because it runs on the local. So the problem has to be with how the db was installed or how the config file is set up. Any ideas about how to go about troubleshooting this?

 

Here is an update on my problem getting my membership site (built with the asp login controls) to work. I just built a small solution in visual studio using the connection string and a sql command and loop to iterate through the user table, and it worked. (I ran it locally). So, my problem is defintely something to do with the web.config file because obviously all of the code needed to run the membership site is built into the asp login controls (built by microsoft, not me). Again, my error message is that the database cannot be found or does not allow remote connections (obviously it does allow remote connections because I just used this test to connect). My problem is that the Microsoft error messages are notoriously unspecific or wrong. You can have a runny nose and microsoft would tell you that your shoes are untied. I'm hoping that someone with a similar problem can clue me in.