-
Notifications
You must be signed in to change notification settings - Fork 10
Group Policy Object Introduction
Previous Group Policy Management | Setup Folder Permissions Next |
---|
Group Policy Objects (GPOs) are the standard method for enforcing security and standards within Windows. The use of GPOs is expected by Auditors and Windows Administrators.
FineBuild is designed to work with or without the use of GPOs. The SQL Server services should be protected by configuring Windows security. Depending on site standards, this may be done either by manually applying the required security or by the use of Group Policy Objects (GPOs). DBAs and other people managing a SQL Server instance should seek to exploit GPO for security wherever practical.
This section includes specifications that allow the required GPOs to be created, and the FineBuild scripts apply the permissions specified for the GPOs regardless of if GPOs are used. However, the use of GPOs is recommended as this complies with Windows best practice and is far easier to enforce and audit.
A GPO can be created and deployed before SQL Server is installed. This document is designed so that the GPO specifications can be easily extracted and copied into a Work Request to ask your Support Centre to create the GPOs.
- Copy the details from the pages listed in Group Policy Management into a new document (Word, Google Docs, etc).
- Remove instructions intended for DBA staff.
- Where required, change the variable information to that required for the install being performed.
Insert the completed document into the Work Request. The document can also be used as part of the server Handover documentation. Work Requests should be raised according to site standards. An example e-mail to raise the Work Request for GPO creation is given is shown below:
Copyright FineBuild Team © 2014 - 2018. License and Acknowledgements
Previous Group Policy Management | Top | Setup Folder Permissions Next |
---|
Key SQL FineBuild Links:
SQL FineBuild supports:
- All SQL Server versions from SQL 2019 through to SQL 2005
- Clustered, Non-Clustered and Core implementations of server operating systems
- Availability and Distributed Availability Groups
- 64-bit and (where relevant) 32-bit versions of Windows
The following Windows versions are supported:
- Windows 2022
- Windows 11
- Windows 2019
- Windows 2016
- Windows 10
- Windows 2012 R2
- Windows 8.1
- Windows 2012
- Windows 8
- Windows 2008 R2
- Windows 7
- Windows 2008
- Windows Vista
- Windows 2003
- Windows XP