Re: Linked Server to MS Access Database Using Mapped Drive
From: BP Margolin (bpmargo@attglobal.net)
Date: 08/28/02
- Next message: sys: "Re: can't connect to sql server using sa"
- Previous message: Mark Johnson: "Linked Server to MS Access Database Using Mapped Drive"
- In reply to: Mark Johnson: "Linked Server to MS Access Database Using Mapped Drive"
- Next in thread: Mark Johnson: "Re: Linked Server to MS Access Database Using Mapped Drive"
- Reply: Mark Johnson: "Re: Linked Server to MS Access Database Using Mapped Drive"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "BP Margolin" <bpmargo@attglobal.net> Date: Tue, 27 Aug 2002 22:40:53 -0400
Mark,
Security is certainly a good first guess :-)
Check to see if your SQL Server instance is running under the LocalSystem
account. The LocalSystem account has no network permissions. If it is
running under LocalSystem, consider changing the account to a Domain account
with more appropriate permissions.
-------------------------------------------
BP Margolin
Please reply only to the newsgroups.
When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
can be cut and pasted into Query Analyzer is appreciated.
"Mark Johnson" <no-reply@nospam.com> wrote in message
news:#UehirhTCHA.3896@tkmsftngp11...
> Hello:
>
> As you may or may not have seen from my recent postings in this group, I
> have been working on creating a linked server connection to an access
> databas on the same server as the sql server installation, which I have
done
> successfully. however, when I try to change the location of the databse
to
> a mapped drive to another server, I get this 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: 'z:\test\mydb.mdb' is not a valid path.
> Make sure that the path name is spelled correctly and that you are
connected
> to the server on which the file resides.]
> ===============================
>
> I get a similar error if I try to use the UNC pathname for the connection
> (\\myserver\sharename\test\mydb.mdb).
>
> Any ideas on this? I think it has something to do with what user SQL
server
> is running as, and security permissions to that mapped drive are not
> sufficient to connect to it as the user that SQL Server is running as.
Any
> ideas on this?
>
> - Mark
>
>
- Next message: sys: "Re: can't connect to sql server using sa"
- Previous message: Mark Johnson: "Linked Server to MS Access Database Using Mapped Drive"
- In reply to: Mark Johnson: "Linked Server to MS Access Database Using Mapped Drive"
- Next in thread: Mark Johnson: "Re: Linked Server to MS Access Database Using Mapped Drive"
- Reply: Mark Johnson: "Re: Linked Server to MS Access Database Using Mapped Drive"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
