Linked Server Error: Server 'MyServer' is not configured for RPC

If when you are trying to connect to a 2000 SQL server from 2005 you get the error:

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

You need to configure the RCP for your linked server, run the next command to be sure the RCP is not part of your server configuration:

-- Shows all your servers and the configurations 
exec sp_helpserver
------------------------------------------------

If the RCP is not there run the next commands to enable it:

-- Enables the RCP options
exec sp_serveroption @server='MyServer', @optname='rpc', @optvalue='true'
exec sp_serveroption @server='MyServer', @optname='rpc out', @optvalue='true'
------------------------------------------------------------------------------

You can also enable this option from the SQL Server Managment Studio:

• Righ click on your linked server
• Select properties
• On the "Select a page" option click on "Server Options"
• Be sure Rcp and Rcp Out are True