Results 1 to 11 of 11
  1. #1
    Join Date
    Aug 2004
    Posts
    24

    Unanswered: SQL Registration

    Our current production DBs are on windows 2000 and SQL Server 2000.
    We just installed SQL Server on new windows 2003 server.
    We need to copy the DB on to this new server.
    When I tried to register the new server, I am getting the error message as server does not exists or access denied.

    Could some one please assist on this why I am getting this error and how to solve this.

    Thanks

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    KB #884012.

    -PatP

  3. #3
    Join Date
    Jan 2004
    Location
    In a large office with bad lighting
    Posts
    1,040
    Are you a Domain Admin? Are you using NT only authentication or mixed mode authentication? Are they in the same domain? Do you know the sa password? Or are these questions you need to ask the prod DBAs and / or system engineers?

    These are the clues that will help you register a new sql server!

  4. #4
    Join Date
    Aug 2004
    Posts
    24
    I think when we installed the server we did mixed mode authentication.

    I am not sure what you mean by "Are they in the same domain?"

    Yes I know the sa password and I am trying to register through sa only.

  5. #5
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Quote Originally Posted by tomh53
    Are you a Domain Admin? Are you using NT only authentication or mixed mode authentication? Are they in the same domain? Do you know the sa password? Or are these questions you need to ask the prod DBAs and / or system engineers?

    These are the clues that will help you register a new sql server!
    Too many questions, while the answer was in the original post
    Follow Pat's link
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  6. #6
    Join Date
    Aug 2004
    Posts
    24
    That article says that we should install SP3 to overcome this problem. But we already have SP3 installed on the windows 2003 server.
    Do we have to do anything on the client machine also.

  7. #7
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Install SQL Server sp3.

    -PatP

  8. #8
    Join Date
    Aug 2004
    Posts
    24
    Where do we get SP3 to overcome this problem?

  9. #9
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    You get SQL-2000 sp3a from Microsoft.

    -PatP

  10. #10
    Join Date
    Aug 2004
    Posts
    24
    I checked the client software details from Help menu. It seems that I have SP3 version already. The information there is
    "Microsoft (R) Management Console1.2
    Virsion 5.0 (Build 2195: Service Pack 3)"

    I am not sure why I still not able to register through to the SQL server which is on windows 2003.

    Please advise.

  11. #11
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Check Services applet from Administrative Tools and see if the service is running. Also go to app error log on the server and look for the startup entries for MSSQLSERVER service.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

Posting Permissions

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