It seems to me that the service account does not have sufficient rights on the machine. Check errorlog directory, check database files directory etc. Check also the right to run as service for that account.

Also there are some issues with SP2 for Windows XP and SQL Server 2000 with SP3. Google for some solutions for that.