Skip to content

Administration Server Role

EdVassie edited this page Jun 20, 2018 · 5 revisions
Previous Developer Workstation Role Installing SQL Server on Windows Core Next

This page describes the Administration Server Role SQL FineBuild deployment file.

The assumptions relating to this role are:

  • Multiple DBAs will share this server via Remote Desktop
  • Only client tools should be installed
  • All software should be installed on the E: drive wherever possible
  1. Create a role file in the Site SQL Files Folder similar to the example below. Call the file SQLAdmin.bat.
REM Copyright FineBuild Team © 2014 - 2016.  Distributed under Ms-Pl License
REM
CALL "SQLProd.bat" %*     /Type:Client                  ^
 /IAcceptLicenseTerms     /Edition:Standard             ^
 /DrvProg:E

The role file contains all the parameters that define the role. The /Edition: value is not important for a Client build, but should be stated in order to find the SQL install media.

  1. In this example, it is not necessary to create an install file for each server, as there are no server-specific items.

  2. When the SQLAdmin file is run, it runs the environment default values file which in turn invokes FineBuild with the combined set of parameters.

Copyright FineBuild Team © 2014 - 2018. License and Acknowledgements

Previous Developer Workstation Role Top Installing SQL Server on Windows Core 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
Clone this wiki locally