SQLAgent error with job : The owner (domain\SQLServerAdministratorUser) of job Optimizations Job for DB Maintenance Plan 'EnkelSysteemDatabases' does not have server access.

From: jobi (jobi_at_reply2.group)
Date: 10/31/03 

Date: Fri, 31 Oct 2003 08:12:24 +0100

Hi ,

I have this sql2000 (sp3a + hotfix count(*) multiproc) on W2000 sp4 with
domain-controlers W2003 with AD.
On this sqlserver user the domain user 'domain\SQLServerAdministratorUser'
has SA authority because of it's membership of a domain-local-group which
has been added as sql-system-admin group.

I've created this maintenance-plan when I was logged in as
'domain\SQLServerAdministratorUser'.
Therefor the job is owned by 'domain\SQLServerAdministratorUser'. It's been
scheduled to run once a week.
When the job is launched by the schedule, it gives an error:

The owner (domain\SQLServerAdministratorUser) of job Optimizations Job for
DB Maintenance Plan 'EnkelSysteemDatabases' does not have server access.

When I change the jobowner to sa, it runs fine.

Has anyone else noticed this error ?

I know the workaround, but would like a solution.

Is this windows-, sqlserver-, [whatever]-related ?

How to correct this behaviour ?

jobi