首页 > 数据库技术 > 详细

sql server报错

时间:2017-11-08 17:11:38      阅读:467      评论:0      收藏:0      [点我收藏+]

删除SSIS作业时报错信息:

TITLE: Microsoft SQL Server Management Studio
------------------------------

Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

SQL Server blocked access to procedure ‘dbo.sp_get_sqlagent_properties‘ of component ‘Agent XPs‘ because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of ‘Agent XPs‘ by using sp_configure. For more information about enabling ‘Agent XPs‘, search for ‘Agent XPs‘ in SQL Server Books Online. (Microsoft SQL Server, Error: 15281)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&ProdVer=11.00.5058&EvtSrc=MSSQLServer&EvtID=15281&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

技术分享

 

解决方法:

启动Agent XPs

sp_configure ‘Agent XPs‘, 1;
GO
RECONFIGURE
GO

 

sql server报错

原文:http://www.cnblogs.com/dba-wyt/p/7804554.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!