在configure distribution时遇到错误，不能打开sql agent

 从网上找到的solution

--To resolve this error, following script has to be executed on the server.

sp_configure ‘show advanced options‘, 1;
GO
RECONFIGURE;
GO
sp_configure ‘Agent XPs‘, 1;
GO
RECONFIGURE
GO

 When you run above script, it will give a very similar output as following on the screen.

在configure distribution时遇到错误，不能打开sql agent

标签：