Re: dts and access db

From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 11/09/04 

Date: Tue, 09 Nov 2004 08:51:57 -0700

If it doesn't fail when run manually but fails when
scheduled as a job then something in the article is likely
related to your issue. The service account for SQL Server
needs to have the correct permissions and needs to be a
domain account. You can log on to SQL Server under this
account and run the package manually to see if you get any
errors.
You may also want to log on as under the service account and
execute xp_cmdshell to do a dir command on \\server\Data\
and see if you can get the directory listing or if you get
any errors.
You need to also make sure the database is not being opened
exclusively by another user or program. However, being that
this never happens when the package is run manually then
again, it's probably related to permissions or account
settings as described in the article.

-Sue

On Tue, 9 Nov 2004 09:33:17 -0500, "JFB" <jfb@newSQL.com>
wrote:

>Tks for u reply...
>1. The server have full control of the data folder.
>2. Nothing in the article affects my problem.
>3. The pkg doesn't fail manually, no errors.
>4. Here is the error detail when it runs as a job schedule:
>Executed as user: SQLSERVER\SYSTEM. ...cuting... DTSRun OnStart:
>DTSStep_DTSExecuteSQLTask_1 DTSRun OnError: DTSStep_DTSExecuteSQLTask_1,
>Error = -2147467259 (80004005) Error string: The Microsoft Jet
>database engine cannot open the file '\\server\Data\Data.mdb'. It is
>already opened exclusively by another user, or you need permission to view
>its data. Error source: Microsoft JET Database Engine Help file:
>Help context: 5003051 Error Detail Records: Error: -2147467259
>(80004005); Provider Error: -534709256 (E020FBF8) Error string: The
>Microsoft Jet database engine cannot open the file '\\server\Data\Data.mdb'.
>It is already opened exclusively by another user, or you need permission to
>view its data. Error source: Microsoft JET Database Engine Help
>file: Help context: 5003051 DTSRun OnFinish:
>DTSStep_DTSExecuteSQLTask_1 DTSRun: Package execution complete. Process
>Exit Code 1. The step failed.
>
>JFB
>
>"Sue Hoegemeier" <Sue_H@nomail.please> wrote in message
>news:d910p053vuphhmhnvdlkajsjee2lavpb2s@4ax.com...
>> It depends on what the specific permissions error is. If you
>> are positive it's nothing in the article then it could be
>> just the nature of some access issues. Does the service
>> account for SQL Server have full control on the folder where
>> the ldb file is created? Does it always fail? Is the Access
>> database opened by another user or users when you get the
>> errors?
>> Posting the exact error message when you run it manually
>> would help. If it's Access specific related to some of the
>> above then you should hit similar error messages when run
>> manually. It won't matter whether it's scheduled or not.
>>
>> -Sue
>>
>> On Mon, 8 Nov 2004 18:06:11 -0500, "JFB" <jfb@newSQL.com>
>> wrote:
>>
>>>I'm using sa account with secure pwd... other dts are in the same way
>>>without any problem.
>>>I already read this article.
>>>Anything else to think about ???
>>>Tks
>>>JFB
>>>
>>>"Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message
>>>news:eygQdWcxEHA.412@TK2MSFTNGP14.phx.gbl...
>>>> Under what account is the job scheduled?
>>>>
>>>> Have a look here
>>>>
>>>> http://support.microsoft.com/?kbid=269074
>>>>
>>>> --
>>>>
>>>> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
>>>> www.SQLDTS.com - The site for all your DTS needs.
>>>> www.Konesans.com
>>>>
>>>>
>>>> "JFB" <jfb@newSQL.com> wrote in message
>>>> news:eiTz0WbxEHA.3844@TK2MSFTNGP12.phx.gbl...
>>>>> Hi,
>>>>> I want to schedule a package to import access database to sql2000
>>>>> server
>>>>> (sp3).
>>>>> The pkg fail with permissions error... what do I neet to have in mine
>>>>> for
>>>>> schedule pkg?
>>>>> Do I need to install access in my sql2000 server?
>>>>> The pkg is running ok manually.
>>>>> Tks in advance
>>>>> JFB
>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>
>>
>

Relevant Pages

  • Re: PLUG: PMAS
    ... it returns a "temporary failure" and logs the triplet. ... check_user: User malcsue is apparently a username but has no account: FAIL ...
    (comp.os.vms)
  • RE: Norton antivirus fails to scan files
    ... any groups that SYSTEM is a member of then it will fail as well. ... I've removed all other users from the ACL that have no business to ... NAV is started as system account as defined in control ... Also, are you referring to the local administrators> group, or the local administrator account? ...
    (Vuln-Dev)
  • Re: Custom Services Failing on Restart when 70+ are running
    ... services run with different accounts, the same account or the local system ... But on reboot random custom services fail. ... It is normally 3-4 custom services that fail on reboot. ... When this happens on reboot Terminal services also fails to start. ...
    (microsoft.public.windows.server.general)
  • Re: PLUG: PMAS
    ... check_user: User xnwvcqvf is apparently a username but has no account: FAIL ... check_user: User antalyaivr is apparently a username but has no account: FAIL ...
    (comp.os.vms)
  • Re: aio_read/write versus O_NONBLOCK
    ... Putting this into the subjunctive mode you assume here would result in ... "may be accessed without generating a permissions error". ... None of these phrasing guarantee a future result. ... to imply that some other future read will not fail due to permissions. ...
    (comp.unix.programmer)
Loading