Monday, March 12, 2012

Remote query error

Hello, when I try a remote query in Query Analyzer from
serverA I am getting an error: Server 'serverB' is not
configured for DATA ACCESS.
ServerB is not defined as a Linked Server as it is already
defined as a remote server (it participates in
replication). I can run queries on it directly,
applications can access it, etc. Concurrent access is set
at unlimited.
I am using SQL 7
Any help is greatly appreciated.
RicSee sp_serveroption in BOL.
>--Original Message--
>Hello, when I try a remote query in Query Analyzer from
>serverA I am getting an error: Server 'serverB' is not
>configured for DATA ACCESS.
>ServerB is not defined as a Linked Server as it is
already
>defined as a remote server (it participates in
>replication). I can run queries on it directly,
>applications can access it, etc. Concurrent access is
set
>at unlimited.
>I am using SQL 7
>Any help is greatly appreciated.
>Ric
>.
>|||I put in the the sp_serveroption and gave it data access
but now i get this...Im using a remote server
connection...what am I doing wrong?
Login failed for user '(null)'. Reason: Not associated
with a trusted SQL Server connection.|||Many thanks Chris, that worked perfectly.
Ric
>--Original Message--
>See sp_serveroption in BOL.
>>--Original Message--
>>Hello, when I try a remote query in Query Analyzer from
>>serverA I am getting an error: Server 'serverB' is not
>>configured for DATA ACCESS.
>>ServerB is not defined as a Linked Server as it is
>already
>>defined as a remote server (it participates in
>>replication). I can run queries on it directly,
>>applications can access it, etc. Concurrent access is
>set
>>at unlimited.
>>I am using SQL 7
>>Any help is greatly appreciated.
>>Ric
>>.
>.
>|||I did this and gave it data access but now I get the error
that the login for user null failed...not associated with
a trusted SQL Server connection

No comments:

Post a Comment