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

