如何设置 SQL Server 代理？不在 Sql Server 管理中显示
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/23020117/
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
How to set up SQL server Agent? not showing in Sql Server Management
提问by Greg
I am trying to set up the SQL Server Agent on our test server running with windows Small Business Server 2011 Standard and SQL Server 2008 R2 RTM. The Sql Server Agent node is not displayed in Sql management studio.
我正在尝试在运行 Windows Small Business Server 2011 Standard 和 SQL Server 2008 R2 RTM 的测试服务器上设置 SQL Server 代理。Sql管理工作室中不显示Sql Server Agent节点。
Here is what I know according to forums I read:
以下是我根据我阅读的论坛所知道的：
- in services.msc, I have two Sql Server Agent (Sharepoint and SBSMonitoring) set as automatic. If I try to start the service, the following warning comes up: The SQL Server Agent service on Local Computer started and then stopped. Some services stop automically if they are not in use by other services or programs
- in SQL Server Configuration Manager, under SQL Server Services, I have an error "The remote procedure call failed [0x800706be]". Under SQL Server Network Configuration (32bit), nothing is listed.
- in Local Security Policy, Security Settings -> Local Policies -> User Rights Assignement: their is no Sql Server Agent Listed
- in Sql Server Management Studio I created a new user with all the rights possible and after I logged with this user, Sql Server Agent was not showing
- I did the following command mofcomp c:\program files (x86) \Microsoft SQL Server\100\Shared\sqlmgmproviderxpsp2up.mof" but it did not change the error "The remote procedure call failed" in SQL Server Services
- 在services.msc 中，我将两个Sql Server 代理（Sharepoint 和SBSMonitoring）设置为自动。如果我尝试启动该服务，则会出现以下警告：本地计算机上的 SQL Server 代理服务已启动然后停止。如果其他服务或程序未使用某些服务，则会自动停止
- 在 SQL Server 配置管理器中，在 SQL Server 服务下，出现错误“远程过程调用失败 [0x800706be]”。在 SQL Server 网络配置（32 位）下，未列出任何内容。
- 在本地安全策略中，安全设置 -> 本地策略 -> 用户权限分配：他们没有列出 Sql Server 代理
- 在 Sql Server Management Studio 中，我创建了一个具有所有可能权限的新用户，并且在使用该用户登录后，Sql Server Agent 没有显示
- 我执行了以下命令 mofcomp c:\program files (x86) \Microsoft SQL Server\100\Shared\sqlmgmproviderxpsp2up.mof”，但它没有更改 SQL Server 服务中的错误“远程过程调用失败”
Does anyone have a solution according to these facts?
有没有人根据这些事实有解决方案？
Thank you
谢谢
回答by Angel_Boy
select serverproperty('edition') returns Express edition. As confirmed you are using an Express edition. There is no way to get SQL Server Agent on this.
select serverproperty('edition') 返回 Express 版本。经确认，您使用的是 Express 版本。没有办法获得 SQL Server 代理。
