SQL Serve Job failure – when node fail over | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

SQL Serve Job failure – when node fail over

I have a setup of SQL Server 2000 Active Passive Cluster on Windows 2003 Environment. Maintenance plans were created when the Node-1 was active.
Two weeks back the SQL Server cluster service failed over to Node-2, where in all other services are remain in the Node-1. But the backup jobs and all the other maintenance jobs are failing on Node -2 with the following error. "The job failed. The owner () of job DB Backup Job for DB Maintenance Plan ‘UserDB Maintplan’ does not have server access." But all these jobs were owned by Windows Domain account which is member of the ‘Local Administrator Group’. On workaround , I changed the job owner to a ‘SQL Server Login’ and the jobs
are running successfull now. Is anyone faced the same kind of error? Appreciate your views and ideas on what could have casued this problem. Thanks S Sivaprasad S Siva Prasad
I believe the local BUILTINADMINISTRATOR account is removed from SQL Server access and in general its better to leave the job owner as SA. Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.