Linked server (Access file)

I have created a linked server with an Access file. I can run queires agains
t
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?
>|||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...
>
>|||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...[vbcol=seagreen]
> 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:
>|||SQL is running under Local System. The sql server account is not a member of
sysadmin.
"Uri Dimant" wrote:

> 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...
>
>|||I put the sql server account in the sysadmin role and it now works. Thank yo
u.
"Uri Dimant" wrote:

> 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...
>
>