Posted on Leave a comment

‘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
Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.