SQL DBA : Troubleshotting SQL Server Service Problems .

Problem :

My SQL Server service is not started . What may be the possible scenarios ?

Possible Reasons 

      * Logon Failure

              Problem with service account .

      * 3417

              Files are not present in the respective path or there are no permissions on target folder where the files are present .

      * 17113

              Master files are moved to different location but not mentioned in startup parameters.

      * Service cannot be started in timely fashion consult the event log or applicable error logs for detail .

         

       Solution 1 :  Insufficient resources , try to stop some other instances and start again .

       Solution 2 : Go to windows application error log to get additional details and if you find any error such as service didn't start due to a log on failure then immediately go to the SQL Server service properties and change the updated passwords.

       How to find errors ?

       1. Using windows event log : Start --> eventvwr --> In the Right side check for the errors .

       2. Using SQL Server error log file .

 Go to respective instance Log folder and open error log in notepad and check for the errors.