Re: How do people use SQL in Win authenticated mode only?

From: Rand Boyd [MSFT] (rboyd_at_onlinemicrosoft.com)
Date: 05/27/04 

Date: Thu, 27 May 2004 13:40:51 GMT

If you do not want to use sa as the job owner, you can create another SQL
login and make it the job owner. If you do this, some jobs will run under
the context of the SQL proxy account so this account will need the
necessary permissions.

Rand
This posting is provided "as is" with no warranties and confers no rights.

Relevant Pages

  • Re: SQL Agent Jobs Failing
    ... Is changing the job owner to "sa" an option? ... Tibor Karaszi, SQL Server MVP ... > SQL Agent runs under a domain account with sysadmin rights ...
    (microsoft.public.sqlserver.server)
  • Re: SQL job owner and right
    ... try to assign the job owner to this group, but the window group is not ... Andrew J. Kelly SQL MVP ... and account A also has these three roles. ...
    (microsoft.public.sqlserver.security)
  • Re: user permission to run job only
    ... I was able to run the job after I assign the job owner to the user. ... > Hello SQL, ... > What is the error message that you are getting? ... > Aaron Weiker ...
    (microsoft.public.sqlserver.programming)
  • Re: HELP..
    ... It should be the login that SQLServer is using. ... If the job owner isn't sysadmin, ... executes the SETUSER command to emulate the owners username context in that database. ...
    (microsoft.public.sqlserver.security)