Results 1 to 9 of 9
  1. #1
    Join Date
    Nov 2003
    Posts
    10

    Exclamation Unanswered: Connectivity from Client to Server

    Hai,


    I am often getting the message

    "SQL Server does not exist or access denied (Connection Open (Connect())"

    when connecting from the client sql 2000 to the server and at sometimes it gets connected and it still exists/persists for some time.

    though i checked the user rights, client server network utility where tcp/ip is the first protocol.

    Give a (me) way to connect to the server, though the user iam trying to connect works in the Query Analyser in the Server


    here,
    vijayanand.g
    Attached Thumbnails Attached Thumbnails sql_server_err_cntng.bmp  

  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    I know this a post from a previous post. I would try sql profiler and monitor the connections to see if the server is rejecting you or are you not getting there at all. You can use vnc or terminal services to connect to the server (for a good connection) and monitor your connection status.

    Let me know.

  3. #3
    Join Date
    Nov 2003
    Posts
    10
    Hai,

    Though i connect from the profiler the Server gives an error


    here,
    vijayanand.g
    Attached Thumbnails Attached Thumbnails sql_server_err_cntng_prflr.bmp  

  4. #4
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    149
    Is the server behind any firewall?
    Originally posted by g_vijayanand
    Hai,

    Though i connect from the profiler the Server gives an error


    here,
    vijayanand.g

  5. #5
    Join Date
    Feb 2002
    Posts
    2,232
    You need to execute the profiler either on the sql server or through a remote connection (using vnc or terminal services). Then try to connect on your machine and see what the profiler shows.

  6. #6
    Join Date
    Feb 2002
    Posts
    2,232
    Sorry - I just received your emails - I only have access to my email at home. Basically, you will need to find a machine that has access to the sql server (or login to the actual sql server) and run the profiler and see if at least the server sees that you are attempting to hit it.

  7. #7
    Join Date
    Nov 2003
    Posts
    10
    Hai,

    The profiler does not connect and trace the required samples.

    here,
    vijayanand.g
    Attached Thumbnails Attached Thumbnails prflr_cntrn_err.bmp  

  8. #8
    Join Date
    Nov 2003
    Posts
    10
    Hai,


    I tried to connect from other machine in sql enterprise manager and query analyser for the specified user, it connects - but through my login in the domain it does not connect.

    For the past 1 week iam trying to connect from a XP Machine , it does not connect, i tried to connect from a Windows 98 machine it connects, from a machine that has been logged as an administrator it connects, now i've changed my machines OS to Windows NT Server - now also not connecting .


    here,
    vijayanand.g

  9. #9
    Join Date
    Nov 2003
    Posts
    10
    Hai,

    Connected to the Server. It was due to the entry that did not exist for the specified machine in the Hosts file or LmHosts file for the specified machine name.

    The connectivity came when the connection was tested with the server by registering the Client by giving the ip address of the machine.


    here,
    vijayanand.g

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •