Linked server (Access file)

I have created a linked server with an Access file. I can run queires against
the linked server if I log in to Management Studio using the domain admin
account. I can't run queries against the linked server if I am logged in
using a sql account. I get
The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server
"LinkedServerl" reported an error. Authentication failed. in my .aspx page.
SQL is on one server and the Access database is on another. I checked the
permissions on the folder where the Access database and "Everyone" has full
control. What else should I be checking to make this work?Curtis
Log in as SQL account on the server and try to copy/create/wrtite in the
folder access file located
"Curtis" <Curtis@.discussions.microsoft.com> wrote in message
news:CCEC2A3C-7F3D-4FC4-BCFA-4F365944426D@.microsoft.com...
>I have created a linked server with an Access file. I can run queires
>against
> the linked server if I log in to Management Studio using the domain admin
> account. I can't run queries against the linked server if I am logged in
> using a sql account. I get
> The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server
> "LinkedServerl" reported an error. Authentication failed. in my .aspx
> page.
> SQL is on one server and the Access database is on another. I checked the
> permissions on the folder where the Access database and "Everyone" has
> full
> control. What else should I be checking to make this work?
>|||Curtis
That what I meant , a sql server account is a member of sysadmin server
role?
What is an account MSSQLSERVER service run under? Is it Local system ?
"Curtis" <Curtis@.discussions.microsoft.com> wrote in message
news:E41B3A59-2C83-445C-814A-28AD1CF2568E@.microsoft.com...
> How can I log in using a sql account on a server? Since they have it set
> up
> so everyone has full control, then it shouldn't matter who is logged into
> sql, right?
> "Uri Dimant" wrote:
>> Curtis
>> Log in as SQL account on the server and try to copy/create/wrtite in the
>> folder access file located
>>
>>
>> "Curtis" <Curtis@.discussions.microsoft.com> wrote in message
>> news:CCEC2A3C-7F3D-4FC4-BCFA-4F365944426D@.microsoft.com...
>> >I have created a linked server with an Access file. I can run queires
>> >against
>> > the linked server if I log in to Management Studio using the domain
>> > admin
>> > account. I can't run queries against the linked server if I am logged
>> > in
>> > using a sql account. I get
>> > The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server
>> > "LinkedServerl" reported an error. Authentication failed. in my .aspx
>> > page.
>> >
>> > SQL is on one server and the Access database is on another. I checked
>> > the
>> > permissions on the folder where the Access database and "Everyone" has
>> > full
>> > control. What else should I be checking to make this work?
>> >
>>