server using Windows authentication

Hi,
I´m having problems with using Windows authentication with a linked server.
When connecting to the linked server I receive the error:
Error 18452: Login failed for user 'domain/name of a local windows account
on the linked server'. Reason: Not associated with a trusted SQL Server
connection.
When I change to mixed mode on the linked server everything works fine, but
this is not an option that I want to use. How do I make this work with
Windows authentication?
Best regards,
WencheThis is a security delegation issue. Please take a look at this article for
more info.
http://msdn.microsoft.com/library/en-us/adminsql/ad_security_2gmm.asp?frame=true
-oj
Rac v2.2 & QALite!
http://www.rac4sql.net
"Wenche" <weels@.dne.com> wrote in message
news:uiBMiHVkDHA.1708@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I´m having problems with using Windows authentication with a linked
server.
> When connecting to the linked server I receive the error:
> Error 18452: Login failed for user 'domain/name of a local windows account
> on the linked server'. Reason: Not associated with a trusted SQL Server
> connection.
> When I change to mixed mode on the linked server everything works fine,
but
> this is not an option that I want to use. How do I make this work with
> Windows authentication?
> Best regards,
> Wenche
>