I'm working on server AAA in Query Analyzer and trying to query data from server BBB by qualifying its server name, database etc.. just like this one:

select field1 from BBB.DbName.dbo.Tablename

and i got this error :(

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

Note that I already opened the property window of the database in the Enterprise Manager and under Security tab change the authentication mode to SQL server and windows.

Any help guys?
Many thanks in advance.

I would just add, the same error will occur when you go to enterprise manager, drill down server name(AAA), security, linked servers and assuming that you already add a linked (to BBB which I already had) ...BBB and tables.
refresh it on the Tables and the same error occurs.


again, Thanx in advance.