Login Failure with Linked Server

Hi,
I have both NT authentication on the two servers, and I'm getting the following error when I try to execute the statement:

select * from Main1a.GondorMain.dbo.bds

Error Message:
Server: Msg 18452, Level 14, State 1, Line 1
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.

Any system SPROC that I could check to verify what's causing the error?

Any help is appreciated!
-Lawrence

[630 byte] By [LawrenceSQL] at [2007-12-17]
# 1
Just to clarify, I would like all my database connection to use windows
authentication, so I simply ran --> sp_addlinkedserver 'Main1a' and when I
ran the simple select statment (below), I am getting "Login Failed for user
'(null)'".

select * from Main1a.GondorMain.dbo.bds

I also added "data access" to sp_serveroption, but that DID NOT resolve it.

-Lawrence

SQLChamp at 2007-10-6 > top of Msdn Tech,SQL Server,Transact-SQL...

SQL Server

Site Classified