Skip to content

Legacy Server Build

EdVassie edited this page Aug 29, 2018 · 3 revisions
Previous Lightweight Server Role Management Server Role Next

This page describes the Legacy Server Build deployment file.

The assumptions relating to this role are:

  • A specific version of SQL Server is required, due to the need to host a legacy application
  • All other requirements for this server are met by the Lightweight Server Role
  • Only one server is needed for this role
  1. Create an install file in the Site SQL Files Folder for the required server similar to the example below. Call the file PDGB01SQLD0240.bat, for use with server PDGB01SQLD0240

    The install file contains the parameters unique to the server, such as the account names and server name. The SET %SQLVERSION% statement causes this server to be built with SQL Server 2008 R2 and not with the default version of SQL Server used elsewhere.

  REM Copyright FineBuild Team © 2017.  Distributed under Ms-Pl License
  REM
  SET %SQLVERSION%=SQL2008R2
  CALL “SQLLightweight.bat” %*                       ^
   /IAcceptLicenseTerms       /Server:PDGB01SQLD0231 ^
   /SAPWD:”UseAL0ngPa55phrase!”                      ^
   /SQLSVCAccount:”ROOT\ServGB_SQLDB_0001”           ^
    /SQLSVCPassword:”Argyt$6hsGGWMP894s4Gw2b73GS2o0” ^
   /AGTSVCACCOUNT:”ROOT\ServGB_SQLAG_0001”           ^
    /AGTSVCPASSWORD:”F6tbmd*nf!dfGFrcQnm84g4K7zwq2j” ^
   /ASSVCACCOUNT:”ROOT\ServGB_SQLAS_0001”            ^
    /ASSVCPASSWORD:”kE44bmutFGS579*bssJW84f=Rb6ehj”  ^
   /FTSVCACCOUNT:”ROOT\ServGB_SQLFT_0001”            ^
    /FTSVCPASSWORD:”w$Yhfb84nmkl5r*hsdFR7yNs2$ynd6”  ^
   /ISSVCACCOUNT:”ROOT\ServGB_SQLIS_0001”            ^
    /ISSVCPASSWORD:”bSHG5iuf9DFF#dw2!F5sKSIw43tnb7”
  1. When the install file is run, it runs the role file to pick up the standard role parameters. The role file then runs the environment default values file which in turn invokes FineBuild with the combined set of parameters and installs SQL 2008 R2.

Copyright FineBuild Team © 2017 - 2018. License and Acknowledgements

Previous Lightweight Server Role Top Management Server Role 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