<anonymous@discussions.microsoft.com> wrote:

>Well, then everyone who used the linked server will be
>using the new account created. I want people to only use
>what thier domain account has permissions to do.
>Any way to do this?
>>-----Original Message-----
>>You'll need to create a domain account that has login
>>permissions to SQL Server "A" and the appropriate
>database
>>permissions as well. Use this account for the user login
>>credentials when you create the link.
>>
>>Steve
>>>-----Original Message-----
>>>I'm trying to link to a SQL Server 2000 server (A) that
>>>has Windows only authentication from another SQL Server
>>>2000 (B). I am a System Administrator on both boxes and
>>>we use Active Directory.
>>>When I try to link to A from B, I get an error:
>>>Login failed for user '\null'. Reason: Not associated
>>>with a trusted SQL Server connection.
>>>Server A: Windows 5.2 (from SQL Scan) SQL 2000 SP3
>>>Server B: Windows 5.2 (from SQL Scan) SQL 2000 SP3
>>>Thanks for your help,
>>>Linda
>>>Premier Lease and Loan Services
>>>.
>>>
>>.
>>