Can I connect to a SQL Server instance not hosted by DiscountASP.NET?

Is it possible for my web app to connect to an instance of SQL Server 2005 (Express/Dev) that isn't hosted by DiscountASP.NET? (Or is that off limits?)



<add name="MyConString" connectionString="Data Source=mydbsite.com\SQL2005,25250;Integrated Security=false;Initial Catalog=MyDb;User ID=user;Password=password" providerName="System.Data.SqlClient" />


The errorsI'm seeingseem to be from the TCP stack...


Thanks in advance.

 

Error message is as follows:

(provider: TCP Provider, error: 0 - A connection attempt
failed because the connected party did not properly respond after a
period of time, or established connection failed because connected
host has failed to respond.)

I'm connecting toa namedSQL Server 2005 instanceon a non-standard port. Firewall has been configured to forward. Dynamic ports have been disabled and the server is configured to allow remote connections.

Thanks for your help.

 

Unfortunately this is difficult for us to diagnose since it is out of our network. If the targeted server is using a different port to connect you will need to specify that port in your connection string.

You might also want to contact the network administrator who manages that network to obtain more details on their network security settings.