powershelldba.de
REF: PSDB-SETUP-USER-2026 ROLE: User STATUS: GUI WIZARD
Setup

The install flow, start to finish.

Start-Tool.cmd opens the main setup wizard. It automatically loads the domain profile of the current computer — no configuration changes happen here, just a guided run against the standard the admins maintain. If no domain profile matches, it falls back to DEFAULT.ini.

Phases

Seven phases, always in the same order.

Whether run from the GUI wizard or the CLI, every install goes through the same phases — only the interaction model differs.

  1. Copy sourcesInstallation media is copied from the configured share to a local working path.
  2. PreInstall checksNTFS block size (64K) on the configured drives, and optional snapshot/HPU checks — blocks or warns before anything is installed.
  3. Create directoriesData, log, TempDB, backup, and install folders are created on the drives from the resolved disk layout.
  4. Install SQL ServerRuns Install-DbaInstance with the resolved version, edition, features, and service account.
  5. Optional componentsSSAS, SSRS, SSIS, and TDP are installed if enabled for this environment.
  6. DriversJDBC, ODBC, and DB2 client drivers are installed if configured.
  7. PostInstallMax memory, TempDB layout, TCP port, monitoring account, and Ola Hallengren maintenance jobs are all applied automatically.
Live replay

An actual run, recorded and replayable.

Every run can optionally emit a self-contained, animated HTML replay via -ProgressReport — offline, no CDN, playable by double-click or from a share. This is a real (test) run.

SqlSetup_2026-06-19.html · Server SRV01 · SQL Server 2022 Developer
Prerequisite

Disk layout is resolved automatically.

Five drive roles are resolved from the domain profile before the run starts: install (SQL Server binaries), data (.mdf/.ndf), log (.ldf), TempDB, and backup (also holds the system-database directory). A single-drive server is a per-run choice, not a config value — see the Config reference for the full standard and the single-drive override.

Verification

Confirm the result.

# Check the finished instance
Import-Module sqmSQLTool
Get-sqmSQLInstanceCheck -SqlInstance "SQL01"

Expect: the instance is reachable, defaults are set, and a PostInstall report has been generated. Verify SQL Server 2025 runs separately, since media and dbatools support for it are newer.