Broken Linked Server

Been running SQL 7.0 sp4 for 1 1/2 years on two NT4.0 sp6a
servers on the same subnet with no problems. ServerA is
linked to ServerB, and ServerB is linked to ServerA.
I haven't loaded any new software. This past Monday, all
the jobs on ServerA that use data from ServerB failed.
All the jobs on ServerB that use data on ServerA failed.
I have not been able to figure out what caused the
problem, nor have I been able to correct the problem. I
deleted the link on each server, and tried recreating the
link but failed with the errorlog showing "Login failed
for user "ServerA(B)\Administrator". Same error on both
machines. Yet, both servers are able to successfully
register with each other through EM. The audit log shows
the message "Login succeeded for user 'ServerA(B)
\Administrator'.connection:Trusted." So, I would assume,
that they can communicate with each other.
I even deleted all my network services/protocols then
reinstalled them with no help.
Any ideas?
Did the passwords change on the Administrator account?
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
|||Nope. Nobody else admins the account. I thought the same thing, and
just in
case recent them. It didn't help. What I don't get is the server,
through EM,
can successfully register both servers (which uses the account I logged
in with),
but can't link the servers (which I map to the very same account).
Kevin McDonnell [MSFT] wrote:

>Did the passwords change on the Administrator account?
>Thanks,
>Kevin McDonnell
>Microsoft Corporation
>This posting is provided AS IS with no warranties, and confers no rights.
>
>
>