Post reply

DB Maintenance Plan for system db fails

  • September 13, 2006 at 9:08 am

    #114428

    Hi,

    I created a new db maintenance plan to backup system databases.

    No problems on creating it. everything went fine.

    When I ran the job using the "start job" option, it failed.

    The error message is

    The job failed.  Unable to determine if the owner (xyz\murali) of job DB Backup Job for DB Maintenance Plan 'DB Maintenance Plan1 for system databases' has server access (reason: Could not obtain information about Windows NT group/user 'xyz\murali'. [SQLSTATE 42000] (Error 8198)).

    Any suggestions to look for?

     

    Thanks

    Murali

     

     

     

  • September 13, 2006 at 9:25 am

    #660127

    make sure you are the local administrator and has all privileges. Or try to run under sa account

     

    Prema

  • September 13, 2006 at 10:39 am

    #660155

    Good suggestion.

    I am in the domain administrator group which I guess should take care of it.

    It did not work with the domain id.

    I did assign the job to 'sa' and it worked fine.

    Question is, why?

     

    Thanks

    Murali

     

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply