We are linking a SQL2K server to an Access DB to source data from a third party application. We have set this up no problem on a normal SQL2K server - works like a treat.
However, when we attempted to set this up on a SQL 2K Cluster (our Production Environment) any attempt to connect to the AccessDB fails with what appears to be a permissions error (unfortunately I don't have the error on me as I'm currently offsite).
Does anyone know of any special problems with Linked Servers under SQL Clusters?
Cheers, Mark B
29th November, 2002 - I recently updated the question with the latest information. Any ideas folks?