I am trying to run a backup job and it has fail the message I am getting is:
The job failed. Unable to determine if the owner (MAMSI\lwilliams) of job DB Backup Job for DB Maintenance Plan 'DB Maintenance Plan1' has server access (reason: Could not obtain information about Windows NT group/user 'MAMSI\lwilliams'. [SQLSTATE 42000] (Error 8198)).
Is it stating that my user group in windows NT doesn't have the rights to run a backup on this server?
Please help!!!
LystraMy first guess would be that the account used to start the SQL Agent service isn't a domain admin, so the agent can't even see what permissions the MAMSI\lwilliams login has in the domain.
NT security is a tough nut to crack at first, mostly because there are so many levels to it. This makes it robust, but a bugger to figure out at first!
-PatP
Showing posts with label isthe. Show all posts
Showing posts with label isthe. Show all posts
Sunday, February 12, 2012
Subscribe to:
Posts (Atom)