What happens to sql server if the active directory server goes down and the sql agent services is logged on as a windows user.


It will continue running, as its already authenticated.

Are you asking because you need to restart an AD server, or has your one and only AD server failed?

  • Yes the one and only AD server would be down for an hour and i am trying to understand the effects that the sql agent services would have on sql server. Would there be excessive error logging/any other effects? – Angel_Boy Sep 25 '14 at 19:36
  • Since the agent is authenticated, jobs should run without issue. – DanBig Sep 25 '14 at 19:41

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.