Posted by Erland Sommarskog on 09/12/07 07:43

gdev (paul.afamdi.okeke@gmail.com) writes:
> I'm Trying to create a linked server from an SQL Server to another SQL
> Server on another machine.
>
> Can anyone suggest some good reference material or tutorials?? So far
> I'm only finding examples for a linked server to an ACCESS database.

There are plenty of examples in the topic for sp_addlinkedserver.

In many cases, it is as simple as:

exec sp_addlinkedserver THATSERVEROVERHERE
exec sp_serverioption THATSERVEROVERTHERE, 'data access', true

Authentication does not always work though, and in this case
sp_addlinkedsrvlogin comes to the rescue.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: One bound form does NOT save record - please help!
• Prev in forum: Trying to create a linked server from an SQL Server to another SQL Server on another machine.
• Thread view: Re: Trying to create a linked server from an SQL Server to another SQL Server on another machine.

[Reply to this message]