This project has moved. For the latest updates, please go here.

Previous Additional Named Instance Server Build Client Tools Only Build Next

Workstation Build

This is the normal build for Development Workstations, where developers require the use of a local SQL Server instance during application development.

This build will contain the same components as the Main Instance Server Build, plus all the tools provided in the Client Tools Only Build. All components are installed on a single disk using specified SQL Service Accounts or local NETWORK SERVICE authority.

  • SQL Server Database Engine
  • Client Tools
  • Analysis Services (where valid for the edition being installed)
  • Integration Services
  • Reporting Services
  • Service Pack and/or Cumulative Update
  • Legacy Components
  • Server-based Community Routines
  • Tools-based Community Components

The SQLFineWorkstation File

The SQLFineWorkstation.bat file should be used to install SQL Server on to a single-disk server. This file can also be used for installing Express Edition.

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 SQLFineWorkstation script.

3) Take a copy of the SQLFineWorkstation.bat file and change the account names and passwords as required for your site. The main options for this file are described below.

4) Run the FineBuild install by using your copy of SQLFineWorkstation.bat.

Syntax and Options

See FineBuild Parameter Syntax for details of the colours used in the code example and other syntax details.

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

If site standards require that applications are not installed on to the System drive, add a /DrvProg: keyword to specify the drive to hold the SQL Server program files.

If you want to install Express Edition, you must also include the keyword:

 /Edition:Express

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

Copyright © 2013 - 2014 Edward Vassie. License and Acknowledgements

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

Last edited Aug 22, 2014 at 11:06 AM by EdVassie, version 6