Post reply

can not connect.

  • January 18, 2007 at 7:33 am

    #117070

    We have a server (DOG) that I can ping and remote connect to, but I can not connect with SQL Server Management Studio or any other query tool. I know it is somthing simple that I am just not seeing. Any suggestions

     

    Thanks


    Stacey W. A. Gregerson

  • January 18, 2007 at 7:59 am

    #684006

    Stacey

    Are you running SSMS on the server or remotely?  If remotely, is there a firewall between the two computers? What is the authentication mode of the server, and how are you trying to connect (trusted Windows login or SQL Server login)?  Any error messages?

    John

  • January 18, 2007 at 8:04 am

    #684018

    The server is a local server on the inside of the firewall. I have tried both SQL and Windows logins and I can not see it. I can not browse for it either.


    Stacey W. A. Gregerson

  • January 18, 2007 at 8:14 am

    #684023

    Can you telnet to the box on port 1433?

  • January 18, 2007 at 8:20 am

    #684025

    Stacey

    If I understand what you're saying, you're trying to connect from a computer on the same network as the server.  Have you looked at the Server/Client Network Utilities (or whatever the 2005 equivalent is) to check that they're both using the same protocol?  What happens if you try to connect using SSMS on the server?

    John

  • January 19, 2007 at 7:02 am

    #684281

    Make sure Allow Remote Questions is checked in the Connection  Properties.  You'll have to log on locally.

  • January 23, 2007 at 7:07 am

    #684914

    First i would like to thank all of those that offered help. It turns out that the Network team has been making changes and forgetting to let us know. They will be assisting me in finding out what they have done.

     

    Thanks again for your help.


    Stacey W. A. Gregerson

  • January 23, 2007 at 8:06 am

    #684942

    Okay, I can now connect but in the object explorer the status is blank. The indicator next to the server name is blank instead of red or green.

     

    Any ideas?


    Stacey W. A. Gregerson

  • January 23, 2007 at 8:17 am

    #684951

    I would first terminal into the box and fire up SSMS locally to see that everything is running correctly. If yes, then I would check that you're access is set up correctly, then I would check the Surface Area Config Manager to make sure you have remote connections enabled (Start\Programs\MSSql 2005\Configuration tools\Surface area config..)You could also check the SQL Server COnfiguration manager to make sure you have TCP\IP and or Named Pipes enabled.

    Rich

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply