powershelldba.de
REF: PSDB-SETUP-ADMIN-2026 ROLE: Admin / Domain-Admin STATUS: CONFIGURATION EDITORS
Admin

Two editors, two levels of standard.

The Admin editor maintains the paths and defaults every install starts from. The Domain-Admin editor maintains the per-domain exceptions on top — collation, drive letters, and which AD groups get sysadmin. Users never touch either one; they just run against whatever these editors currently say.

Admin editor

Global paths and defaults.

Start-AdminConfig.cmd opens the admin configuration editor. It writes Config\settings.ini — the values every domain profile builds on.

Tab: Paths

SetupSourceRootRoot directory of the SQL installation sources.
BackupRootTarget directory for system-database backups.
ScriptsRootPath to post-install scripts.
VersionenComma-separated list of available SQL Server versions.

Tab: Defaults

DefaultVersionPre-selected SQL Server version (e.g. 2022).
DefaultEditionPre-selected edition (Developer / Standard / Enterprise).
DefaultPortTCP port (default: 1433).
BrowserPortSQL Browser UDP port (default: 1434).
Format64kCheck64K block-size check for data drives.
PowerBI_EnabledOffer Power BI Report Server as an optional component.
PowerBI_SourcePathInstallation source for Power BI Report Server.
Domain-Admin editor

Per-domain profiles.

Start-DomainConfig.cmd opens the domain-profile editor. Each profile lives at Config\domains\<DOMAIN>.ini, keyed by NetBIOS domain name, and takes priority over the global defaults.

Managing profiles

Left columnList of all profiles in Config\domains\.
+ NewCreates a new profile — enter the NetBIOS domain name (e.g. CONTOSO).
- DeleteRemoves a profile (DEFAULT is protected).
SaveWrites the currently displayed profile.

Tab: General

Display nameDescriptive name for the profile.
CollationSQL Server collation (e.g. Latin1_General_CI_AS).
Sysadmin groupsComma-separated AD groups that get the sysadmin role after install.
Monitoring type0-based index into the monitoring types list from settings.ini [Monitoring].
Target server base pathPath for ZIP export (empty = export disabled).

Tab: Drives

Data driveMDF / NDF user database files.
Log driveLDF transaction logs.
TempDB driveTempDB files.
Backup driveBackups plus the system-database directory.
Install driveSQL Server binary files.
Security policy

BUILTIN\Administrators removal.

By default, PostInstall removes the BUILTIN\Administrators SQL login entirely after install — but only if another active sysadmin login already exists at that point (usually an AD group from the sysadmin-groups setting). If none does, the step is skipped so nobody gets locked out. This follows the same domain-profile-overrides-global priority as the rest of the configuration, and has a per-run escape hatch (-KeepBuiltinAdmins on the CLI).