We want to create a linked server from a SQL 2000 box to a SQL 2005 box.

We will have a database on the SQL 2000 box use "views" to a database on the
SQL 2005 box.

The user will connect (with an ACCESS front-end) to the SQL 2000 database.
They use SQL authentication at this time to get to that database.

The SQL 2005 box will only have WINDOWS AUTHENTICATION. Every user already
has WINDOWS GROUP rights to the DATABASE on the SQL 2005 box.

Will this work? Any suggestions on setup?

Right now we tried creating a linked server on SQL 2000 to SQL 2005 and
using this query:

SELECT * FROM FPSSQL05.STUFILES.DBO.STUFILES_T

and are getting this error:

Msg 18456, Level 14, State 1, Line 1
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.