Problem fixed. There was something wrong with the one of the databases in the instance.

It looks like someone in the past removed the 'guest' user incorrectly. I applied the recommended...

Windows NT - 5.0 (2195)

SQL Server 8.00.760 (SP3)

Enterprise Manager 8.00.194

I tried it on another instance on a different Windows server, and it works fine! The second instance is the same...

Thanks for your reply.

The user has registered SQL Server with the correct credentials.

I check their connection by viewing 'process info'. I also replicated the problem by setting up a test...

It was something to do with the collation.

Selecting the collation box on the linked database definition fixed the problem.

I will see if I can get the SQL from the user.

...