Post reply

Take too much time to connect with databse from Enterprise Manager

  • April 8, 2005 at 12:14 am

    #87188

    Hi Folks,

          In my company We are using Windows Server 2000  in Server and Window xp in client machine. In every client machine Sql 2000 client version is loaded. From few days I noticed that when any user connect to database through SQL Enterprise Manager it takes too much time to connect with the databse.

    Can any one of you tell me what may be the reason and how to solve it??

    Thanks

    Niladri Saha

    Thanks & Regards,

    Niladri Kumar Saha

  • April 8, 2005 at 11:09 am

    #551640

    Try these 'network' troubleshooting ideas:

     

    1.  Try to connect by IP if you are connecting by 'name' now.

    2.  Ping the IP and hte name to ensure both are returning in sufficient time.

    3.  Connect from a machine on teh same subnet and record results.

    4.  Add  an entry (temporarily) to the host file representing your server and retest.

    In my experience, these type of things had to do with the wrong DNS entries on the clients with a problem.  Not saying thats the only case, but it is one I've seen in the past.

Viewing 2 posts - 1 through 1 (of 1 total)

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