Startup Type for SQL Server Agent

Answered Startup Type for SQL Server Agent

  • Saturday, January 12, 2013 1:47 PM
     
     

    Beginner's question:

    During the install of SQL Server 2012, in the SQL Server Configuration page, I forgot to set the Startup Type to Automatic for the SQL Server Agent.

    How can I do that while the install is finished?

    Thanks

All Replies

  • Saturday, January 12, 2013 2:18 PM
     
     Answered

    You can do that via SQL Server Configuration Manager or Services Console.

    Go to Start > Run > "Services.msc"

    Find SQL Server Agent services, go to properties and change start type from Manual to Startup.

    SQLServerAgent.jpg


    - Vishal

    SqlAndMe.com

    • Marked As Answer by WLID1966 Saturday, January 12, 2013 2:57 PM
    •  
  • Saturday, January 12, 2013 2:59 PM
     
     

    Thanks a lot!