Results 1 to 7 of 7
  1. #1
    Join Date
    Jan 2002
    Location
    Ireland
    Posts
    32

    Unanswered: Unable to register local Server

    Hi,

    I am trying to register my local Sql2000 server. I can connect to all remote servers with no issues, however, when I attempt to use my own server instance I get a "Sql server does not exist or access is denied.ConnectionOpen(connect))"
    It then tells me to check my properties by this is not possible to edit either.
    I attempt access with both my NT login and sa account to no avail.
    All info would be appreciated.

  2. #2
    Join Date
    May 2002
    Posts
    4

    RE: Unable to register local server

    Try checking to see if you have named pipes enabled on your local server. I believe that is how Enterprise manager communicates with the server.

  3. #3
    Join Date
    Jan 2002
    Location
    Ireland
    Posts
    32
    Thanks for the reply..
    I have tried the Named Pipes with TCP/IP enabled but to no avail..
    Looks like a reinstall at this satge...
    Bummer....splutter...and spit...

  4. #4
    Join Date
    May 2002
    Posts
    4

    Re: unable to register server

    Have you tried connecting through another tool like query analyzer or creating an odbc connection?

    Dare I ask, could you have the wrong 'sa' password? If you try logging in via another method it might allow you to check that.

  5. #5
    Join Date
    May 2002
    Posts
    2

    Unhappy

    Hi,

    If you have not upgraded to sp2, do it and try again.

    good luck

  6. #6
    Join Date
    Feb 2002
    Posts
    2,232
    What operating system are you using ? Well anyway, I have seen this problem before. Normally, you use your machine name and that is it. If this is what you are doing, then try the following for a machine name of test:

    Register as test\test

    Good luck.

  7. #7
    Join Date
    Jan 2002
    Location
    Ireland
    Posts
    32
    Hi guys,

    I am using NT4 Server with all service packs for sql...
    I have tried registering all sorts of test servers and accessing through isqlw but no joy.
    I just reinstalled and that is it resolved now anyways...
    Love to find out what the hell it was though..all connection access and rights/named pipes etc were fine..
    Any road thanks for all the advice guys, hope I can be of some assistance to you in future..

Posting Permissions

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