first_page the funky knowledge base
personal notes from way, _way_ back and maybe today

SQL Server 2005 PROBLEM: “Unable to determine if the owner (DOMAIN\\xxx) of job <JOB_Name> has server access (reason: error code 0x534. [SQLSTATE 42000] (Error 15404))”; Andrew Calvett

SQL Server Agent jobs can revert back to their previous owner. This can produce the error: “Unable to determine if the owner (DOMAIN\\xxx) of job <JOB_Name> has server access (reason: error code 0x534. [SQLSTATE 42000] (Error 15404))”

Ultimately the sysdtspackages90 table might need updating. The following SQL statements help:

--See who owns which packages SELECT name , description , suser_sname(ownersid) FROM msdb.dbo.sysdtspackages90

/* Now we update the owner to an appropriate domain account. Either the service account or a generic admin account is good. */

UPDATE msdb.dbo.sysdtspackages90

SET OWNERSID = SUSER_SID('YOUR_DOMAIN\\APPROPRIATE_ACCOUNT') WHERE OWNERSID = SUSER_SID('YOUR_DOMAIN\\OLD_ACCOUNT')

Andrew Calvett writes, “It turns out that when you save a change to a maintenance plan the job owners are reset to the owner of the maintenance plan. The owner of the maintenance plan will be the account used to connect to the server in SSMS when creating the plan.”

For more information see Andrew Calvett, his post, “The Job whose owner kept coming back”:

http://sqlblogcasts.com/blogs/acalvett/
    archive/2007/12/30/the-job-whose-owner-kept-coming-back.aspx
mod date: 2008-09-02T03:28:56.000Z