This project has moved. For the latest updates, please go here.

Previous Configure SQL Agent Properties Manual Configuration Configure SQL Agent Advanced Properties Next

Configure SQL Agent General Properties

FineBuild can Configure the General Properties available in SSMS for the SQL Server Agent.

The SQL Agent General properties should be set as shown below.

FineBuild Configure SQL Agent General Properties

The SQL Agent General Properties configuration relates to Process Id 5BE and is controlled by the parameters below:

Parameter Build SQL2005 SQL2008 SQL2008 R2 SQL2012 SQL2014
SetupSQLAgent FULL Yes Yes Yes Yes Yes
SetupSQLAgent WORKSTATION Yes Yes Yes Yes Yes
SetupSQLAgent CLIENT N/A N/A N/A N/A N/A

In order to maintain compatibility with older versions of SQL FineBuild, the parameter ConfigSQLAgent can also be used.
Top

Manual Configure SQL Agent General Properties

The following steps show what you would have to do for manual SQL Agent General Properties configuration. FineBuild does all of this work for you automatically.

1) Select the General tab.
Set the following General properties:
Property Value
Autostart SQL Server clear
Autostart SQL Server Agent cear

Automatic service restart using SQL Server Agent requires that the service account has local Administrators authority, which is not desired. Instead, automatic restart of services is performed in a more flexible manner using Configure SQL Service Recovery.
General.png
2) Click OK to save any changes made.

Copyright © 2013 - 2014 Edward Vassie. License and Acknowledgements
Previous Configure SQL Agent Properties Top Configure SQL Agent Advanced Properties Next

Last edited Jun 19, 2014 at 7:31 PM by EdVassie, version 3