SQL server issue

Posted on 2006-05-26
Last Modified: 2008-01-09
All of a sudden it will not let me start sql. I rebooted and no luck it says it can not start becauswe it is unable to find the path specified what do i do?
Question by:zenworksb
    LVL 75

    Expert Comment

    by:Aneesh Retnakaran
    is this the complete error message
    LVL 20

    Accepted Solution

    LVL 13

    Expert Comment

    Please post exact message. There are many reasons a server won't start. Security, corrupted master, model or TempDb databases, someone changing configurations.

    What has happened since it was last started? SP application? OS upgrade? Servername change (not usually an issue).

    Author Comment

    nothing that I know of, but here ar ethe messages I am getting

    The system failed to register host (A) resource records (RRs) for network adapter
    with settings:

       Adapter Name : {EA40B4D0-95A5-4573-A5C6-4AA2BEA5FD8A}
       Host Name : p01erinetweb
       Primary Domain Suffix :
       DNS server list :
       Sent update to server :
       IP Address(es) :

     The reason the system could not register these RRs was because of a security related problem. The cause of this could be (a) your computer does not have permissions to register and update the specific DNS domain name set for this adapter, or (b) there might have been a problem negotiating valid credentials with the DNS server during the processing of the update request.

     You can manually retry DNS registration of the network adapter and its settings by typing "ipconfig /registerdns" at the command prompt. If problems still persist, contact your DNS server or network systems administrator. For specific error code, see the record data displayed below.

    For more information, see Help and Support Center at

    The Security System detected an authentication error for the server DNS/  The failure code from authentication protocol Kerberos was "There are currently no logon servers available to service the logon request.

    For more information, see Help and Support Center at

    Failed auto update retrieval of third-party root list sequence number from: <> with error: This network connection does not exist.

    For more information, see Help and Support Center at

    The SQLSERVERAGENT service depends on the MSSQLSERVER service which failed to start because of the following error:
    The system cannot find the path specified.

    For more information, see Help and Support Center at

    The MSSQLSERVER service failed to start due to the following error:
    The system cannot find the path specified.

    For more information, see Help and Support Center at
    LVL 13

    Expert Comment

    Something ugly has happened. It looks like it is security. First issue is related to the server. You're server is not seeing the domain controller. So you aren't able to You need to get this solved first. Then you need to check your permissions on the SQL Server and verify the files are where they are supposed to be and the folders where the files are have the proper security.
    LVL 28

    Expert Comment

    try starting mssqlserver service under local system account and see if it is starting.
    LVL 5

    Expert Comment


    -- Change the startup account to LOCAL SYSTEM and see if it helps.
    -- When u attempt to start the SQL -- does it fails immediately or after some time... Chek the SQL error logs. .. are they getting generated.. if yes..any error messages there. If no.. Chek if u have SQLSERVR.EXE in the binn folder.
    -- Chek in te data folder .. do u have all the master databases mdf and ldf files.
    -- You can also try starting SQL from cmd prompt.


    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    Introduction In my previous article ( I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
    Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
    This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
    Viewers will learn how the fundamental information of how to create a table.

    731 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

    19 Experts available now in Live!

    Get 1:1 Help Now