Skip to main content

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()