August 20, 2008 at 8:55 am
So I've never had to enable RPC before... but something I'm working on needs to run a sproc on the remote server which will load a remote table with data, and then pull that data off of the server. Instead of building the query from the source server and tossing it into a temp table on the destination server (query time difference is about 10 minutes vs 90)...
When I run the sproc I get
Msg 7411, Level 16, State 1, Line 1
Server 'XXXXX' is not configured for RPC.
Ok so I fire
sp_serveroption 'XXXXXX','RPC','true'
sp_serveroption 'XXXXXX','RPC OUT','true'
and then run sp_helpserver to confirm that rpc and rpc out are in the status list
I then try to remotely execute the RPC'd sproc again and get the same error.
What am I missing here?
August 20, 2008 at 9:02 am
aaah nm figured it out... though the error is not intuitive...
I needed to run the sp_serveroption command for the source server on the destination server..
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply