Connection string question MS SQL.

Discussion in 'Databases' started by hexane, May 14, 2004.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. hexane

    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)
     
    hexane, May 14, 2004
    #1
  2. Aristotle

    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.
     
    Aristotle, May 14, 2004
    #2
  3. hexane

    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, May 14, 2004
    #3
  4. hexane

    hexane

    Hello!
     
    hexane, May 14, 2004
    #4
  5. Bruce

    Bruce DiscountASP.NET Staff

    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


    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">
     
    Bruce, May 14, 2004
    #5
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page