Installation Prerequisites Windows Server (2016+)
.NET Framework
Windows PowerShell
Administrator access
Installation Steps Download SQL Server:
powershell Copy
Download SQL Server ISO
Mount ISO or extract installation media
Run Installation:
cmd Copy
Setup.exe /Q /IACCEPTSQLSERVERLICENSETERMS /ACTION=Install
/FEATURES=SQLEngine,Replication
/INSTANCENAME=MSSQLSERVER
/SQLSYSADMINACCOUNTS="BUILTIN\Administrators"
/SECURITYMODE=SQL
/SAPWD="ComplexPassword123!"
Post-Installation
powershell Copy
# Enable TCP/IP
$smo = 'Microsoft.SqlServer.Management.Smo.'
$wmi = new-object ($smo + 'Wmi.ManagedComputer')
$uri = "ManagedComputer[@Name='" + (get-item env:\computername).Value + "']/ServerInstance[@Name='MSSQLSERVER']/ServerProtocol[@Name='Tcp']"
$Tcp = $wmi.GetSmoObject($uri)
$Tcp.IsEnabled = $true
$Tcp.Alter()