Thanks a lot Ray!!  I really appreciate your help.  That worked

os version is windows XP Home edition.

I removed the sql server and reinstalled the sql server 2000. Still unable to install service pack 3 for sql server 2000 on my...

Here are the answers to your questions.

In the register wizard for Enterprise Manager, it lists the SQL Servers that are available. 

Is yours listed?

No mine is not...

Hi,

 I tired using local for the name of the server.  I am still unable to register.

I have installed SQlserver 2000 on my pc running on windows xp HOME EDITION and since I...

Thanks to all of you. Finally it worked.

Kb

Markus,

Thanks a lot for the info. I created a separte user account and made that account as the logon for the sqlserver agent startup service. ...