Re: Executing Procedures through LInked Server
- From: Sue Hoegemeier <Sue_H@xxxxxxxxxxxxx>
- Date: Mon, 03 Oct 2005 18:29:54 -0600
Also try executing:
sp_serveroption 'YourLinkedServer', 'data access', 'TRUE'
-Sue
On Mon, 3 Oct 2005 13:46:09 -0700, Rajesh Padmanabhan
<RajeshPadmanabhan@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
>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.
>
>
>"Sue Hoegemeier" wrote:
>
>> 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: Re: SQL Server 2005 and Access 2003
- Next by Date: Can connect to sqlexpress via asp.net but not via asp
- Previous by thread: Re: SQL Server 2005 and Access 2003
- Next by thread: Re: Executing Procedures through LInked Server
- Index(es):
Relevant Pages
|
