How to Start SQL Server Agent service

[Parimal Patel]

Hi

We just purchased licence.
As part of my installation process, How to Start SQL Server Agent service using Advanced installer and set property Start Mode to 'Automatic' ?

ADI_SqlAgent.png (32.58 KiB) Viewed 5218 times

Thanks,

[Dan]

Hello,

We do not have predefined support for this, but you can try to use a custom action to start the SQL Server Agent service. Maybe you can find a way to start it automatically through a custom action.

For example, in the attached sample we changed the StartupType of the asp net service in a Power Shell command line custom action.

A sample project is attached to this thread, so if you are interested to take a look directly at my project, you are more than welcome to download the ZIP file. In the sample project, the aspnet_state service is set to start automatically.

Let me know if that helped.

Best regards,
Dan

[Parimal Patel]

Hi Dan

Thanks for reply. I will try and let you know.