February 9, 2003 at 9:32 pm
Some time ago I used EM to create a sql2k maintenance plan (“Management>
Database Maintenance Plan”). I set the owner of the resultant jobs
(“Management >Sql Server Agent>Jobs”) to “<domain name>\Admin”. Didn’t give
it a second thought.
Last week, under emergency conditions, we rebuilt our old NT, PDC-based domain, as a new Win 2K domain using Active Directory
(went smoother than I suspected; some glitches).
While we used the same domain name as before, the old account “<domain
name>\Admin” is not the same account as the new account “<domain name>\Admin”. Accordingly, the backup jobs failed as the old “Admin” account was not recognized in the new domain. To get around this I temporarily made the job owner, “sa”.
Question: the name “<domains name>\Admin” still appears as a possible job
owner but the job wouldn’t run using that account. How can I remove that name or replace it with “<domain name>\Admin” from the new domain?
TIA,
Bill
February 10, 2003 at 3:24 am
It is in Logins under Security. The problem is the sid is different and can no longer be validated. Drop the account from login will make it disappear from SQLs lists. Then add back and should be fine. You should do this with any Domain account that was setup before the conversion.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply