I have installed MSDE2000A on both 2000 and XP Pro machines, the install
appears to go fine. After the reboot, the service manager icon is empty,
when I look for the services in the drop down in the Service Manager it is
empty. In the system services screen, I have made sure all three services
are running. I cannot restore a database on this machine or connect to it

Hi ,
First of all when you say the msde installtion "appears" to be installed
fine , have you verified the setup log file to see if the msde did indeed
install sucessfully or if there are any messages

Please follow the steps mentioned below to solve the problem:
1) verify the setup log for any error messages (most probably the msde
wasnever installed properly in the first place)
2) Can you see the msde services in the services . Try to start them
manually
3) Connect to the instance locally with the followong command

<installdrive>\program files\microsoft sql server\80\tools\binn \osql -E
-Sservername\instancename

do not use the -S parameter if default instance is used.
4) If you connect successfully then the msde is correctly installed.
5) Ensure that the tcp/ip is enabled using the client configuration tool
(cliconfg.exe) and also the server network utility (svrnetcn.exe )
6) try manually typing the server name in the service manager when it comes
out empty and then try to connect


Girish Sundaram
This posting is provided "AS IS" with no warranties, and confers no rights.

I have seen this on Win 2003 where MSDE-Rel A is installed using an Instance
Name and there is no default instance.

Tim Morrison

[quoted text, click to view]