Windows Server 2016 Datacenter, app dev box with SQL16

GitHub | Branch: dev | Commit: c8d137e

This image is a part of the uplift project: IaC, Packer/Vagrant workflows, and base boxes for SharePoint professionals.

• https://github.com/SubPointSolutions/uplift-packer

This box comes with a prepared instance of SQL Server 2016. It requires image completion to get SQL Server instance running.

• https://docs.microsoft.com/en-us/sql/database-engine/install-windows/install-sql-server-using-sysprep?view=sql-server-2017#complete

OS specs

• Microsoft Windows Server 2016 Datacenter Evaluation, v10.0.14393
  • Administrator user vagrant:vagrant, password never expires
  • Windows Updates disabled
  • Windows Defender feature uninstalled
  • UAC disabled
  • Generalized with Sysprep
  • .NET 35
  • Web Platform Installer
  • Patches / KBs
    • KB4132216 - Servicing stack update for Windows 10 Version 1607: May 17, 2018
    • KB4480977 - January 17, 2019—KB4480977 OS Build 14393.2759
• SQL Server 2016
  • SQL Server 2016
  • SQL Server Management Studio 17.04

Chocolatey packages

• 7zip, 18.6
• 7zip.install, 18.6
• chocolatey, 0.10.11
• chocolatey-core.extension, 1.3.3
• chocolatey-windowsupdate.extension, 1.0.3
• curl, 7.64.0
• git, 2.20.1
• git.install, 2.20.1
• KB2919355, 1.0.20160915
• KB2919442, 1.0.20160915
• KB2999226, 1.0.20181019
• lessmsi, 1.6.3
• powershell-core, 6.1.2
• pwsh, 6.1.2
• webpicmd, 7.1.50430.20141001
• Wget, 1.20

PowerShell modules

• [M] cChoco, 2.3.1.0
• [M] cFirewall, 1.0.1
• [M] ComputerManagementDsc, 6.1.0.0
• [M] DSCR_Shortcut, 1.3.7
• [M] MS_xVisualStudio, 1.0.0.0
• [M] Pester, 4.3.1
• [M] PSWindowsUpdate, 2.0.0.4
• [M] SharePointDSC, 1.9.0.0
• [M] SqlServerDsc, 12.2.0.0
• [M] Uplift.Core, 0.2.1902.44
• [M] xActiveDirectory, 2.17.0.0
• [M] xComputerManagement, 4.0.0.0
• [M] xCredSSP, 1.3.0.0
• [M] xDSCFirewall, 1.6.21
• [M] xNetworking, 5.5.0.0
• [M] xPendingReboot, 0.3.0.0
• [M] xSQLServer, 9.1.0.0
• [M] xSystemSecurity, 1.4.0.0
• [M] xTimeZone, 1.7.0.0
• [M] xWebAdministration, 1.19.0.0

Windows features

• [R] AD-Domain-Services
• [R] FileAndStorage-Services
• [F] FS-SMB1
• [F] NET-Framework-45-Core
• [F] NET-Framework-45-Features
• [F] NET-Framework-Core
• [F] NET-Framework-Features
• [F] NET-WCF-Services45
• [F] NET-WCF-TCP-PortSharing45
• [F] PowerShell
• [F] PowerShell-ISE
• [F] PowerShellRoot
• [F] PowerShell-V2
• [F] RSAT
• [F] RSAT-ADDS
• [F] RSAT-ADDS-Tools
• [F] RSAT-AD-PowerShell
• [F] RSAT-AD-Tools
• [F] RSAT-Role-Tools
• [R] Storage-Services
• [F] WoW64-Support

Windows patches

• KB3192137, Update
• KB4132216, Update
• KB4480977, Update

Full list of products

