This project has moved and is read-only. For the latest updates, please go here.

Previous Configure SQL Instance Processor Properties Manual Configuration Configure SQL Instance Connection Properties Next

Configure SQL Instance Security Properties

FineBuild can Configure the Security Properties of the SQL Server Instance.

The only property that is normally set on this tab is Logon auditing.

If an xp_cmdshell proxy is required, please see xp_cmdshell Proxy Account.

Security Compliance

SQL Instance Security Properties configuration helps to provide an audit of logon attempts to SQL Server. If you setup Security Compliance then SQL Instance Security Properties configuration will always be implemented, with the /AuditLevel: parameter set to 3.

FineBuild Configure SQL Instance Security Properties

The SQL Instance Security Properties configuration relates to Process Id 5BD and is controlled by the parameters below:

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

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

FineBuild also uses the following parameter to help configure SQL Instance Properties:
Parameter Default Description
Auditlevel 2 Defaults to Failed logins only
SecurityMode blank A blank value results in Windows Authentication only. A value of sql will use both SQL Server and Windows Authentication

Valid values for AuditLevel are: 0 = No login audit; 1 = Log successful logins only; 2 = Log failed logins only; 3= Log all logins
Top

Manual Configure SQL Instance Security Properties

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

1) Select the Security tab.
Set the following Security property:
Option Value
Login auditing Failed logins only

Security.png
2) Click OK to save any changes made.

Copyright FineBuild Team © 2013 - 2015. License and Acknowledgements
Previous Configure SQL Instance Processor Properties Top Configure SQL Instance Connection Properties Next

Last edited Nov 18, 2015 at 8:45 AM by EdVassie, version 8