none
SQL Server Service can't start.

    Question

  • I was try start SQL Server Service in SQL Server Configuration Manager and it prompt out error 'The request failed or the service did not respond in a timely fashion.Consult the event log or other applicable error logs for details.' 

    I was try set HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control ServicePipeTimeout value to decimal 180000.

    I try also change the service account to local system but it prompt WMI error.

    But still failed to start the service.

    Could anyone help me? Thanks in advance.

    Sunday, October 05, 2014 4:11 AM

Answers

  • This may indicate a problem with your user profile. Try creating another local admin user (it's not necessary to be a local admin for starting sql service) but will definitely be safer. Then within SQL Server Configuration Manager change the user for the service to that one, or go to services and do the same for SQL Service.

    If that doesn't work open an elevated command prompt.

    Type CMD at search and right click on the shortcut, click "Run as administrator"

    Go to the directory you installed your instance e.g.:

    CD "C:\Program Files\Microsoft SQL Server\MSSQLEXPRESS.SQLEXPRESS\MSSQL\Binn"

    Then execute the following command:

    sqlservr.exe -s SQLEXPRESS

    Where SQLEXPRESS your instance name (or empty for default).


    "If there's nothing wrong with me, maybe there's something wrong with the universe!"


    Sunday, October 05, 2014 5:51 AM

All replies

  • Post the exact errors. Look in the error log and event viewer.



    Kalman Toth Database & OLAP Architect SQL Server 2014 Database Design
    New Book / Kindle: Beginner Database Design & SQL Programming Using Microsoft SQL Server 2014




    Sunday, October 05, 2014 4:20 AM
    Moderator
  • I check from event viewer it showing 30++ error

    I post some error here:

    • Windows cannot copy file \\?\C:\Users\Default\AppData\Local\Microsoft\Windows\Temporary Internet Files\Sqm\iesqmdata0.sqm to location \\?\C:\Users\MSSQL$SQLEXPRESS.NT Service\AppData\Local\Microsoft\Windows\Temporary Internet Files\Sqm\iesqmdata0.sqm. This error may be caused by network problems or insufficient security rights.
    • Windows cannot find the local profile and is logging you on with a temporary profile. Changes you make to this profile will be lost when you log off.
    • Windows cannot copy file \\?\C:\Users\Default\AppData\Local\Microsoft\Windows\Temporary Internet Files\Sqm\iesqmdata0.sqm to location \\?\C:\Users\TEMP.NT Service.001\AppData\Local\Microsoft\Windows\Temporary Internet Files\Sqm\iesqmdata0.sqm. This error may be caused by network problems or insufficient security rights.

      DETAIL - Access is denied.
    • Windows cannot log you on because your profile cannot be loaded. Check that you are connected to the network, and that your network is functioning correctly.

      DETAIL - Only part of a ReadProcessMemory or WriteProcessMemory request was completed.

    **I was using administrator account.

    Sunday, October 05, 2014 4:43 AM
  • Can you log in Windows with in a different (more powerful)  account ? A key phrase is DETAIL - Access is denied.

    Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

    MS SQL optimization: MS SQL Development and Optimization
    MS SQL Consulting: Large scale of database and data cleansing
    Remote DBA Services: Improves MS SQL Database Performance
    SQL Server Integration Services: Business Intelligence

    Sunday, October 05, 2014 5:26 AM
    Moderator
  • This may indicate a problem with your user profile. Try creating another local admin user (it's not necessary to be a local admin for starting sql service) but will definitely be safer. Then within SQL Server Configuration Manager change the user for the service to that one, or go to services and do the same for SQL Service.

    If that doesn't work open an elevated command prompt.

    Type CMD at search and right click on the shortcut, click "Run as administrator"

    Go to the directory you installed your instance e.g.:

    CD "C:\Program Files\Microsoft SQL Server\MSSQLEXPRESS.SQLEXPRESS\MSSQL\Binn"

    Then execute the following command:

    sqlservr.exe -s SQLEXPRESS

    Where SQLEXPRESS your instance name (or empty for default).


    "If there's nothing wrong with me, maybe there's something wrong with the universe!"


    Sunday, October 05, 2014 5:51 AM
  • Post the contents of the SQL ErrorLog file. Did you reboot after changing ServicePipeTimeout value in registry?

    Satish Kartan www.sqlfood.com

    Sunday, October 05, 2014 6:10 AM