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 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?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
> > 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?
>
>sql

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...
>
>

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 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?
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...
>
>