Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Sharon911
Starting Member
46 Posts |
 Posted - 2010-06-22 : 11:28:36
|
| Hi,My sqlserver terminated unexpectedly,and this is no more infomation about why this happened, except for stack dump. Is there any tool can be used to diagnose the issue?Also, I see the following info in errorlog, does that mean server agent will autorestart the sql server service when the service is down?AutoRestart: Unable to restart the MSSQLSERVER service (reason: Access is denied) |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Sharon911
Starting Member
46 Posts |
Posted - 2010-06-22 : 16:03:46
|
| SELECT @@VERSIONMicrosoft SQL Server 2008 (SP1) - 10.0.2531.0 (X64) Mar 29 2009 10:11:52 Copyright (c) 1988-2008 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.0 <X64> I am not sure if we have a premier account(need to check with Sysadmin), does it come with the software license, or does it cost extra?Thanks for your advise. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Sharon911
Starting Member
46 Posts |
Posted - 2010-06-23 : 21:05:04
|
| Thanks Tara for your advice.Now I have another question here, How should I setup the permissions so sqlagent is able to restart the sqlservice when it stops unexpectedly?I have granted sysadmin role to the account which sqlservice and sqlagent are using, but still get this message:2010-06-23 20:40:48 - ! [012] The MSSQLSERVER service terminated unexpectedly2010-06-23 20:40:48 - + [139] AutoRestart: Attempting to restart the MSSQLSERVER service (attempt #1)...2010-06-23 20:40:48 - ! [368] AutoRestart: Unable to restart the MSSQLSERVER service (reason: Access is denied)2010-06-23 20:40:53 - + [139] AutoRestart: Attempting to restart the MSSQLSERVER service (attempt #2)...2010-06-23 20:40:53 - ! [368] AutoRestart: Unable to restart the MSSQLSERVER service (reason: Access is denied)2010-06-23 20:40:58 - + [139] AutoRestart: Attempting to restart the MSSQLSERVER service (attempt #3)...2010-06-23 20:40:58 - ! [368] AutoRestart: Unable to restart the MSSQLSERVER service (reason: Access is denied)Thanks |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Sharon911
Starting Member
46 Posts |
Posted - 2010-07-15 : 14:33:50
|
| Anyone have more experiences on this?I was also wondering how this Autorestart works but unable to find any more context.. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-07-15 : 18:42:36
|
| Have a fish around the stack dump. I normally find that some crap external code has caused it, and that one of our DEVs has chucked in something unstable, and the name of enough bits of the garbage is in the stack dump for me to point a finger! |
|
|
|
|
|
|
|
|
SQLSERVER crashed..