Tuesday, 14 July 2015

Executed as user: NT SERVICE\SQLSERVERAGENT. Server '' is not configured for RPC. [SQLSTATE 42000] (Error 7411). The step failed.

Dear all, 

While running SQLSERVERAGENT we get this error. 

For my case I used below query and my problem was solved.

Please run below query:

EXEC master.dbo.sp_serveroption @server=N'<Server Name>', @optname=N'rpc', @optvalue=N'true' 
exec sp_serveroption @server='<Server Name>', @optname='rpc out', @optvalue='true'


Thank you.

No comments:

Post a Comment