Re: Executing Procedures through LInked Server
- From: Sue Hoegemeier <Sue_H@xxxxxxxxxxxxx>
- Date: Thu, 29 Sep 2005 18:40:26 -0500
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
<RajeshPadmanabhan@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
>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.
.
- Prev by Date: SQL Server does not exist or access denied.
- Next by Date: Re: SQL Server does not exist or access denied.
- Previous by thread: SQL Server does not exist or access denied.
- Next by thread: Re: SQL Server doesn't respond to broadcast request
- Index(es):
Relevant Pages
|
Loading
