Administration Server Role

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

1. 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

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

3. 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 - 2021. License and Acknowledgements

Previous Developer Workstation Role	Top	Design Site SQL Server Estate Next