Showing posts with label lwilliams. Show all posts
Showing posts with label lwilliams. Show all posts

Sunday, February 12, 2012

Backup issuesPlease HEELP!

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