This is a post on installing SQL Server via command; I have a Windows Server 2016 Core running on a local Hyper-V test environment, and I’m installing SQL Server 2019, then uninstalling it.
As this is on my test environment, I’m installing the most recent SQL Server Edition available, which is SQL Server 2019 CTP 2.4 at the time of writing.
SQL Server 2019 can be downloaded here – Open it up and select to download the media.
ISO’s are good for local virtual environments (using HyperV here).
We’re now ready to get that ISO mounted.
1. Click Media > Insert Disk…
2. Select the ISO file.
1. First, lets have a look at our drives using the Get-PSDrive cmdlet.
2. Install using your preferred parameters. I’m adding the Domain Admins group as Sysadmins for quickness.
d:\setup /qs /ACTION=Install /FEATURES=SQLEngine /INSTANCENAME=MSSQLSERVER /SQLSYSADMINACCOUNTS="WHYTE\Domain Admins" /IACCEPTSQLSERVERLICENSETERMS
The above shows the result of the installation was successful, and other things like where the Configuration INI file is (used for Unattended Installs).
4. Next, we should check the SQL Server services, using Get-Service with “SQL” wrapped in wildcards.
Uninstalling is as simple as the install, funnily enough..
d:\setup /qs /ACTION=Uninstall /FEATURES=SQLEngine /INSTANCENAME=MSSQLSERVER
Once it’s done, we can check the summary file status and services to quickly verify the uninstallation has not been unsuccessful.