Connection string question MS SQL.

[hexane]

Oh ok... so at least your saying that calling the SQL server through the fully qualified name (i.e. mssql05.discountasp.net) shouldn't be a problem. I wonder if my ISP blocks that port by default, any idea how I can tell? (assuming it's not a firewall or local router issue)

[Aristotle]

To check if you can connect to port 1433, do a telnet in the command prompt:

telnet mssql05.discountasp.net 1433

If you get a "Could not open connection to the host" error message, then your ISP has blocked the outgoing port to 1433.

[hexane]

I have been trying to use a connection string from another application not on a discountasp.net server, but I get server doesn't exist or access denied message. Is this not a valid way to do such a call?

"Data Source=mssql05.discountasp.net;Initial Catalog=blah;User ID=blah;Password=blah"

Thank you for your time! [:)]

[hexane]

Hello!

[bruce]

this error indicate that the sql server cannot be reached from a network perspective, ie. the network where the app located does not allow port 1433 traffic through


[b]quote:Originally posted by hexane

I have been trying to use a connection string from another application not on a discountasp.net server, but I get server doesn't exist or access denied message. Is this not a valid way to do such a call?

"Data Source=mssql05.discountasp.net;Initial Catalog=blah;User ID=blah;Password=blah"

Thank you for your time! [:)]
</blockquote id="quote"></font id="quote">