Clustering and Linked Server

Hi,
We have a SQL 2000 cluster server. We need to run a query
on an access database. We have set up a linked server,
however we always get the error;
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an
error.
[OLE/DB provider returned message: Cannot open
database ''. It may not be a database that your
application recognizes, or the file may be corrupt.]
This setup always worked before we changed to clustered
servers. Does anyone know a way around this?
Thanks.
Does the SQL service account have access to the underlying file? Is the
file accessable from a UNC share that appears the same to all host nodes?
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"PC" <anonymous@.discussions.microsoft.com> wrote in message
news:1febf01c4590e$36289520$a601280a@.phx.gbl...
> Hi,
> We have a SQL 2000 cluster server. We need to run a query
> on an access database. We have set up a linked server,
> however we always get the error;
> Server: Msg 7399, Level 16, State 1, Line 1
> OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an
> error.
> [OLE/DB provider returned message: Cannot open
> database ''. It may not be a database that your
> application recognizes, or the file may be corrupt.]
>
> This setup always worked before we changed to clustered
> servers. Does anyone know a way around this?
> Thanks.
|||I have checked the permissions on the c:\winnt and
c:\winnt\temp folders and the SQL Server service account
has Full Control over these.

>--Original Message--
>Does the SQL service account have access to the
underlying file? Is the
>file accessable from a UNC share that appears the same to
all host nodes?
>--
>Geoff N. Hiten
>Microsoft SQL Server MVP
>Senior Database Administrator
>Careerbuilder.com
>I support the Professional Association for SQL Server
>www.sqlpass.org
>"PC" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:1febf01c4590e$36289520$a601280a@.phx.gbl...
query
>
>.
>
|||Storing user files in the winnt folder or subfolders is a bad idea all by
itself.
When you have a clustered instance, you need to make sure that the file is
accessable to the SQL instance no matter which node is currently hosting it.
If the file is on Host1 and the SQL instance is running on Host2, the SQL
instance will see only the disks on Host2.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"PC" <anonymous@.discussions.microsoft.com> wrote in message
news:206cd01c45936$9f74e240$a101280a@.phx.gbl...[vbcol=seagreen]
> I have checked the permissions on the c:\winnt and
> c:\winnt\temp folders and the SQL Server service account
> has Full Control over these.
> underlying file? Is the
> all host nodes?
> message
> query