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

Posted on 2011-10-10
Last Modified: 2012-05-12

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.
Question by:thyatt5473
    LVL 2

    Accepted Solution

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

    Expert Comment

    by:Anthony Perkins
    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.

    Author Comment

    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.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Find Ransomware Secrets With All-Source Analysis

    Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

    This is my first ever Article on EE or elsewhere; therefore, please bear with me if I have some discrepancies in my writing. I read many articles and questions related to "how to pass values to SSIS packages at run-time?"  Hence, this common ques…
    Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
    Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
    Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now