We have an old SQL Server 2000 database that has to be kept because it is needed on our manufacturing machines. It also maintains our employee records, since they are needed on these machines for employee logins.

We also have a newer SQL Server 10 database (I think this is 2008, but I'm not sure) that we are using for newer development.

I have recently learned (i.e. today) that I can link the two servers. This would allow me to access the employee tables in the newer server.

Following the SF post SQL Server to SQL Server Linked Server Setup, I tried adding the link.

In our SQL Server 2000 machine, I got this error:

Similarly, on our SQL Server 10 machine, I got this error:

The messages, though worded different, probably say the same thing: I need to authenticate, somehow.

We have an Active Directory, but it is on yet another server.

What, exactly, should be done here?

A guy >>HERE<< said to check the Security settings, but did not say what else to do. Both servers are set to SQL Server and Windows Authentication mode.

Now what?