The Temple of Fu

code, systems and games

Server is not configured for RPC(Remote Procedure Calls)

with 4 comments

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.

Set True for values RPC and RPC Out

Hope this helps!

Advertisements

Written by lordfu

April 23, 2010 at 10:51 am

Posted in Database, Development, MSSQL

4 Responses

Subscribe to comments with RSS.

  1. Thank you, it worked perfectly

    rahul@yahoo.com

    August 19, 2013 at 8:54 am

  2. Thank You worked perfectly – I tried first to execute the sql from another suggestion on another forum and it would not work, then I saw your screen shot and it work perfectly – Thank You.

    M Johnson

    October 17, 2013 at 4:08 pm


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: