Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2003
    Posts
    1

    Unanswered: Cant connect SQL server by Enterprise manager but no problem by Query analyzer

    I cant connect SQL server by Enterprise manager, then i try to connect it by Query analyzer it works !
    I have 2 SQL servers get the same problem, no matter how many time i try,
    Even I set the timeout to900 seconds, I still got the message in Enterprise manager..

    Help me please..!


    A connection could not be established to xxx.xx.xxx.x

    Reason: Timeout expired.

    Please verify SQL Server is running and check your SQL Server registration properties
    (by right-clicking on the xxx.xx.xxx.x node) and try again.

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    I have been able to get this working by going to the Client Network Utility and switching the primary network library from TCP/IP to Named Pipes or vice-versa. No idea why some machines prefer one over the other, but life would be boring, if we did not have these little things to keep us up all night ;-).
    ~Matt

Posting Permissions

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