Answered by:
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.
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!"
- Edited by cnk_gr Sunday, October 5, 2014 5:51 AM
- Proposed as answer by Shanky_621MVP, Moderator Sunday, October 5, 2014 10:16 AM
- Marked as answer by Lydia ZhangMicrosoft contingent staff, Moderator Wednesday, October 15, 2014 10:10 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
-
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.
- 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.
-
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
- Proposed as answer by Shanky_621MVP, Moderator Sunday, October 5, 2014 10:16 AM
-
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!"
- Edited by cnk_gr Sunday, October 5, 2014 5:51 AM
- Proposed as answer by Shanky_621MVP, Moderator Sunday, October 5, 2014 10:16 AM
- Marked as answer by Lydia ZhangMicrosoft contingent staff, Moderator Wednesday, October 15, 2014 10:10 AM
-
Post the contents of the SQL ErrorLog file. Did you reboot after changing ServicePipeTimeout value in registry?
Satish Kartan www.sqlfood.com
-