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

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

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?
>
|||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 you.
"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...
>
>

Linked Server -> Interbase

Hi!!!
I have a Interbase database and I would like to make a linked server.
I don't have Interbase driver in the Windows 98's ODBC Data Source Administrator
What I need to do?
Thank you.
ByeDownload from web.|||You can get the

Easysoft ODBC for Interbase at

www.easysoft.com

Linked Server & XACT_ABORT

Is there anyway to set XACT_ABORT ON for a linked server? We have a linked
server setup between SQL 2000 and DB2. To use transactions we need to turn
XACT_ABORT on in every single stored procedure. Is there a way to turn it on
at the linked server level?
Thanks.
Paula.. If an application has a local transaction and the option
REMOTE_PROC_TRANSACTIONS is set ON, calling a remote stored procedure
escalates the local transaction to a distributed transaction.
This can be set via sp_configure I beleive... I have never tried this, but
perhaps it is worth a few minutes of your time..
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:A2488655-A223-4C02-AAEF-33AD82485C53@.microsoft.com...
> Is there anyway to set XACT_ABORT ON for a linked server? We have a
linked
> server setup between SQL 2000 and DB2. To use transactions we need to
turn
> XACT_ABORT on in every single stored procedure. Is there a way to turn it
on
> at the linked server level?
> Thanks.
> Paul
>|||Thank you for the reply. Unfortunately that did not work. I ran the
following command to turn that option on:
EXEC sp_configure 'remote proc trans', 1
I ran the following statements:
BEGIN TRAN
UPDATE D SET
D.Location = 999
FROM LS..DB2TDBM.DEPARTMENT D
WHERE D.ADMRDEPT = 'E01'
COMMIT TRAN
And got the following error, which is the same error when the Remote Proc
Trans is truned off:
"Unable to start a nested transaction for OLE DB provider 'IBMDADB2'. A
nested transaction was required because the XACT_ABORT option was set to OFF."
Any ideas?
Thanks.
Paul
"Wayne Snyder" wrote:
>
> a.. If an application has a local transaction and the option
> REMOTE_PROC_TRANSACTIONS is set ON, calling a remote stored procedure
> escalates the local transaction to a distributed transaction.
> This can be set via sp_configure I beleive... I have never tried this, but
> perhaps it is worth a few minutes of your time..
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Paul" <Paul@.discussions.microsoft.com> wrote in message
> news:A2488655-A223-4C02-AAEF-33AD82485C53@.microsoft.com...
> >
> > Is there anyway to set XACT_ABORT ON for a linked server? We have a
> linked
> > server setup between SQL 2000 and DB2. To use transactions we need to
> turn
> > XACT_ABORT on in every single stored procedure. Is there a way to turn it
> on
> > at the linked server level?
> >
> > Thanks.
> >
> > Paul
> >
> >
>
>

Linked Server & XACT_ABORT

Is there anyway to set XACT_ABORT ON for a linked server? We have a linked
server setup between SQL 2000 and DB2. To use transactions we need to turn
XACT_ABORT on in every single stored procedure. Is there a way to turn it o
n
at the linked server level?
Thanks.
Paula.. If an application has a local transaction and the option
REMOTE_PROC_TRANSACTIONS is set ON, calling a remote stored procedure
escalates the local transaction to a distributed transaction.
This can be set via sp_configure I beleive... I have never tried this, but
perhaps it is worth a few minutes of your time..
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:A2488655-A223-4C02-AAEF-33AD82485C53@.microsoft.com...
> Is there anyway to set XACT_ABORT ON for a linked server? We have a
linked
> server setup between SQL 2000 and DB2. To use transactions we need to
turn
> XACT_ABORT on in every single stored procedure. Is there a way to turn it
on
> at the linked server level?
> Thanks.
> Paul
>|||Thank you for the reply. Unfortunately that did not work. I ran the
following command to turn that option on:
EXEC sp_configure 'remote proc trans', 1
I ran the following statements:
BEGIN TRAN
UPDATE D SET
D.Location = 999
FROM LS..DB2TDBM.DEPARTMENT D
WHERE D.ADMRDEPT = 'E01'
COMMIT TRAN
And got the following error, which is the same error when the Remote Proc
Trans is truned off:
"Unable to start a nested transaction for OLE DB provider 'IBMDADB2'. A
nested transaction was required because the XACT_ABORT option was set to OFF
."
Any ideas?
Thanks.
Paul
"Wayne Snyder" wrote:

>
> a.. If an application has a local transaction and the option
> REMOTE_PROC_TRANSACTIONS is set ON, calling a remote stored procedure
> escalates the local transaction to a distributed transaction.
> This can be set via sp_configure I beleive... I have never tried this, but
> perhaps it is worth a few minutes of your time..
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Paul" <Paul@.discussions.microsoft.com> wrote in message
> news:A2488655-A223-4C02-AAEF-33AD82485C53@.microsoft.com...
> linked
> turn
> on
>
>

Linked Server & XACT_ABORT

Is there anyway to set XACT_ABORT ON for a linked server? We have a linked
server setup between SQL 2000 and DB2. To use transactions we need to turn
XACT_ABORT on in every single stored procedure. Is there a way to turn it on
at the linked server level?
Thanks.
Paul
a.. If an application has a local transaction and the option
REMOTE_PROC_TRANSACTIONS is set ON, calling a remote stored procedure
escalates the local transaction to a distributed transaction.
This can be set via sp_configure I beleive... I have never tried this, but
perhaps it is worth a few minutes of your time..
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:A2488655-A223-4C02-AAEF-33AD82485C53@.microsoft.com...
> Is there anyway to set XACT_ABORT ON for a linked server? We have a
linked
> server setup between SQL 2000 and DB2. To use transactions we need to
turn
> XACT_ABORT on in every single stored procedure. Is there a way to turn it
on
> at the linked server level?
> Thanks.
> Paul
>
|||Thank you for the reply. Unfortunately that did not work. I ran the
following command to turn that option on:
EXEC sp_configure 'remote proc trans', 1
I ran the following statements:
BEGIN TRAN
UPDATE D SET
D.Location = 999
FROM LS..DB2TDBM.DEPARTMENT D
WHERE D.ADMRDEPT = 'E01'
COMMIT TRAN
And got the following error, which is the same error when the Remote Proc
Trans is truned off:
"Unable to start a nested transaction for OLE DB provider 'IBMDADB2'. A
nested transaction was required because the XACT_ABORT option was set to OFF."
Any ideas?
Thanks.
Paul
"Wayne Snyder" wrote:

>
> a.. If an application has a local transaction and the option
> REMOTE_PROC_TRANSACTIONS is set ON, calling a remote stored procedure
> escalates the local transaction to a distributed transaction.
> This can be set via sp_configure I beleive... I have never tried this, but
> perhaps it is worth a few minutes of your time..
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Paul" <Paul@.discussions.microsoft.com> wrote in message
> news:A2488655-A223-4C02-AAEF-33AD82485C53@.microsoft.com...
> linked
> turn
> on
>
>