Remote Server Vrs Linked Server

Hello,
I am a little confused on the difference. Say if I had two SQL Server
installations on a different Server, should a connect via a Linked or Remote
server link ?
If I had SQL Server and Excel, linked or remote ?
Could someone please point me to a resource to tell me the difference ?
thanks
PPatricia,
Remote servers are provided for backwards compatibility and should not be
used. Linked servers provide more options for configuring secure access, and
will work against any OLE-DB source including Oracle, Access, Spreadsheets
etc .
You can find information on linked servers in Books Online.
Some additional information for SQL - SQL connections ;
Explicit mappings should be defined for the accounts that require access to
the remote server. For logins not explicitly mapped, connections should not
be allowed.
When creating an explicit mapping between a local user and a remote user,
the Impersonate mode should be used to pass through the identity of the
source user to the linked server. In order for this to work, both the
account and the SQL Server need to be trusted for delegation, and both the
source and destination servers need to be running Windows 2000 or later with
Kerberos security enabled.
If these delegation conditions are not met, then an explicit username and
password can be used which needs to be setup as a SQL Server login on the
remote server. Network transmission should be secured with SSL between the 2
servers, and strong passwords in place.
For Non SQL Server data sources, the DisallowAdHocAccess option should be
used with care, and only on trusted sources.
Regards,
Rod Colledge.
"Patricia" <Patricia@.discussions.microsoft.com> wrote in message
news:00F9121D-3C0C-477A-A8BA-8687507E789B@.microsoft.com...
> Hello,
> I am a little confused on the difference. Say if I had two SQL Server
> installations on a different Server, should a connect via a Linked or
> Remote
> server link ?
> If I had SQL Server and Excel, linked or remote ?
> Could someone please point me to a resource to tell me the difference ?
> thanks
> P|||Thanks Rod
"Rod Colledge" wrote:
> Patricia,
> Remote servers are provided for backwards compatibility and should not be
> used. Linked servers provide more options for configuring secure access, and
> will work against any OLE-DB source including Oracle, Access, Spreadsheets
> etc .
> You can find information on linked servers in Books Online.
> Some additional information for SQL - SQL connections ;
> Explicit mappings should be defined for the accounts that require access to
> the remote server. For logins not explicitly mapped, connections should not
> be allowed.
>
> When creating an explicit mapping between a local user and a remote user,
> the Impersonate mode should be used to pass through the identity of the
> source user to the linked server. In order for this to work, both the
> account and the SQL Server need to be trusted for delegation, and both the
> source and destination servers need to be running Windows 2000 or later with
> Kerberos security enabled.
>
> If these delegation conditions are not met, then an explicit username and
> password can be used which needs to be setup as a SQL Server login on the
> remote server. Network transmission should be secured with SSL between the 2
> servers, and strong passwords in place.
>
> For Non SQL Server data sources, the DisallowAdHocAccess option should be
> used with care, and only on trusted sources.
>
> Regards,
> Rod Colledge.
>
> "Patricia" <Patricia@.discussions.microsoft.com> wrote in message
> news:00F9121D-3C0C-477A-A8BA-8687507E789B@.microsoft.com...
> > Hello,
> >
> > I am a little confused on the difference. Say if I had two SQL Server
> > installations on a different Server, should a connect via a Linked or
> > Remote
> > server link ?
> >
> > If I had SQL Server and Excel, linked or remote ?
> >
> > Could someone please point me to a resource to tell me the difference ?
> >
> > thanks
> > P
>
>