Hi all,

Stupid question:

I want to select data from another SQL Server (for now, I'll be happy to do this through Query Analyzer), so I have something like:

select * from [server].[database].[dbo].[table]

Everytime, I get an 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.

However, when I manually connect to the other server using Windows authentication (for the same user), and I run:

select * from [database].[dbo].[table]

it works.

I saw similar posts on here before, but nothing I tried seemed to fix my problem.

Any idea what might be wrong?

Thanks,
Calli.

Hi,

This link may help u.

http://geekswithblogs.net/ranganh/ar.../25/40489.aspx

koushikroy