Configure SQL Instance Permissions Properties - SQL-FineBuild/Common GitHub Wiki
| Previous Configure SQL Instance Advanced Properties | [#Manual Configuration](#manual-configure-sql-instance permissions-properties) | Configure SQL Agent Properties Next |
|---|
FineBuild can Configure Permissions Properties of the SQL Server Instance.
The SQL Instance Permissions properties should be reviewed to confirm that they have not been changed from the default values shown.
Permissions for the DBA Non-Admin group are set in Configure DBA Non-Sysadmin Group.
FineBuild Configure SQL Instance Permissions Properties
The SQL Instance Permissions Properties configuration relates to Process Id 5BD and is controlled by the parameters below:
| SQL Version | Parameter | FULL Build | WORKSTATION Build | CLIENT Build |
|---|---|---|---|---|
| SQL2019 | /SetupSQLInst: | Yes | Yes | N/A |
| SQL2017 | /SetupSQLInst: | Yes | Yes | N/A |
| SQL2016 | /SetupSQLInst: | Yes | Yes | N/A |
| SQL2014 | /SetupSQLInst: | Yes | Yes | N/A |
| SQL2012 | /SetupSQLInst: | Yes | Yes | N/A |
| SQL2008R2 | /SetupSQLInst: | Yes | Yes | N/A |
| SQL2008 | /SetupSQLInst: | Yes | Yes | N/A |
| SQL2005 | /SetupSQLInst: | Yes | Yes | N/A |
In order to maintain compatibility with older versions of SQL FineBuild, the parameter /ConfigSQLInst: can also be used.
Manual Configure SQL Instance Permissions Properties
The following steps show what you would have to do for manual SQL Instance Permissions Properties configuration. FineBuild does all of this work for you automatically.
-
Select the Permissions tab
The Permissions properties should not be changed from the default values shown
-
Click OK to save any changes made
Copyright FineBuild Team © 2014 - 2020. License and Acknowledgements
| Previous Configure SQL Instance Advanced Properties | Top | Configure SQL Agent Properties Next |
|---|