• Tools for .Net 3.5, 3.11.50727
• Active Directory Authentication Library for SQL Server, 14.0.1000.169
• Browser for SQL Server 2016, 13.0.1601.5
• Microsoft .NET Framework 4 Multi-Targeting Pack, 4.0.30319
• Microsoft .NET Framework 4.5 Multi-Targeting Pack, 4.5.50710
• Microsoft .NET Framework 4.5.1 Multi-Targeting Pack, 4.5.50932
• Microsoft .NET Framework 4.5.1 Multi-Targeting Pack (ENU), 4.5.50932
• Microsoft .NET Framework 4.5.1 SDK, 4.5.51641
• Microsoft .NET Framework 4.5.2 Multi-Targeting Pack, 4.5.51209
• Microsoft .NET Framework 4.5.2 Multi-Targeting Pack (ENU), 4.5.51209
• Microsoft Analysis Services OLE DB Provider, 14.0.1000.397
• Microsoft Analysis Services OLE DB Provider, 14.0.1000.397
• Microsoft Build Tools 14.0 (amd64), 14.0.23107
• Microsoft Build Tools 14.0 (x86), 14.0.23107
• Microsoft Build Tools Language Resources 14.0 (amd64), 14.0.23107
• Microsoft Build Tools Language Resources 14.0 (x86), 14.0.23107
• Microsoft Help Viewer 1.1, 1.1.40219
• Microsoft Help Viewer 2.2, 2.2.23107
• Microsoft ODBC Driver 13 for SQL Server, 14.0.1000.169
• Microsoft SQL Server 2008 Setup Support Files , 10.3.5500.0
• Microsoft SQL Server 2012 Native Client , 11.3.6540.0
• Microsoft SQL Server 2014 Management Objects , 12.0.2000.8
• Microsoft SQL Server 2016 RsFx Driver, 13.0.1601.5
• Microsoft SQL Server 2016 Setup (English), 13.0.1601.5
• Microsoft SQL Server 2016 T-SQL Language Service , 13.0.14500.10
• Microsoft SQL Server 2016 T-SQL ScriptDom , 13.0.1601.5
• Microsoft SQL Server 2017 Policies , 14.0.1000.169
• Microsoft SQL Server 2017 T-SQL Language Service , 14.0.17213.0
• Microsoft SQL Server Data-Tier Application Framework (x86), 14.0.3881.1
• Microsoft System CLR Types for SQL Server 2014, 12.0.2402.11
• Microsoft System CLR Types for SQL Server 2017, 14.0.1000.169
• Microsoft Visual C++ 2010 x64 Redistributable - 10.0.40219, 10.0.40219
• Microsoft Visual C++ 2010 x86 Redistributable - 10.0.40219, 10.0.40219
• Microsoft Visual C++ 2013 x64 Additional Runtime - 12.0.21005, 12.0.21005
• Microsoft Visual C++ 2013 x64 Debug Runtime - 12.0.21005, 12.0.21005
• Microsoft Visual C++ 2013 x64 Minimum Runtime - 12.0.21005, 12.0.21005
• Microsoft Visual C++ 2013 x86 Additional Runtime - 12.0.21005, 12.0.21005
• Microsoft Visual C++ 2013 x86 Debug Runtime - 12.0.21005, 12.0.21005
• Microsoft Visual C++ 2013 x86 Minimum Runtime - 12.0.21005, 12.0.21005
• Microsoft Visual C++ 2015 x64 Additional Runtime - 14.0.23026, 14.0.23026
• Microsoft Visual C++ 2015 x64 Debug Runtime - 14.0.23026, 14.0.23026
• Microsoft Visual C++ 2015 x64 Minimum Runtime - 14.0.23026, 14.0.23026
• Microsoft Visual C++ 2015 x86 Additional Runtime - 14.0.23026, 14.0.23026
• Microsoft Visual C++ 2015 x86 Debug Runtime - 14.0.23026, 14.0.23026
• Microsoft Visual C++ 2015 x86 Minimum Runtime - 14.0.23026, 14.0.23026
• Microsoft Visual Studio 2015 Shell (Isolated), 14.0.23107
• Microsoft Visual Studio 2015 Shell (Isolated) Resources, 14.0.23107
• Microsoft Visual Studio 2015 Shell (Minimum), 14.0.23107
• Microsoft Visual Studio 2015 Shell (Minimum) Interop Assemblies, 14.0.23107
• Microsoft Visual Studio 2015 Shell (Minimum) Resources, 14.0.23107
• Microsoft Visual Studio 2015 XAML Designer, 14.0.23107
• Microsoft Visual Studio 2015 XAML Designer - ENU, 14.0.23107
• Microsoft Visual Studio Services Hub, 1.0.23107.00
• Microsoft Visual Studio Tools for Applications 2015 Finalizer, 14.0.23829
• Microsoft Visual Studio Tools for Applications 2015 Language Support, 14.0.23107.20
• Microsoft Visual Studio Tools for Applications 2015 Language Support - ENU Language Pack, 14.0.23107.20
• Microsoft Visual Studio Tools for Applications 2015 Language Support Finalizer, 14.0.23107.20
• Microsoft Visual Studio Tools for Applications 2015 x64 Hosting Support, 14.0.23829
• Microsoft Visual Studio Tools for Applications 2015 x86 Hosting Support, 14.0.23829
• Microsoft VSS Writer for SQL Server 2016, 13.0.1601.5
• PowerShell 6-x64, 6.1.2.0
• Roslyn Language Services - x86, 14.0.23107
• Roslyn Language Services - x86, 14.0.23107
• SQL Server 2016 Batch Parser, 13.0.1601.5
• SQL Server 2016 Common Files, 13.0.1601.5
• SQL Server 2016 Common Files, 13.0.1601.5
• SQL Server 2016 Connection Info, 13.0.14500.10
• SQL Server 2016 Connection Info, 13.0.14500.10
• SQL Server 2016 Data quality service, 13.0.1601.5
• SQL Server 2016 Data quality service, 13.0.1601.5
• SQL Server 2016 Database Engine Services, 13.0.1601.5
• SQL Server 2016 Database Engine Services, 13.0.1601.5
• SQL Server 2016 Database Engine Shared, 13.0.1601.5
• SQL Server 2016 Database Engine Shared, 13.0.1601.5
• SQL Server 2016 DMF, 13.0.1601.5
• SQL Server 2016 DMF, 13.0.1601.5
• SQL Server 2016 Full text search, 13.0.1601.5
• SQL Server 2016 Reporting Services, 13.0.1601.5
• SQL Server 2016 Reporting Services, 13.0.1601.5
• SQL Server 2016 Shared Management Objects, 13.0.14500.10
• SQL Server 2016 Shared Management Objects, 13.0.14500.10
• SQL Server 2016 Shared Management Objects Extensions, 13.0.1601.5
• SQL Server 2016 Shared Management Objects Extensions, 13.0.1601.5
• SQL Server 2016 SQL Data Quality Common, 13.0.1601.5
• SQL Server 2016 SQL Diagnostics, 13.0.1601.5
• SQL Server 2016 XEvent, 13.0.1601.5
• SQL Server 2016 XEvent, 13.0.1601.5
• SQL Server 2017 Batch Parser, 14.0.1000.169
• SQL Server 2017 Client Tools Extensions, 14.0.1000.169
• SQL Server 2017 Client Tools Extensions, 14.0.1000.169
• SQL Server 2017 Common Files, 14.0.1000.169
• SQL Server 2017 Common Files, 14.0.1000.169
• SQL Server 2017 Connection Info, 14.0.1000.169
• SQL Server 2017 Connection Info, 14.0.1000.169
• SQL Server 2017 DMF, 14.0.1000.169
• SQL Server 2017 DMF, 14.0.1000.169
• SQL Server 2017 Integration Services Scale Out Management Portal, 14.0.1000.169
• SQL Server 2017 Integration Services Scale Out Management Portal, 14.0.1000.169
• SQL Server 2017 Management Studio Extensions, 14.0.3006.16
• SQL Server 2017 Management Studio Extensions, 14.0.3006.16
• SQL Server 2017 Shared Management Objects, 14.0.1000.169
• SQL Server 2017 Shared Management Objects, 14.0.1000.169
• SQL Server 2017 Shared Management Objects Extensions, 14.0.1000.169
• SQL Server 2017 Shared Management Objects Extensions, 14.0.1000.169
• SQL Server 2017 SQL Diagnostics, 14.0.1000.169
• Sql Server Customer Experience Improvement Program, 13.0.1601.5
• SQL Server Management Studio, 14.0.17213.0
• SQL Server Management Studio, 14.0.17213.0
• SQL Server Management Studio for Analysis Services, 14.0.17213.0
• SQL Server Management Studio for Reporting Services, 14.0.17213.0
• SSMS Post Install Tasks, 14.0.17213.0
• Visual Studio 2015 Prerequisites, 14.0.23107
• Visual Studio 2015 Prerequisites - ENU Language Pack, 14.0.23107

