SQL Server Performance

SQL Serve Job failure - when node fail over

Discussion in 'SQL Server Clustering' started by ssivaprasad, Mar 19, 2005.

  1. ssivaprasad New Member

    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
  2. satya Moderator

    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
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page