SQL Server 2008 R2 Express，服务器上的服务停止
我有一个带有 SQL Server 2008 R2 Express 的虚拟 Windows 服务器。最近几天，当我早上起床检查我的网站时，它已关闭，因为 SQLEXPRESS 服务已停止。
我以前从未遇到过这个问题，而且非常令人担忧。我查看了管理下的 SQL 服务器日志，但它们没有提供任何信息，任何人都可以建议一个对这种情况有用的日志吗？
当我尝试通过管理工作室连接到我的数据库时，我收到此错误 -
建立连接时发生网络相关或特定于实例的错误 到 SQL Server。找不到服务器或无法访问服务器。验证实例 名称正确并且 SQL Server 配置为允许远程连接。 （提供者： 命名管道提供程序，错误：40 - 无法打开与 SQL Server 的连接）（Microsoft SQL Server，错误：2）
当我重新启动服务时，我可以连接并且我的站点重新联机。
查看 SQLEXPRESS 服务，我刚刚设置了一些恢复选项，因此如果它确实失败，它将尝试重新启动服务，如果后续失败，它将重新启动机器，但这只是一个安全网，我需要知道是什么导致它停止。
一些可能有用的额外信息。 我正在使用 SQLCacheDependancy，因此我在数据库上启用了 Broker。
这似乎是随机的，可能需要几周时间才会发生。
I have a virtual windows server with SQL Server 2008 R2 Express. for the last couple of days When I get up in the morning and check my site, its down, as the SQLEXPRESS service is stopped.
I have never had this problem before and its very concerning. I have looked in the SQL server logs, under management but they offer no information, can anyone suggest a log that would be useful for this situation ?
when I try and connect to my DB through management studio I get this error -
A network-related or instance-specific error occurred while establishing a connection
to SQL Server. The server was not found or was not accessible. Verify that the instance
name is correct and that SQL Server is configured to allow remote connections. (provider:
Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)
when i restart the service I can connect and my site is back online.
looking at the SQLEXPRESS service, I have just set some recovery options so if it does fail, it will attempt to restart the service, and if on subsequent failures it will restart the machine, but this is just a safety net, I need to know what is causing it to stop.
some extra informaton that may be of some use.
i am using SQLCacheDependancy, so i have enabled the Broker on the database.
It seems to to be random and may be weeks before it happens.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
我仍然不知道为什么它会停止，但设置 SQLEXPRESS 服务的恢复选项以在服务失败时重新启动已经解决了站点崩溃的问题。到目前为止我一直很好。如果我发现原因，我会将其发布在这里。
I still don’t know why it was stopping but setting the recovery options for the SQLEXPRESS service to restart if the service fails has resolved the site from falling over. I has been fine so far. If I discover the cause I will post it here.
看来原因是由于服务器资源减少到零，当发生这种情况时，有时会导致 SQL 服务器崩溃，我已经订购了一台新服务器，一个具有更多可用 RAM 的云托管解决方案。与此同时，我一直在监视当前的服务器资源，禁用任何非必要的服务，到目前为止一切顺利，没有停机；）
it appears the cause was due to the servers resources being reduced to zero and when that happened it sometimes crashed SQL server, I have ordered a new server, a cloud hosting solution that has much more available ram. In the mean time I have been monitoring my current servers resources, disabling any non essential services and so far so good, no downtime ;)