Executing Procedures through LInked Server

Discussion:

(too old to reply)

Rajesh Padmanabhan

2005-09-29 18:26:05 UTC

I'm trying to execute a procedure through linked server using 4 part names.

The Linked server is configured for PRC and RPCout .

Still I get this message... What Am I Missing...

Could not execute procedure on remote server because SQL Server is not
configured for remote access. Ask your system administrator to reconfigure
SQL Server to allow remote access.

Sue Hoegemeier

2005-09-29 23:40:26 UTC

Permalink

Configuring a server for remote access and RPC are two
different things. You can configure a server to allow remote
access with sp_configure -
EXEC sp_configure 'remote access', 1
RECONFIGURE

-Sue

On Thu, 29 Sep 2005 11:26:05 -0700, Rajesh Padmanabhan

Post by Rajesh Padmanabhan
I'm trying to execute a procedure through linked server using 4 part names.
The Linked server is configured for PRC and RPCout .
Still I get this message... What Am I Missing...
Could not execute procedure on remote server because SQL Server is not
configured for remote access. Ask your system administrator to reconfigure
SQL Server to allow remote access.

Rajesh Padmanabhan

2005-10-03 20:46:09 UTC

Permalink

I have already configured the other server for remote access and reconfigured
with override option.
Still I get the message
Could not execute procedure on remote server because SQL Server is not
configured for remote access. Ask your system administrator to reconfigure
SQL Server to allow remote access.

All I want to do is
Execute a Proc -P Sitting on Machine A from Machine B.

Post by Sue Hoegemeier
Configuring a server for remote access and RPC are two
different things. You can configure a server to allow remote
access with sp_configure -
EXEC sp_configure 'remote access', 1
RECONFIGURE
-Sue
On Thu, 29 Sep 2005 11:26:05 -0700, Rajesh Padmanabhan

Sue Hoegemeier

2005-10-04 00:29:54 UTC

Permalink

Also try executing:
sp_serveroption 'YourLinkedServer', 'data access', 'TRUE'

-Sue

On Mon, 3 Oct 2005 13:46:09 -0700, Rajesh Padmanabhan

Post by Rajesh Padmanabhan
I have already configured the other server for remote access and reconfigured
with override option.
Still I get the message
Could not execute procedure on remote server because SQL Server is not
configured for remote access. Ask your system administrator to reconfigure
SQL Server to allow remote access.
All I want to do is
Execute a Proc -P Sitting on Machine A from Machine B.

Rajesh Padmanabhan

2005-10-04 17:45:08 UTC

Permalink

Does not work .

Post by Sue Hoegemeier
sp_serveroption 'YourLinkedServer', 'data access', 'TRUE'
-Sue
On Mon, 3 Oct 2005 13:46:09 -0700, Rajesh Padmanabhan

Sue Hoegemeier

2005-10-05 01:54:03 UTC

Permalink

Sorry, don't know what else to tell you - your missing one
of those settings on one of the server though. That's how
you get the error.
Double check all settings you thought were enabled - RPC,
remote access, data access.

-Sue

On Tue, 4 Oct 2005 10:45:08 -0700, Rajesh Padmanabhan

Post by Rajesh Padmanabhan
Does not work .

Post by Sue Hoegemeier
sp_serveroption 'YourLinkedServer', 'data access', 'TRUE'
-Sue
On Mon, 3 Oct 2005 13:46:09 -0700, Rajesh Padmanabhan