SQL FineBuild Execution

Previous SQL Media Preparation	FineBuild Initialisation Next

This page shows how to perform a Workstation Install for SQL Server 2017. A similar process is used for all other versions of SQL Server.

All install activity should be done when logged on using an account with local Administrator authority.

1. Navigate to the install media location using a URL

   SQL FineBuild can be run directly from the software repository on the network

2. Navigate to the FineBuild folder (SQL2017\FineBuild)

   Right-click on CmdHere.bat and select Run as administrator. This will create a temporary drive map to the network location

3. Type the relevant command to start the install process

   The SqlFineBuild script is called to run the standard setup.exe program but with parameters customised for the Workstation Build

   For SQL 2017 Express Edition, use the following command:

   SqlFineExpress /AdminPassword:YourPassword

   

   For a server edition of SQL 2017 using Evaluation Edition, use the following command:

   SqlFineWorkstation /AdminPassword:YourPassword

   

4. The value of the /AdminPassword: parameter should be the password of the person running SQL FineBuild

   This will allow SQL FineBuild to continue with the install following a reboot:

   For Windows 10, log on after a reboot with the same account that was using to start SQL FineBuild, and the install will resume automatically

   For all other versions of Windows, the install will resume automatically without the need to logon

5. If you want to see what parameter options have been set without actually running the SQL Server install, add the following parameter to the command above:

   /ReportOnly

6. If any part of the FineBuild process fails, refer to the FineBuild Troubleshooting section in the Wiki

7. The SQL Server install is divided into two portions

   The first portion installs pre-requisite software

   The second portion installs SQL Server 2017. Depending on the components installed and the operating system, reboots may take place multiple times during the install process

8. The next stage is designed to apply SP and CU maintenance. This stage can also take around 40 minutes

9. After the SQL maintenance has been applied, the community tools are installed

10. The Configuration stage applies best practices to the SQL Server instance

11. The final stage prepares the SQL Server client tools for optimum use, and sets some Windows menu options

12. Explore the FineBuild Workstation Build results

    It is best to have access to the SQL FineBuild Wiki while you explore your first FineBuild as there may be items you want to look up

    Some items are still only documented in the SQL FineBuild Reference Manual. If you decide to print this, be aware it is about 60 pages so try to conserve paper by specifying that 2 or 4 pages should be printed on one sheet of paper, and using duplex mode.

Copyright FineBuild Team © 2020. License and Acknowledgements

Previous SQL Media Preparation	Top	FineBuild Initialisation Next