Results 1 to 6 of 6
  1. #1
    Join Date
    Nov 2007
    Posts
    19

    Unanswered: Can't run SQL Server 2000 Developer on XP MCE

    I started with SQL Server 2005 Express and created a database. Due to circumstances I needed SS 2000. Uninstalled SS 2005 and installed SS 2000 without incident. I already had SS 2000 Enterprise Manager running with other client databases registered.

    When I went to Ent Mgr and tried to register my new SS 2000 instance, I got this error: "A connection could not be established to LOYDSLAPTOP. Reason: SQL Server does not exist or access denied. ConnectionOpen (Connect()). Please verify the server is running and check your SQL Server registration properties (by right-clicking on the LOYDSLAPTOP node) and try again."

    I have verified that the following services are both running: MSSQL$SQLSERVER2000 and SQLAgent$SQLSERVER2000.

    I am certain that I used the sa user with password originally entered when I installed SS 2000 when I tried to register/connect to the local instance of SS. Plus I also tried to connect using the domain user and password entered when I installed SS and got the same error message.

    What am I doing wrong? What do I need to change?

    Thanks for any help anyone can offer.

  2. #2
    Join Date
    Nov 2006
    Location
    Quebec
    Posts
    172
    Shouldn't you use MSCE to run MSSQL SERV 2000 in Windows XP ?
    Less is more.
    How long is now?
    http://www.lesouterrain.com

  3. #3
    Join Date
    Nov 2007
    Posts
    19
    Not sure what you mean. I googled MSCE and all I got were misspellings of MCSE, or perhaps that is a previous certification from Microsoft. I called MS tech support and they told me that Win XP MCE was not a supported OS, so I guess I'm hosed on that.

    Thanks anyway for trying.

  4. #4
    Join Date
    Nov 2006
    Location
    Quebec
    Posts
    172
    Sorry for the typo, I meant MSDE, and I can tell you it works. I use it on my xp.

    http://www.microsoft.com/downloads/d...displaylang=en
    Less is more.
    How long is now?
    http://www.lesouterrain.com

  5. #5
    Join Date
    Nov 2007
    Posts
    19
    Ortho,

    Thanks for the info. That would have been a great suggestion. I am going to try and get the vendor to take back the SQL Server 2000 Developer Edition and trade it for a 2005 DE. I have already uninstalled the SS 2000 and reinstalled 2005 Express. Also, the hosting company was gracious enough to move us to a SS 2005 server and the backup file I created previously with 2005 Express worked beautifully, so I guess my problems are solved - except for getting my client's costs for the SS 2000 DE put to better use.

    Thanks again for the help.

  6. #6
    Join Date
    Nov 2006
    Location
    Quebec
    Posts
    172
    2005 Express is the equivalent of MSDE but in 2005 version.
    Less is more.
    How long is now?
    http://www.lesouterrain.com

Posting Permissions

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