|
Home > Archive > microsoft.public.sqlserver.server > December 2002 > sql agent not running jobs
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
sql agent not running jobs
|
|
|
| hello,
wondering if anyone has a good explanation for this. i am running
sql2000 under 'sqlsvr' user and sql agent under the local system
account. when i try and run a task (shows up created by 'sqluser') ,
it doesn't run. even worse no success or failure under any sql/sql
agent logs that i could find. when i look through the server's system
event logs it states "job failed. unable to determine if owner
(sqluser) of job has server access(reason - unable to connect to
server)."
can someone enlighten me on why this is happening? i know it has to
do with the incompatibility of rights/permissions of 'sqluser' and
local system acct, but can't envision the why/how?
any help would be appreciated!!
bonus question: what is good standard practice on setting up
rights/permissions of NT users for sql and sql agent?
THANKS!
rick
| |
| Jasper Smith 2002-12-05, 3:23 pm |
| This is caused by the call to xp_logininfo failing
You can prevent this call by setting the job owner
to sa however you will need to try and figure out
why it's failing. Try running it from QA specifying
the SQL Service account and see if you get anything
back e.g.
exec master..xp_logininfo 'domain\sqluser'
There is a KB Article describing the rights required
for service accounts but it appears to be MIA so put
Q283811 into google and look at the cached copy
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"rick" <richard.young@marshall.usc.edu> wrote in message
news:20adef6c.0212051039.5af670bd@posting.google.com...
> hello,
>
> wondering if anyone has a good explanation for this. i am running
> sql2000 under 'sqlsvr' user and sql agent under the local system
> account. when i try and run a task (shows up created by 'sqluser') ,
> it doesn't run. even worse no success or failure under any sql/sql
> agent logs that i could find. when i look through the server's system
> event logs it states "job failed. unable to determine if owner
> (sqluser) of job has server access(reason - unable to connect to
> server)."
>
> can someone enlighten me on why this is happening? i know it has to
> do with the incompatibility of rights/permissions of 'sqluser' and
> local system acct, but can't envision the why/how?
>
> any help would be appreciated!!
>
> bonus question: what is good standard practice on setting up
> rights/permissions of NT users for sql and sql agent?
>
> THANKS!
> rick
|
|
|
|
|