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; toggle it via [Security] Standard in the Admin editor, or per domain.