Hi,
I created a job to backup my database. Sometimes I get the following error:
The job failed. Unable to determine if the owner (DOMAIN\Administrator) of job Backup.Subplan_1 has server access (reason: Could not obtain information about Windows NT group/user 'DOMAIN\Administrator'<c/> error code 0x54b. [SQLSTATE 42000] (Error 15404))
I already deleted the job and made it again. Same problem. I don't get that error every day. For example: I got it 4 times last month.
Does anybody know what I can do to resolve the error?This appears to be a problem with AD. I would guess the job is not able to authenticate itself, or query information from AD. That said, it REALLY a bad idea to run jobs as Domain Admin. You should use service accounts.
Showing posts with label determine. Show all posts
Showing posts with label determine. Show all posts
Tuesday, March 27, 2012
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
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:
Posts (Atom)