Login failed for user(null)

[SnehaAgrawal]

Hi,
See if someone could shed some light on the following

I am getting an error

Login failed for user(null)
Reason:Not associated with a trusted SQL Server Connection.

I am using SQL Server 2000

I have 2 servers

ServerA(Databas eA)
ServerB(Databas eB)

I try to do the following

ServerA------>DatabaseA----->Storedproc inserting a record in Database B of ServerB

Please help.

[ck9663]

It means you're trying to connect to your ServerB using your existing credential that you use in Server A. Try to setup your Linked server using a valid credential.

Good Luck!!!

~~ CK