• Are you calling the SP from ASP or anything else?

    Have you grant 'NT AUTHORITY\ANONYMOUS LOGON' access SQL Server with proper permissions to tables in instance PROD1?