Database Connection Problem

Hello,

I just joined and restored a ms sql 2008 database on discountasp.net. I am running a local copy of my website and point to the new database on discountasp.net and everything works great.

My same website on discountasp.net, however does not work. The website files are identical to my local copy. I get the following 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)

In my web.config file I have the following:
<add name="MyConnection" connectionString="Data Source=tcp:sql2k801.discountasp.net;Initial Catalog=SQL2008_xxx_xxx;User ID=SQL2008_xxx_xxx_user;Password=xxx;" providerName="System.Data.SqlClient" />

(xxx is private information but is entered correctly).

I sent this to support and got blown off. Its strange because it works with my local copy of the site but not the copy on discountasp.net, which is identical. Has anyone else experienced this?

 

Figured it out

I figured it out, please disregard.