Linkedservers using windows authentication

I have two database servers with two different databases. I have the same
windows login set up on both database servers with read access to the two
different databases. I have linkedserver between the two database server.
When I query using a SQL login I get a result set. When I use the windows
login, I get an error - all else is equal.
Please help to resolve.
Hi
Next time, please post your error message too.
Look at
http://msdn.microsoft.com/library/de...urity_2gmm.asp
about what you need to setup for Impersonation.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"spoons" <spoons@.discussions.microsoft.com> wrote in message
news:38BF845C-A1E8-4264-8479-CE3C6DE2776B@.microsoft.com...
> I have two database servers with two different databases. I have the same
> windows login set up on both database servers with read access to the two
> different databases. I have linkedserver between the two database server.
> When I query using a SQL login I get a result set. When I use the windows
> login, I get an error - all else is equal.
> Please help to resolve.