Enabling RPC

• mtassin

  SSC-Insane

  Points: 23099

  More actions

  August 20, 2008 at 8:55 am

  #77075

  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?

  ---

  
  --Mark Tassin
  MCITP - SQL Server DBA
  Proud member of the Anti-RBAR alliance.
  For help with Performance click this link[/url]
  For tips on how to post your problems[/url]

• mtassin

  SSC-Insane

  Points: 23099

  More actions

  August 20, 2008 at 9:02 am

  #860682

  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..

  ---

  
  --Mark Tassin
  MCITP - SQL Server DBA
  Proud member of the Anti-RBAR alliance.
  For help with Performance click this link[/url]
  For tips on how to post your problems[/url]