MS SQL Server - SQL 2005 stored proc linked server

Author

SQL 2005 stored proc linked server

cathedr@wa.state.gov

2006-01-30, 8:23 pm

I set up a linked server and attempt the following command:
exec serverX.dbX.dbo.procX
I get this message:
Server 'serverX' is not configured for RPC.
This used to work in the beta version of 2005.

Running a select still works:
select * from serverX.dbX.dbo.tableX

The help file is worthless since it tells me to use a linked server...
Anyone have an idea what I am missing???

Goose

2006-01-31, 3:23 am

Go back to the properties of 'serverX' linked server. On the 'Server
Options' properties sheet, select the RPC (from the server) and RPC out (to
the server) check box.

"cathedr@wa.state.gov" wrote:

> I set up a linked server and attempt the following command:
> exec serverX.dbX.dbo.procX
> I get this message:
> Server 'serverX' is not configured for RPC.
> This used to work in the beta version of 2005.
>
> Running a select still works:
> select * from serverX.dbX.dbo.tableX
>
> The help file is worthless since it tells me to use a linked server...
> Anyone have an idea what I am missing???

Sponsored Links