0

When SQL server is installed on a machine, is the SQL Server Agent enabled and running by default, or does it need starting manually ?

3

This is an installation option. In the installer GUI or command line you can leave it as enabled or disabled and automatic or manual. By default in most versions of SQL it is not enabled and started. I always change it when installing - or forget and do it shortly thereafter.

  • So you mean to say that in GUI under server configuration -- service accounts I can see their is an option to select as manual or automatic. If I select automatic and once the installation is completed my SQL Agent will run automatically and in manual I have to go to services and run it ? – Puskar Nov 22 '16 at 21:45
  • Precisely what I meant. The "startup type" option would be automatic. And it would be started upon successful completion of installation. – Mike Walsh Nov 22 '16 at 22:33

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.