Windows Server 2016 Datacenter, app dev box with SQL16

GitHub | Branch: dev | Commit: aee61f7

OS specs

• Microsoft Windows Server 2016 Datacenter Evaluation, v10.0.14393
  • Administrator user vagrant:vagrant, password never expires
  • Windows Updates disabled
  • Windows Defender feature uninstalled
  • UAC disabled
  • Generalized with Sysprep
  • .NET 35
  • Web Platform Installer
  • SQL Server 2016
  • SQL Server Management Studio 17.04
  • Visual Studio 2017

Chocolatey packages

• 7zip, 18.6
• 7zip.install, 18.6
• chocolatey, 0.10.11
• chocolatey-core.extension, 1.3.3
• chocolatey-windowsupdate.extension, 1.0.3
• curl, 7.63.0
• git, 2.20.1
• git.install, 2.20.1
• KB2919355, 1.0.20160915
• KB2919442, 1.0.20160915
• KB2999226, 1.0.20181019
• lessmsi, 1.6.3
• powershell-core, 6.1.2
• pwsh, 6.1.2
• webpicmd, 7.1.50430.20141001
• Wget, 1.20

PowerShell modules

• [M] cChoco, 2.3.1.0
• [M] cFirewall, 1.0.1
• [M] ComputerManagementDsc, 6.1.0.0
• [M] DSCR_Shortcut, 1.3.7
• [M] MS_xVisualStudio, 1.0.0.0
• [M] PSWindowsUpdate, 2.0.0.4
• [M] SharePointDSC, 1.9.0.0
• [M] Uplift.Core, 0.1.20190204.24654
• [M] xActiveDirectory, 2.17.0.0
• [M] xComputerManagement, 4.0.0.0
• [M] xDSCFirewall, 1.6.21
• [M] xNetworking, 5.5.0.0
• [M] xPendingReboot, 0.3.0.0
• [M] xSQLServer, 9.1.0.0
• [M] xSystemSecurity, 1.4.0.0
• [M] xTimeZone, 1.7.0.0
• [M] xWebAdministration, 1.19.0.0

