Back up failing

Question

Back up failing

Stephen Craig

SSC-Addicted

Points: 464
More actions
July 21, 2006 at 5:55 am

#118793

Hi All,
Whenever I try to back up a database I get the error message.
The job failed. Unable to determine if the owner (xxxx\scraig) of job SQLTESTVERSIONSQL backup has server access (reason: Could not obtain information about Windows NT group/user xxxx\scraig'. [SQLSTATE 42000] (Error 8198)).
Can anyone suggest what I need to do to fix it?
thanks
Steve

Viewing 5 posts - 1 through 4 (of 4 total)

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

Greg Charles SSC-Forever Points: 45403 More actions · Answer 1

Steve,

I don't have first-hand experience with this error, but searching MS Knowledgebase for he error message returns several possibilities and fixes.

http://search.support.microsoft.com/search/default.aspx?catalog=LCID%3D1033&1033comm=1&spid=2852&query=Could+not+obtain+information+about+Windows+NT+group%2Fuser&pwt=false&title=false&kt=ALL&mdt=0&res=20&ast=1&ast=2&ast=3&ast=4&mode=a&adv=1

Greg

Bill Brown-348302 SSC Enthusiast Points: 101 More actions · Answer 2

Look in your application and system log to see if your server is having problems talking to the domain controller. This is probably an issue with active directory.

Frank Keller Valued Member Points: 52 More actions · Answer 3

I have received this same exact error message on my servers. It happens because your user account does not have the correct rights in order to run the job from within the context of the agent. Change the owner of the backup job to that of the account running the agent and everything should be fine.

homebrew01 SSC Guru Points: 55548 More actions · Answer 4

I've had the same issue once in a while, with no clue as to why. A job can run for weeks with the same owner, then just fail out of the blue, and work again next time. I also suspect it and issue communicating with the domain controller - at least in my case - as Bill mentioned.