Accessing DiscountASP MS SQL DB from another Hosting Provider

We are setting up a test environment for our web site at another hosting provider and want to access our current database at DiscountASP. Sorry, this was an existing account that was available to us.

The first thing we did was upload the current site we host on DiscountASP to our test environment. Everything is up and running except for our database access. I expected the same connection string from our current site to work on our other external hosting site.

"Data Source=tcp:XXXXXXX.discountasp.net;Initial Catalog=CATALOG;User ID=USERNAME;Password=PASSWORD"


A quick analysis of one of our ASPX pages trying to load data from the database shows the following error upon calling connection.Open():

DebugP: SqlException(10060), Error Message text is:
System.Data.SqlClient.SqlException: 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.

I looked for answers and found some good tips, such as specifying the port (1433 and 14330) in the connection string for the Data Source, but no luck.

Does anyone know what could be happening? Is DiscountASP blocking outside access? Is our other hosting company blocking access to external DBs?

Any answer, help or direction to find the cause would be appreciated.

Thanks.

 

You should be able to use database in our server from a webform hosted on another server as we do not block it. Make sure you pass correct credential in the connection string

 

Thanks for the quick reply and definite answer. The problem is most likely with the other provider and we may need to copy the DB to the test site for now.

 

I confirmed that the other provider is blocking access to databases outside their center. I'll need to copy the DB for testing.

For others reading this post, I was able to successfully access my discountASP database from other external test locations running my web site using the same, original connection string.

Cheers.