RE: Cannot create linked server from SQL 2005 to SQL 2000

"Erland Sommarskog" wrote:

Rather than using the GUI and trying to guess what things mean, it may be
better to use sp_addlinkedserver and sp_addlinkedsrvlogin directly.

I am not going to say that I know from the top of my head how you would
set up the logins, but it would take some trial and errors. And study of
Books Online of course.

Another advantage is that you get a script that you can save and reuse
in a similar situation later.


--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

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


Erland,

Good advice on using the stored procedures - they were easier to use, and
come with much better documentation in BOL. Instead of using SSMS, I was able
to use sys.servers, sys.linked_logins, sys.remote_logins and sys.sql_logins
to view the current settings. (I'm sure there is more to it than that, of
course.)

Btw, it's a small world - I think I was a student at LTH at the same time
you were. Thank you for your SQL articles on sommarskog.se, they have helped
me out on many occasions!

Lena
.

Relevant Pages

  • Re: IDENT_CURRENT and empty table
    ... >> And there is no definition what the result will be after fixing the bug. ... Books Online for 2005 is wrong and will be updated. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (comp.databases.ms-sqlserver)
  • Re: sorting twice?!
    ... So I run a query to select the top 20 when ordered by datemodified ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: Rolling up spans without breaks between them
    ... CREATE TABLE periods (start datetime NOT NULL, ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: Error: 16954, Severity: 10, State: 1 and Timeout problem
    ... On this DB are runing lot of threads from different applications. ... Probably, other aplication are locking resources, so the first one need ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (comp.databases.ms-sqlserver)
  • Re: Systematically determine DRI problem(s)
    ... "the original designer probably meant to link them via customer_ID" ... Erland Sommarskog wrote: ... >> of effort to find data problem for the given situation, ... > Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (comp.databases.ms-sqlserver)