Thursday, July 31, 2008

Server ' ' is not configured for RPC

Just a quicky I came across this morning:

If you get the above message when trying to do a Remote Procedure Call across linked servers in SQL Server, your server is not configured to do so.

To fix this execute the following commands:

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

1 comment:

Anonymous said...

the variable value fo 'myserver' should be the logical name of the link server as it is set up on the box you are working on. Example. If the instance is called MSSQLSERVER and you set up a linked server as PODUCTIONINST, then 'myserver' will be PRODUCTIONINST.