SQL Server – Server is not configured for RPC (Remote Procedure Calls)

Send Us a Sign! (Contact Us!)

--> (Word)	--> (PDF)	--> (Epub)	--> (Text)
--> (XML)	--> (OpenOffice)		--> (XPS)

Show More Info

This article has been read [post_view] times. This article has been read [post_view time="day"] times today. This article has been read [post_view time="month"] times this month. This article has been read [post_view time="year"] times this year. This article has 255 total words. (Including header) This article has been updated on [rup_display_update_date] [tweet]

I was setting up a new database on a new SQL Server 2005 installation that has a few linked servers configured (which happen to be SQL Server 2000), while testing execution of a remote stored procedure it failed with the error:

Msg 7411, Level 16, State 1, Line 1
Server 'psp6new' is not configured for RPC.

The problem was that RPC was not configured for the linked server. this is not set by default, you can see what settings are configured with:

exec sp_helpserver

If ‘rpc and rpc out’ are not in the results, then the the linked server isn’t configured for RPC. To do so:

exec sp_serveroption @server='myserver', @optname='rpc', @optvalue='true'
exec sp_serveroption @server='myserver', @optname='rpc out', @optvalue='true'

Or alternatively you can right click on your linked server bring up it’s properties and select True for the value from the RPC and RPC Out rows.

Hope this helps!

SOURCE	LINK (Lordfu.wordpress.com)	LANGUAGE	ENGLISH