如何修复错误“SQL Server代理自动停止”？ [英] How to fix error "SQL Server Agent stopped automatically"?

问题描述

您好。我正在使用SQL Server 2014并遇到问题。



在任务管理器中，在服务标签上，我找到 SQLAgent $ VILLBE_SQLSERVER （VILLBE是我的电脑名称），右键单击开始。



它开始了并且...在1秒后停止。



然后，我打开 services.msc ，然后开始 SQL Server代理（VILLBE_SQLSERVER）。它正在工作。



30秒后，它自动停止。当我再次单击开始时，它说：

Hi. I'm using SQL Server 2014 and having a problem.

In Task Manager, on Services tab, I found SQLAgent$VILLBE_SQLSERVER (VILLBE is my computer name), right click and Start.

It started and... stopped after 1 second.

Then, I open services.msc, and Start the SQL Server Agent (VILLBE_SQLSERVER). It's working.

After 30 seconds, it stopped automatically. When I click Start again, it said that:

The SQL Server Agent (VILLBE_SQLSERVER) service on Local Computer started and then stopped. Some services stop automatically if they are not in use by other services or programs.

最后，我右键单击SQL Server Agent，选择< b>属性，设置启动类型是自动并重启我的电脑。



重启已完成，SQL Server代理仍然已停止



其他一些服务：

Last, I right click SQL Server Agent, choose Properties, set Start up type is Automatic and reboot my PC.

When reboot is done, SQL Server Agent still is stopped

Some other services:

SQL Server Browser - Running - Automatic (start up)
SQL Server (SQLEXPRESS) - Cannot start within warning: Windows could not start the SQL Server (SQLEXPRESS) on Local Computer....error code 17058.

你能不能给我解决问题？



谢谢！

Can you give me anyway to fix the problem?

Thank you!

推荐答案

VILLBE_SQLSERVER （VILLBE是我的电脑名称），右键单击开始 。



它开始并且......在1秒后停止。



然后，我打开 services.msc ，开始 SQL服务器代理（VILLBE_SQLSERVER）。它正在工作。



30秒后，它自动停止。当我再次单击开始时，它说：

VILLBE_SQLSERVER (VILLBE is my computer name), right click and Start.

It started and... stopped after 1 second.

Then, I open services.msc, and Start the SQL Server Agent (VILLBE_SQLSERVER). It's working.

After 30 seconds, it stopped automatically. When I click Start again, it said that:

The SQL Server Agent (VILLBE_SQLSERVER) service on Local Computer started and then stopped. Some services stop automatically if they are not in use by other services or programs.

最后，我右键单击SQL Server Agent，选择< b>属性，设置启动类型是自动并重启我的电脑。



重启已完成，SQL Server代理仍然已停止



其他一些服务：

Last, I right click SQL Server Agent, choose Properties, set Start up type is Automatic and reboot my PC.

When reboot is done, SQL Server Agent still is stopped

Some other services:

SQL Server Browser - Running - Automatic (start up)
SQL Server (SQLEXPRESS) - Cannot start within warning: Windows could not start the SQL Server (SQLEXPRESS) on Local Computer....error code 17058.

你能不能给我解决问题？



谢谢！

Can you give me anyway to fix the problem?

Thank you!

例如，尝试设置维护计划。这将给你的经纪人做点什么。

可能是服务没有运行，因为根本没有给它做什么。

它也可能是您正在使用SQL Server的快速版本，它不支持使用代理。无论如何都安装了傻，但这是事实。

Try to setup a maintenance plan, for example. This will give your agent something to do.
It may be that the service does not run because nothing at all is given to do to it.
It can also be that you are using an express version of SQL Server, which does not support the use of an agent. Silly that it is installed anyway, but that's a fact.

如下所述： http://dba.stackexchange.com/questions/55485/windows-could-not-start-the-sql- server-mssqlserver-service-on-local-computer-e [ ^ ]它似乎是权限错误。

As is described here: http://dba.stackexchange.com/questions/55485/windows-could-not-start-the-sql-server-mssqlserver-service-on-local-computer-e[^] it seems to be permission error.

这篇关于如何修复错误“SQL Server代理自动停止”？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！