LInked Servers Error 17 When Trying to View Tables in EM

[jwells1145]

Upgraded 2000 server to 2k3 R2 server (Server 1). Updated SQL 2000 to SP4. Linked server connection from Server 2 (2K3 R2 Server, SQL 2000 SP4) to Server 1 worked.

Updated Server 1 to SP2 and applied security patches. Linked server connection from Server 2 to Server 1 failed with Error 17. Deleted Linked Server and created new using SQL Server Type with username and password that I know works. Still failed.

Created Linked Server form Server 2 to Server 3 (2K3 SP2, SQL 2000 SP4). Works Fine.

Created Linked Server from Server 3 to Server 1 with same username and password used for Server 2 to Server 1. Works Fine.

Have tried every different connection type that I have seen, read or heard about.

Don't know what else to try. HELP!

Thanks,

SysAdminCPC

 

[jwells1145]

New twist. I can connect to the linked server using computer management on the local server. Go to EM and refresh. I see the linked server but still cannot connect, gives me Error 17.

 

[jwells1145]

Another update. Got it to work some of the time. It is up and down. I know it has to do something with the security settings, just don't know what.

Still getting the same Error 17 when the connection is not working.