Windows features

• [R] AD-Domain-Services
• [R] FileAndStorage-Services
• [F] FS-SMB1
• [F] NET-Framework-45-Core
• [F] NET-Framework-45-Features
• [F] NET-Framework-Core
• [F] NET-Framework-Features
• [F] NET-WCF-Services45
• [F] NET-WCF-TCP-PortSharing45
• [F] PowerShell
• [F] PowerShell-ISE
• [F] PowerShellRoot
• [F] PowerShell-V2
• [F] RSAT
• [F] RSAT-ADDS
• [F] RSAT-ADDS-Tools
• [F] RSAT-AD-PowerShell
• [F] RSAT-AD-Tools
• [F] RSAT-Role-Tools
• [R] Storage-Services
• [F] WoW64-Support

Windows patches

• KB3192137, Update
• KB4132216, Update
• KB4480977, Update

Full list of products

• Tools for .Net 3.5, 3.11.50727
• Active Directory Authentication Library for SQL Server, 14.0.1000.169
• Browser for SQL Server 2016, 13.0.1601.5
• Microsoft .NET Framework 4 Multi-Targeting Pack, 4.0.30319
• Microsoft .NET Framework 4.5 Multi-Targeting Pack, 4.5.50710
• Microsoft .NET Framework 4.5.1 Multi-Targeting Pack, 4.5.50932
• Microsoft .NET Framework 4.5.1 Multi-Targeting Pack (ENU), 4.5.50932
• Microsoft .NET Framework 4.5.1 SDK, 4.5.51641
• Microsoft .NET Framework 4.5.2 Multi-Targeting Pack, 4.5.51209
• Microsoft .NET Framework 4.5.2 Multi-Targeting Pack (ENU), 4.5.51209
• Microsoft Analysis Services OLE DB Provider, 14.0.1000.397
• Microsoft Analysis Services OLE DB Provider, 14.0.1000.397
• Microsoft Build Tools 14.0 (amd64), 14.0.23107
• Microsoft Build Tools 14.0 (x86), 14.0.23107
• Microsoft Build Tools Language Resources 14.0 (amd64), 14.0.23107
• Microsoft Build Tools Language Resources 14.0 (x86), 14.0.23107
• Microsoft Help Viewer 1.1, 1.1.40219
• Microsoft Help Viewer 2.2, 2.2.23107
• Microsoft ODBC Driver 13 for SQL Server, 14.0.1000.169
• Microsoft SQL Server 2008 Setup Support Files , 10.3.5500.0
• Microsoft SQL Server 2012 Native Client , 11.3.6540.0
• Microsoft SQL Server 2014 Management Objects , 12.0.2000.8
• Microsoft SQL Server 2016 RsFx Driver, 13.0.1601.5
• Microsoft SQL Server 2016 Setup (English), 13.0.1601.5
• Microsoft SQL Server 2016 T-SQL Language Service , 13.0.14500.10
• Microsoft SQL Server 2016 T-SQL ScriptDom , 13.0.1601.5
• Microsoft SQL Server 2017 Policies , 14.0.1000.169
• Microsoft SQL Server 2017 T-SQL Language Service , 14.0.17213.0
• Microsoft SQL Server Data-Tier Application Framework (x86), 14.0.3881.1
• Microsoft System CLR Types for SQL Server 2014, 12.0.2402.11
• Microsoft System CLR Types for SQL Server 2017, 14.0.1000.169
• Microsoft Visual C++ 2010 x64 Redistributable - 10.0.40219, 10.0.40219
• Microsoft Visual C++ 2010 x86 Redistributable - 10.0.40219, 10.0.40219
• Microsoft Visual C++ 2013 x64 Additional Runtime - 12.0.21005, 12.0.21005
• Microsoft Visual C++ 2013 x64 Debug Runtime - 12.0.21005, 12.0.21005
• Microsoft Visual C++ 2013 x64 Minimum Runtime - 12.0.21005, 12.0.21005
• Microsoft Visual C++ 2013 x86 Additional Runtime - 12.0.21005, 12.0.21005
• Microsoft Visual C++ 2013 x86 Debug Runtime - 12.0.21005, 12.0.21005
• Microsoft Visual C++ 2013 x86 Minimum Runtime - 12.0.21005, 12.0.21005
• Microsoft Visual C++ 2015 x64 Additional Runtime - 14.0.23026, 14.0.23026
• Microsoft Visual C++ 2015 x64 Debug Runtime - 14.0.23026, 14.0.23026
• Microsoft Visual C++ 2015 x64 Minimum Runtime - 14.0.23026, 14.0.23026
• Microsoft Visual C++ 2015 x86 Additional Runtime - 14.0.23026, 14.0.23026
• Microsoft Visual C++ 2015 x86 Debug Runtime - 14.0.23026, 14.0.23026
• Microsoft Visual C++ 2015 x86 Minimum Runtime - 14.0.23026, 14.0.23026
• Microsoft Visual Studio 2015 Shell (Isolated), 14.0.23107
• Microsoft Visual Studio 2015 Shell (Isolated) Resources, 14.0.23107
• Microsoft Visual Studio 2015 Shell (Minimum), 14.0.23107
• Microsoft Visual Studio 2015 Shell (Minimum) Interop Assemblies, 14.0.23107
• Microsoft Visual Studio 2015 Shell (Minimum) Resources, 14.0.23107
• Microsoft Visual Studio 2015 XAML Designer, 14.0.23107
• Microsoft Visual Studio 2015 XAML Designer - ENU, 14.0.23107
• Microsoft Visual Studio Services Hub, 1.0.23107.00
• Microsoft Visual Studio Tools for Applications 2015 Finalizer, 14.0.23829
• Microsoft Visual Studio Tools for Applications 2015 Language Support, 14.0.23107.20
• Microsoft Visual Studio Tools for Applications 2015 Language Support - ENU Language Pack, 14.0.23107.20
• Microsoft Visual Studio Tools for Applications 2015 Language Support Finalizer, 14.0.23107.20
• Microsoft Visual Studio Tools for Applications 2015 x64 Hosting Support, 14.0.23829
• Microsoft Visual Studio Tools for Applications 2015 x86 Hosting Support, 14.0.23829
• Microsoft VSS Writer for SQL Server 2016, 13.0.1601.5
• PowerShell 6-x64, 6.1.2.0
• Roslyn Language Services - x86, 14.0.23107
• Roslyn Language Services - x86, 14.0.23107
• SQL Server 2016 Batch Parser, 13.0.1601.5
• SQL Server 2016 Common Files, 13.0.1601.5
• SQL Server 2016 Common Files, 13.0.1601.5
• SQL Server 2016 Connection Info, 13.0.14500.10
• SQL Server 2016 Connection Info, 13.0.14500.10
• SQL Server 2016 Data quality service, 13.0.1601.5
• SQL Server 2016 Data quality service, 13.0.1601.5
• SQL Server 2016 Database Engine Services, 13.0.1601.5
• SQL Server 2016 Database Engine Services, 13.0.1601.5
• SQL Server 2016 Database Engine Shared, 13.0.1601.5
• SQL Server 2016 Database Engine Shared, 13.0.1601.5
• SQL Server 2016 DMF, 13.0.1601.5
• SQL Server 2016 DMF, 13.0.1601.5
• SQL Server 2016 Full text search, 13.0.1601.5
• SQL Server 2016 Reporting Services, 13.0.1601.5
• SQL Server 2016 Reporting Services, 13.0.1601.5
• SQL Server 2016 Shared Management Objects, 13.0.14500.10
• SQL Server 2016 Shared Management Objects, 13.0.14500.10
• SQL Server 2016 Shared Management Objects Extensions, 13.0.1601.5
• SQL Server 2016 Shared Management Objects Extensions, 13.0.1601.5
• SQL Server 2016 SQL Data Quality Common, 13.0.1601.5
• SQL Server 2016 SQL Diagnostics, 13.0.1601.5
• SQL Server 2016 XEvent, 13.0.1601.5
• SQL Server 2016 XEvent, 13.0.1601.5
• SQL Server 2017 Batch Parser, 14.0.1000.169
• SQL Server 2017 Client Tools Extensions, 14.0.1000.169
• SQL Server 2017 Client Tools Extensions, 14.0.1000.169
• SQL Server 2017 Common Files, 14.0.1000.169
• SQL Server 2017 Common Files, 14.0.1000.169
• SQL Server 2017 Connection Info, 14.0.1000.169
• SQL Server 2017 Connection Info, 14.0.1000.169
• SQL Server 2017 DMF, 14.0.1000.169
• SQL Server 2017 DMF, 14.0.1000.169
• SQL Server 2017 Integration Services Scale Out Management Portal, 14.0.1000.169
• SQL Server 2017 Integration Services Scale Out Management Portal, 14.0.1000.169
• SQL Server 2017 Management Studio Extensions, 14.0.3006.16
• SQL Server 2017 Management Studio Extensions, 14.0.3006.16
• SQL Server 2017 Shared Management Objects, 14.0.1000.169
• SQL Server 2017 Shared Management Objects, 14.0.1000.169
• SQL Server 2017 Shared Management Objects Extensions, 14.0.1000.169
• SQL Server 2017 Shared Management Objects Extensions, 14.0.1000.169
• SQL Server 2017 SQL Diagnostics, 14.0.1000.169
• Sql Server Customer Experience Improvement Program, 13.0.1601.5
• SQL Server Management Studio, 14.0.17213.0
• SQL Server Management Studio, 14.0.17213.0
• SQL Server Management Studio for Analysis Services, 14.0.17213.0
• SQL Server Management Studio for Reporting Services, 14.0.17213.0
• SSMS Post Install Tasks, 14.0.17213.0
• Visual Studio 2015 Prerequisites, 14.0.23107
• Visual Studio 2015 Prerequisites - ENU Language Pack, 14.0.23107