Re: SQL jobs don't work after administrator rename

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

And I did say I would be happy to post it if asked.


"Les Connor [SBS Community Member - SBS MVP]" <les.connor@xxxxxxxxxxxx>
wrote in message news:e1OzqUXOFHA.2348@xxxxxxxxxxxxxxxxxxxxxxx
> Most would post their solution, so that others could benefit. That's what
> this newsgroup is for ;-)
>
> --
> Les Connor [SBS Community Member - SBS MVP]
> -----------------------------------------------------------
> SBS Rocks !
>
>
> <wedor> wrote in message news:u52%23gGXOFHA.1500@xxxxxxxxxxxxxxxxxxxxxxx
>> Fixed it.
>>
>> If anyone wants the answer I'd be happy to provide it.
>>
>>
>> <wedor> wrote in message news:%23B$IahVOFHA.524@xxxxxxxxxxxxxxxxxxxxxxx
>>> Tried that no luck.
>>>
>>> I did find a KB article that suggests that it is a SID issue.
>>>
>>> "Marina Roos [SBS-MVP]" <marina@xxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
>>> message news:%23otV6xUOFHA.440@xxxxxxxxxxxxxxxxxxxxxxx
>>>> Hi Wedor,
>>>>
>>>> Check in the Services that all SQL services are using the proper
>>>> password.
>>>> If you change the admin's password, SQL uses those too, but you
>>>> manually
>>>> have to change them in the services (and in other 3rd party programs.)
>>>>
>>>> --
>>>> Regards,
>>>>
>>>> Marina
>>>> Microsoft SBS-MVP
>>>> One of the Magical M&M's
>>>>
>>>> <wedor> schreef in bericht
>>>> news:uHslGASOFHA.3716@xxxxxxxxxxxxxxxxxxxxxxx
>>>>> I have had this happen on all of the SBS2k3 servers I have done this
>>>>> on.
>>>>>
>>>>> Once you rename the administrator account you can no longer run SQL
>>>>> maintenance jobs, they always fail.
>>>>>
>>>>> It seems that SQL will not "see" the renamed account properly.
>>>>>
>>>>> If you try to add the renamed account into the SQL security area it
>>>>> shows
>>>> as
>>>>> a choice from the dropdown menu but when you hit "OK" you get error
>>>>> 15401
>>>>> that states it cannot find the account.
>>>>>
>>>>> Any ideas?
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>


.

Relevant Pages