Re: Linked servers

From: Barry Schwartz (barry@idealsoftware.co.uk)
Date: 10/08/02 

From: "Barry Schwartz" <barry@idealsoftware.co.uk>
Date: Tue, 8 Oct 2002 02:51:35 -0700

Hi George,

I've checked the configuration which is as follows:

On Server B (NT4/SQL Server 7 using Windows NT
Authentication) I set up a linked server using, on
the 'General' tab, Server A's (W2K/SQL Server 2000 using
Mixed Mode) name, SQL Server and the default selection of
server options. On the 'Security' tab, I used 'They will
be mapped to' and entered a remote user and password.

On Server A I created a login using SQL Server
authentication and the name and password used above, and I
gave it access permissions to the relevant database.
Within the database, I then gave the user the relevant
object permissions.

This all works fine.

The setup going the other way, i.e. from Server A to
Server B is as follows:

On the 'General' tab, I used server B's name and again
selected SQL Server. On the 'Security' tab I used, 'Be
made using this security context' and entered a remote
login and password. I left the 'Server Options' tab on
the defaults.

On Server B, I added a NT login to the domain run by
Server C (i.e. that to which both A and B are a member)
and created a login for it within SQL Server EM, giving it
access permissions to the relevant database. Within the
database I then gave the user permissions to the relevant
objects.

However, I still get the same error message:

"Login failed for user 'tomdickharry'. Reason: Not
associated with a trusted SQL Server connection."

Doh!

Regards,

Barry.