April 9, 2009 at 11:01 am
hi,
We have Created a sql server agent, which deletes the old bakup files. But it failing with the below error message.
Error creating security descriptor for shared objects (reason: No mapping between account names and security IDs was done). The step failed.
Could you plese help me how to fix this
April 9, 2009 at 11:04 am
Whatever user name you have it running under isn't mapped to a security account in SQL. You need to do that. Go to the properties of the user name, set it up in there.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
April 9, 2009 at 11:18 am
Thank you,
the other jobs in SQL Server agent are running fine with user abc\admin. Only this one job is failing, which has also the same user abc\admin.
SO where exactly I need to change/map the user?
April 13, 2009 at 6:50 am
Is it running in a different database than the others? I don't mean msdb, I mean the database it does its work in.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply