Tag: SQLServerDSC

Install SQL Server with Desired State Configuration & DBATools

goforebroke480Leave a comment

DSC (Desired State Configuration) is a PowerShell-based management platform that enables you to manage IT and development infrastructure using configuration as code.

Prerequisites

  • Oracle VirtualBox must be downloaded and installed on Windows 10.
  • Basic knowledge of Desired State Configuration (DSC).
  • Familiarity with SQL Server command-line installation options.
  • Understanding of Active Directory.
  • A Windows Server 2016 or 2019 Domain Controller must be installed and configured.
  • A Windows Server 2016 or 2019 server must be installed and configured to serve as a file share server.
  • A Windows Server 2016 or 2019 server must be installed and configured to host SQL Server.

Instructions

Part 1: Setup SQL Server media share

Part 2: Download SQLServerDSC and DBATools

Part 3: Install SQL Server with DSC & DBA Tools