Autostart Sql Server Agent

In sql server 2005 how do you change the settings for autostarting the sqlserver agent when the OS starts. For eg in sql server 2000 when you click the server properties you can cha nge it there but what about sql server 2005?right click My Computer and then Manage. Once there, expand Services and Applications, then click on Services. From there, you can find the SQL Server Agent() service, go to properties, and make the startup type Automatic.|||

Hello Tim,

Thanks for this info, but i wanted to know how could you do it from management console. like how you can do it from Enterprise manager in SQL server 2000. This will help my cause but just for better knowledge i wanted to know.

|||

SQL Server Configuration Manager is the tool to be used in sql server 2005 for any administration of Services, protocols etc... You can find it Programs --MSSQLServer 2005 --Configuration Tool.

Right click on any service and do whatever setting you want there.

ref : http://msdn2.microsoft.com/en-us/library/ms174212.aspx

Madhu

|||Thanks a lot Madhu. I appreciate that.|||

Make sure you mark it as "Answered"

yes, SQL Configuration Tool would be the place to configure Service Start type of services