It's not quite clear what you mean, or what you did for access.

What did you do to grant access.

When you say he gets an error, do you mean he connects to a SQL 2000 instance from SQL 2005's SSMS client?