windows SQL Server 服务在本地机器上不断停止
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/268347/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
SQL Server service keeps stopping on local machine
提问by ProfK
I have some update or something that tries to run every night, and ends up leaving the SQL Server service stopped. When the machine restarts, the service restarts properly. How do I go about diagnosing and fixing what is breaking my SQL Server service? I'm running SQL 2005 on Vista Business.
我有一些更新或尝试每晚运行的东西，最终导致 SQL Server 服务停止。当机器重新启动时，服务会正常重新启动。如何诊断和修复破坏我的 SQL Server 服务的原因？我在 Vista Business 上运行 SQL 2005。
回答by John Rudy
We've had this issue with SQL Server 2005 on our dev server. What was happening in our scenario was that the user account under which automatic updates were running wasn't a local machine admin. Automatic updates were in the queue, the machine tried to apply them to SQL 2005, was able to shut down the service but never restarted it after failing to apply the patches.
我们的开发服务器上的 SQL Server 2005 遇到了这个问题。在我们的场景中发生的情况是运行自动更新的用户帐户不是本地计算机管理员。自动更新在队列中，机器试图将它们应用到 SQL 2005，能够关闭该服务，但在应用补丁失败后从未重新启动它。
This may not be your scenario, but the symptoms sound similar. Event log entries? (They were the telltale for us; we Googled the message and found out about the auto updates.)
这可能不是您的情况，但症状听起来很相似。事件日志条目？（它们是我们的线索；我们在谷歌上搜索了消息并发现了自动更新。）
回答by Ed Guiness
First look in the event viewer to see if there is more information about why the service isn't starting, or to see exactly when it gets stopped.
首先在事件查看器中查看是否有关于服务未启动原因的更多信息，或者查看它何时停止。
回答by Jonas Lincoln
Check the event log and the sql server error log. They should provide you with hints or the actual error so you can fix it.
检查事件日志和 sql server 错误日志。他们应该为您提供提示或实际错误，以便您可以修复它。
