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.
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 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.