Administration Server Role - SQL-FineBuild/Common GitHub Wiki

Previous Developer Workstation Role	Design Site SQL Server Estate Next

This page describes the Administration Server Role 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

Create a role file in the Site SQL Files Folder similar to the example below. Call the file SQLAdmin.bat.

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.

  REM Copyright FineBuild Team © 2014 - 2016.  Distributed under Ms-Pl License
  REM
  CALL "SQLProd.bat" %*     /Type:Client                  ^
   /IAcceptLicenseTerms     /Edition:Standard             ^
   /DrvProg:E

In this example, it is not necessary to create an install file for each server, as there are no server-specific items.
When the SQLAdmin file is run, it runs the environment default values file which in turn invokes FineBuild with the combined set of parameters.

Previous Developer Workstation Role	Top	Design Site SQL Server Estate Next