Help connecting to my db via sql management studio

Discussion in 'Databases' started by wescottands, Feb 23, 2011.

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

    wescottands

    Hi,

    I have SQL Server 2008 R2 installed on my machine. I can't seem to connect to my discountasp.net database through sql management studio. My web app works perfectly with the connection string given to me from my control panel but when I use these details in management studio I receive the error:

    "a network related or instance specific error occurred...server was not found or was not accessible..."

    Do I have to enable remote access within management studio? Is my firewall stopping me from accessing external servers? I can connect to local sql instances (.\SQLEXPRESS etc) but not the server name given to me by discountasp? I just want to have a look at my database tables.

    Thanks.
     
    wescottands, Feb 23, 2011
    #1
    moroako3 likes this.
  2. Joseph Jun

    Joseph Jun DiscountASP.NET Staff

    It's possible that access over port 1433 is being filtered by a firewall or even at a higher level by your Internet service provider.

    You may want to try connecting to your server using port 14330.

    Try using tcp:yoursqlserver.discountasp.net,14330 as the server name to see if you can connect.
     
    Joseph Jun, Feb 23, 2011
    #2
  3. wescottands

    wescottands

    Hi,

    Now I get the attached error....

    Thanks.
     

    Attached Files:

    wescottands, Feb 23, 2011
    #3
  4. RayH

    RayH DiscountASP.NET Lackey DiscountASP.NET Staff

    Have you tried connecting with your antivirus/firewall disabled?
     
    RayH, Feb 23, 2011
    #4
  5. Jose

    Jose

    Try doing a telnet to the SQL server to see if you're able to connect at all:

    To do a telnet, you can do the following:
    1. Click on the Start button, and select Run..
    2. On the Open field, type in "CMD" and hit OK.
    3. In the Command Prompt, type "telnet SQLSERVER.discountasp.net 1433". If it times out, it means you're unable to reach the server through the default port.
    4. If the previous times out, try "telnet SQLSERVER.discountasp.net 14330". This is the alternate port.
     
    Jose, Feb 23, 2011
    #5
    moroako3 likes this.
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