Linked vs. Remote Servers

My question is two fold. One, whats the difference between a linked SQL
server vs. a Remote SQL server? Two, From server A I set up a Linked server
to B, and on server A Query analyzer I run the following
select * from [A].[dbname].dbo.[tablename], I run this and get r
esults. If
I drop the Linked server and make it a remote server then run the same thing
i get and error ' Server 'B' is not configured for Data Access'. But server
A can Replicate to server B. What's missing?Jay
> i get and error ' Server 'B' is not configured for Data Access'. But
> server
> A can Replicate to server B. What's missing?
exec sp_serveroption 'Server B' ,'data access','true'
My question is two fold. One, whats the difference between a linked SQL
> server vs. a Remote SQL server?
Linked Server might be Remote , Remote might be linked
"Jay Bukstein" <JayBukstein@.discussions.microsoft.com> wrote in message
news:8AE552DE-F306-42A4-95E3-5DB34200E2ED@.microsoft.com...
> My question is two fold. One, whats the difference between a linked SQL
> server vs. a Remote SQL server? Two, From server A I set up a Linked
> server
> to B, and on server A Query analyzer I run the following
> select * from [A].[dbname].dbo.[tablename], I run this and get
results.
> If
> I drop the Linked server and make it a remote server then run the same
> thing
> i get and error ' Server 'B' is not configured for Data Access'. But
> server
> A can Replicate to server B. What's missing?|||Thanks.
"Uri Dimant" wrote:

> Jay
> exec sp_serveroption 'Server B' ,'data access','true'
>
> My question is two fold. One, whats the difference between a linked SQL
> Linked Server might be Remote , Remote might be linked
>
>
> "Jay Bukstein" <JayBukstein@.discussions.microsoft.com> wrote in message
> news:8AE552DE-F306-42A4-95E3-5DB34200E2ED@.microsoft.com...
>
>