SQL Server Performance Forum – Threads Archive
Job failure – need a server restart?
My job failed giving following error .<br /><br />The job failed. Unable to determine if the owner (servernamemssqldba) of job DB Backup Job for DB Maintenance Plan ‘userdb_backup’ has server access (reason: Could not obtain information about Windows NT group/user servernamemssqldba’. [SQLSTATE 42000] (Error 819<img src=’/community/emoticons/emotion-11.gif’ alt=’8)’ />).<br /><br />as there is some issue with this accout, i changed the job owner to ‘SA’ ,but still i am getting same error.<br /><br />The job failed. Unable to determine if the owner (servernamemssqldba) of job DB Backup Job for DB Maintenance Plan ‘userdb_backup’ has server access (reason: Could not obtain information about Windows NT group/user servernamemssqldba’. [SQLSTATE 42000] (Error 819<img src=’/community/emoticons/emotion-11.gif’ alt=’8)’ />).<br /><br /><br />Does it need a server restart? has anyone experienced same issue?<br /><br />–rajivREfer KBAhttp://support.microsoft.com/?kbid=834124 to solve the issue. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
Thanks satya. i refered that link already and hence chagned the owner of JOB to SA .but stil getting same error.This is somthing strange, and i think it probably need a server restart.I will let you know the updates. –rajiv
Also check KBAhttp://support.microsoft.com/?kbid=883551 for more information. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
]]>