Clients seem to lose connection with MSSQL Server and password retention issue

Hello,

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.
thyatt5473Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

yatin_81Commented:
Try changing SQL Server service account to LocalSystem. First time reboot the server and then check, the result should to satisfactory.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Anthony PerkinsCommented:
It sounds like the service is stopping for some reason.  I would look into Windows Events or SQL Server Error Log to find the reason why this is occuring.
0
thyatt5473Author Commented:
Thanks for both responses.  I will try changing the account today.  Oddly enough the service does not stop.  For all purposes the SQL server looks fine but the clients (who access the server via an odbc on a terminal server) cannot connect to the server.  It seems to happen randomly.  Also, I don't think it's a hardware issue because I can still connect to the server itself, just not SQL.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.