you need backup all data, uninstall the sql 2000,
reinstall sql 2000, the key point:
- remove security software like norton or mcafee
- reset winsock and netsh in command line: netsh winsock reset ok.txt
- reset tcp/ip in command line: netsh int ip reset ok1.txt
- install to a new location: eg: c:\sql2000 instead of the original default path
- service account: use local system account
- use: windows auth and SQL server auth
