I have a Windows 2003 server running MSSQL 2000. Occasionally my clients lose connection to the server. The only way I can seem to fix the issue is to reboot the SQL server. When I reboot the server I also have to re-enter the password for the login account for the service to start. Stopping and restarting the service does not help only a reboot. The service has not retained the password since I had to change the administrator password for our domain. I have also set up a local admin for the service to use but no luck there either. I've checked the logs but no errors show up when the disconnect occurs.
Any help would be greatly appreciated. I know this is a quick and dirty description of the issue so please let me know what other information you may need.