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
[quoted text, click to view] <RajeshPadmanabhan@discussions.microsoft.com> wrote:
>Does not work .
>
>"Sue Hoegemeier" wrote:
>
>> Also try executing:
>> sp_serveroption 'YourLinkedServer', 'data access', 'TRUE'
>>
>> -Sue
>>
>> On Mon, 3 Oct 2005 13:46:09 -0700, Rajesh Padmanabhan
>> <RajeshPadmanabhan@discussions.microsoft.com> 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@discussions.microsoft.com> 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.
>> >>
>> >>
>>
>>
