Problem with Linked Server

Dear All,
I have 2 SQL Server computers, let say Server A and B.
I created a linked server from A to B, so I can make query that the data
from Server B, and it's success.
Now, I create a linked server from B to A, but it failed.
Here's the error message:
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'
What's the problem with server B?
Both of the servers are using windows authentification.
Thanks
Agus
Hi
You may want to check out:
http://www.windowsitpro.com/Article/...3670.html?Ad=1
John
"Agus Setiawan" wrote:

> Dear All,
> I have 2 SQL Server computers, let say Server A and B.
> I created a linked server from A to B, so I can make query that the data
> from Server B, and it's success.
> Now, I create a linked server from B to A, but it failed.
> Here's the error message:
> Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'
> What's the problem with server B?
> Both of the servers are using windows authentification.
>
> Thanks
> Agus
>
|||Hello,
Verify also that your account have the Windows rights on those two servers
and that they are on the same domain. The best way is having a service
account.
Hope this will help,
P. Ruello
DBA
"Agus Setiawan" wrote:

> Dear All,
> I have 2 SQL Server computers, let say Server A and B.
> I created a linked server from A to B, so I can make query that the data
> from Server B, and it's success.
> Now, I create a linked server from B to A, but it failed.
> Here's the error message:
> Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'
> What's the problem with server B?
> Both of the servers are using windows authentification.
>
> Thanks
> Agus
>
|||I have similar problem right now with linked server.
I can run distributed query from Server A to B by using my login.
But I can't run distributed query from Server B to A by using my login.
If I run distributed query from Server B to A by using login that is
used by server B, it's success.
Why?
Thanks
Robert Lie
P.Ruello wrote:
> Hello,
> Verify also that your account have the Windows rights on those two servers
> and that they are on the same domain. The best way is having a service
> account.
> Hope this will help,
|||Hi
You may want to check out http://support.microsoft.com/?id=238477
John
"Robert Lie" wrote:

> I have similar problem right now with linked server.
> I can run distributed query from Server A to B by using my login.
> But I can't run distributed query from Server B to A by using my login.
> If I run distributed query from Server B to A by using login that is
> used by server B, it's success.
> Why?
> Thanks
> Robert Lie
>
> P.Ruello wrote:
>