Linked Server / "nt authority" error

The company just got a new SQL Server. *finally*, we now have a dev server
and a production server. But apparently, this huge multinational
corporation has no one that knows how to set one up.
We're trying to set each of them up with a link to the other via
"sp_AddLinkedServer"
Running the stored procedure to configure the link worked, and now, when
using EM to connect to HorSql02, we can see the link for HorSql01, but when
clicking on "tables" or "views" under the link in EM, everyone is getting
the same message:
Error 18456: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'
I can't understand why this is happening, since we all connect using Windows
Authentication, we all have (at least in the dev group) dbo permissions on
HorSql01, but this error appears to everyone that attempts to connect to
HorSql01 through the link inside HorSql02.
Peace & happy computing,
Mike Labosh, MCSD
"Escriba coda ergo sum." -- vbSenseiMike,
You have to map logins between both servers. See sp_addlinkedsrvlogin and
"Security Account Delegation" in BOL.
AMB
"Mike Labosh" wrote:

> The company just got a new SQL Server. *finally*, we now have a dev serve
r
> and a production server. But apparently, this huge multinational
> corporation has no one that knows how to set one up.
> We're trying to set each of them up with a link to the other via
> "sp_AddLinkedServer"
> Running the stored procedure to configure the link worked, and now, when
> using EM to connect to HorSql02, we can see the link for HorSql01, but whe
n
> clicking on "tables" or "views" under the link in EM, everyone is getting
> the same message:
> Error 18456: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'
> I can't understand why this is happening, since we all connect using Windo
ws
> Authentication, we all have (at least in the dev group) dbo permissions on
> HorSql01, but this error appears to everyone that attempts to connect to
> HorSql01 through the link inside HorSql02.
> --
> Peace & happy computing,
> Mike Labosh, MCSD
> "Escriba coda ergo sum." -- vbSensei
>
>