Thursday, June 21, 2012

‘SERVERNAME’ is not configured for RPC

Error: Server ‘SERVERNAME’ is not configured for RPC
Code:
EXEC [LINKEDSERVERNAME].[DATABASENAME].dbo.[STOREDPROCNAME]
Problem: Attempting to execute a stored procedure across a SQL Server Linked Server

Fix: Enable "rpc out"
EXEC master.dbo.sp_serveroption 
     @server=N'LINKEDSERVERNAME'
   , @optname=N'rpc out'
   , @optvalue=N'true'

GO

No comments:

Post a Comment