Re: Job Failure

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 03/24/04 

Date: Wed, 24 Mar 2004 22:20:30 +0100

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: Job Failure
    ... Tibor Karaszi, SQL Server MVP ... > set up to use a valid account on the linked servers. ... >>You will get problems is the job owner isn't sysadmin, ...
    (microsoft.public.sqlserver.server)
  • Re: SQL Server and Agent Accounts
    ... I log in to the server as a sysadmin. ... Here is a scenario that I tested: I created a Windows account called ... Apparently when SQL Agent logs in to the publisher it uses Domain\Maer. ...
    (microsoft.public.sqlserver.replication)
  • Re: Web server in CE 5.0 using ISAPI extensions
    ... SysAdmin is actually implemented as an ISAPI extension. ... resolve the problem of the file download (show the file name ... efficent way to realize a web server on CE. ...
    (microsoft.public.windowsce.app.development)
  • Re: The clock is running down on OS X "security"
    ... lets see how many security "experts" on this forum will continue ... Windows file sharing on an Internet server? ... So, Michelle, where do you work as a sysadmin? ... I agree with you that any sysadmin that is worth a flip should be keeping up with current patches, ...
    (comp.sys.mac.advocacy)
  • Re: xp_cmdshell
    ... When xp_cmdshell is invoked by a user who is a member of the sysadmin fixed ... which the SQL Server service is running. ... Set the "Non sysadmin job step proxy account ... > I have a user and I want to to give persmission of that user to execute ...
    (microsoft.public.sqlserver.clients)