Workstation Build - SQL-FineBuild/Common GitHub Wiki

Previous Additional Named Instance Server Build Client Tools Only Build Next

This is the normal build for SQL Server on a single-disk workstation.

Build Contents

This build will contain the following components:

  • SQL Server Database Engine
  • SQL Server Replication
  • Full-Text Search
  • Analysis Services
  • Integration Services
  • Reporting Services
  • Service Pack and/or Cumulative Update
  • Legacy Components
  • Server-based Community Routines
  • SSQL Server Tools

This Build can optionally install the following components if additional parameters are supplied, where valid for the SQL Edition:

  • Data Quality Services
  • Master Data Services
  • PowerBI Server (in place of SSRS)
  • PolyBase
  • R Services
  • Python
  • StreamInsight

The SQLFineWorkstation File

The SQLFineWorkstation.bat file should be used to install an instance of SQL Server on to a single-disk workstation.

Preparation

  1. Prepare the SQL FineBuild install media as described in SQL Media Preparation.

  2. Complete all the non-automated processes described in Install Preparation. The automated portions of Install Preparation will be performed by the SQLFineServer script.

  3. Take a copy of the SQLFineWorkstation.bat file and add any account names and passwords required for your site.

  4. Run the FineBuild install by using your copy of SQLFineWorkstation.bat. In most cases reboots will be performed during the install. FineBuild will continue automatically after you logon following the reboot.

Syntax and Options

See FineBuild Parameter Syntax for details of other syntax details.

REM Copyright © 2008 - 2014 Edward Vassie.  Distributed under Ms-Pl License
REM
CALL "SQLFineBuild.bat" %*     /Type:Workstation             /IAcceptLicenseTerms          ^
 /SAPWD:"UseAL0ngPa55phrase!"  /GroupDBA:"GBGGDBAS01"

If no parameters are given for accounts and passwords, they will default to Vitrual Accounts for installs on Windows 2012 and above, or NETWORK SERVICE for installs on older versions of Windows.

All passwords should comply with site standards for complexity, and it is recommended that service account passwords are at least 30 characters long. All passwords should be stored in the DBA Password Store

Residual Interactive Tasks

The following tasks must be completed manually after the completion of the FineBuild process.

  1. Preparatory Tasks

    a) Complete the Preparatory Tasks starting with Setup Service Permissions and then all remaining tasks up to Final Preparation as described in the FineBuild Reference Manual.

  2. Configuration Tasks

    a) For Windows 2003 and XP, perform the Configure COM Security processing.

    b) Review if any of the Configure SQL Server Certificates is required.

    c) Review if any SQL Server Proxy Accounts are required.

    d) If SQL Mail is being used, the Configure Outlook Mail Profile processing in the FineBuild Reference Manual is required.

Install Processing

Details of the install processing for each version of SQL Server can be found in FineBuild Workstation Build

Copyright FineBuild Team © 2013 - 2018. License and Acknowledgements

Previous Additional Named Instance Server Build Top Client Tools Only Build Next