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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment