How to perform the dreaded double hop with linked servers?
Security Account Delegation

And for SQL Server 2000 but still valid too

Basically


Configure the server in AD
Set up the SPN
Use sp_addlinkedsrvlogin so useself = true