1.SQL Server (MSSQLSERVER) startup failure, prompting " The request failed or the service did not respond in a timely manner.
---------------------------
SQL Server Configuration Manager
---------------------------
The request failed or the service did not respond in a timely manner. See the event log or other applicable error logs for more information.
---------------------------
Are you sure
log file :
2014-11-19 10:46:53.84 spid10s Error: 5123, severity: 16, State: 1.
2014-11-19 10:46:53.84 spid10s CREATE FILE encountered operating system error 5 (Access denied. While attempting to open or create the physical file ' E:\SQL\SQLSHILIE_ZWJ\MSSQL10. Mssqlserver\mssql\data\tempdb.mdf '.
2014-11-19 10:46:53.85 spid10s Error: 17204, severity: 16, State: 1.
2014-11-19 10:46:53.85 spid10s fcb::open failed:could not Open file E:\SQL\SQLSHILIE_ZWJ\MSSQL10. Mssqlserver\mssql\data\tempdb.mdf for file number 1. OS Error:5 (Access denied. ).
2014-11-19 10:46:53.85 spid10s Error: 5120, severity: 16, State: 101.
Workaround :
Pay all MDF and LDF Administrator privileges
2. After starting the service, go to the server, look at the database, found that some of the database is dead, using the above method to modify permissions, live.
SQL Server (MSSQLSERVER) failed to start, prompting "request failed or service not responding in a timely manner