sql server報錯

標籤：can   turn   fail   state   tran   err   es2017   方法   mic   

刪除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報錯