Re: Job Failure

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Adam (anonymous_at_discussions.microsoft.com)
Date: 03/24/04 

Date: Wed, 24 Mar 2004 14:04:53 -0800

Yes, I have tried running the job as the database's owner
and as the 'sa' system account. Both fail, yet both are
set up to use a valid account on the linked servers. I
have this same setup on another server linked to the same
servers, and it works just fine.
>-----Original Message-----
>Do you get the same error regardless of which login owns
the job?
>
>You will get problems is the job owner isn't sysadmin, as
Agent then tries to emulate the job owner's login's
>user name in the database using the SETUSER command. And
after executing SETUSER, you are not allowed to do
>operations at the server level. accessing linked server
is a server (long) level operation.
>--
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>
>
><anonymous@discussions.microsoft.com> wrote in message
news:12d7401c411df$be50c4c0$a401280a@phx.gbl...
>> Yes, I am accessing several linked servers. I have
tried
>> running the job with the owner as sysadmin and as
another
>> user. Both fail.
>> >-----Original Message-----
>> >Is the job owner sysadmin? Are you accessing linked
>> server?
>> >
>> >--
>> >Tibor Karaszi, SQL Server MVP
>> >http://www.karaszi.com/sqlserver/default.asp
>> >
>> >
>> >"Adam" <anonymous@discussions.microsoft.com> wrote in
>> message news:fed501c411be$81b90020$a601280a@phx.gbl...
>> >> I have a job that runs stored procedures. I ran the
>> stored
>> >> procedures in the correct order myself and they ran
>> fine.
>> >> But when I try to run them in a job the job fails
>> >> immediately. I tried changing the user for the job
so
>> >> that it matches the creator of the database and
stored
>> >> procedures, and the job still failed. So then I
wrote
>> the
>> >> output of the job to a file, and this is the error
that
>> is
>> >> happening.
>> >>
>> >> Msg 7399, Sev 16: OLE DB provider 'SQLOLEDB'
reported an
>> >> error. [SQLSTATE 42000]
>> >> Msg 7312, Sev 16: [SQLSTATE 01000]
>> >>
>> >> Does anyone have any ideas?
>> >>
>> >> Thank you for your assistance,
>> >> Adam
>> >
>> >
>> >.
>> >
>
>
>.
>

Relevant Pages

  • Re: Replication failure
    ... Connecting to directory service on server arnelfs1. ... ARNELDC1 is the Schema Owner, but is not responding to DS ... prevented from starting by the File Replication Service. ...
    (microsoft.public.windows.server.active_directory)
  • Re: Unable to local DC ......... URGENT
    ... So please give some infos about server names, which is the old, which is the running and which is the new one. ... Verifying that the local machine NODE2, ... Role Schema Owner = CN="NTDS Settings ...
    (microsoft.public.win2000.active_directory)
  • RE: Domain membership test: Failed
    ... Testing server: Default-First-Site\ALRANGE1 ... is the Schema Owner, but is deleted. ... "Meinolf Weber" wrote: ... There is ALRANGE domain with two W2K servers, Alrange1 and Alrange2, ...
    (microsoft.public.win2000.active_directory)
  • Re: Spam:RE: application for an employment
    ... I fully agree that having a poorly protected web server puts you in a false ... The rights are those of the property owner. ... Tailor your education to your own professional goals with degree ... confirmed by letter or fax signed by a Partner of BDO. ...
    (Security-Basics)
  • RE: Spam:RE: application for an employment
    ... The rights are those of the property owner. ... owner - i.e. the owner of the web server has rights. ... Tailor your education to your own professional goals with degree ... confirmed by letter or fax signed by a Partner of BDO. ...
    (Security-Basics)