Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2008
    Posts
    3

    Unanswered: Remote Access MS SQL 2000

    Hello,

    I have problem with my SQL server. When I want to connect from localhost, its OK. But, when i want to connect it from other computer, i will recive this message: Timeout expire. If I try connect in enterprise manager of client, i will receive SQL Server does not exist or access denied.
    I have selected Mixed mode and I am not using firewall.

    Some solution? please help. Thank you very much.
    Last edited by peteril; 04-29-08 at 22:02.

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Are you trying to access a named instance? Is the server in the same domain as the client? Are you trying to access the server via EM from another computer or from the same computer where SQL is installed?
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  3. #3
    Join Date
    Apr 2008
    Posts
    3
    Quote Originally Posted by rdjabarov
    Are you trying to access a named instance? Is the server in the same domain as the client? Are you trying to access the server via EM from another computer or from the same computer where SQL is installed?
    Thank you for reply.
    When I use EM on computer where is server, it's ok. When I use EM on another pc, there is the problem.

    I am not in any domain, i have selected SQL mixed mode. I haven't named instance. Thank you for next help

  4. #4
    Join Date
    Apr 2008
    Posts
    3
    I installed SP3 and now its OK.
    Thank you for your help.

Posting Permissions

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