Post reply

troubleshoot, Server is up, but not able to access it from client

  • November 26, 2005 at 5:35 am

    #188613

    Hi Friends

    How to troubleshoot when the server is running, but

    the client is not able to connect/login with SErver.

    pls clear it.

     

    thanks

    JK.

    Thanks
    Jay
    http://www.sqldbops.com

  • November 28, 2005 at 4:20 am

    #606033

    check the authentication mode,might be windows change it to mixed mode

  • November 28, 2005 at 7:04 am

    #606062

    Can you connect to the server from itself? Say Query Analyzer or Enterprise Manager running on the server? If so, what do the SQL Server error logs say?

    K. Brian Kelley
    @kbriankelley

  • November 28, 2005 at 2:29 pm

    #606233

    Can you telnet to the port SQL Server is listening on?

    Like Prabhi says - check authentication mode.

    what error message is the client getting? 

     

  • November 28, 2005 at 5:07 pm

    #606260

    Here's a few general starting steps ...

    • ping from client to server by name ( e.g. ping name )

      ping from client to server by FQDN ( e.g. ping fully.qualified.domain.name )

    • ping from client to server by IP   ( e.g. ping -a 10.10.11.12 )
    • open up a telnet session on the server from the client (e.g. telnet name 1433)
    • optionally execute tracert ( e.g. tracert 10.10.11.12 )
    • optionally execute pingpath ( e.g. pingpath 10.10.11.12 )
    • check the client configuration utility
    • check the server configuration utility

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • November 29, 2005 at 11:02 pm

    #606619

    Thanks to all.

    I solved the problem with help of your valuable tips.

    thank you somuch.

    JK

    Thanks
    Jay
    http://www.sqldbops.com

Viewing 6 posts - 1 through 5 (of 5 total)

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