Search

MachPanel Knowledgebase

INFO:Installation Guide for SQL Server 2019

Mudesira Munir
MachPanel

Summary
This article is a step by step guide for installing SQL Server 2019.
Applies To
This article applies to SQL Server 2019.
List of anti virus Exclusion for SQL Server:
For Microsoft SQL Server, review details on link below for exclusions list:

https://support.microsoft.com/en-us/help/309422/choosing-antivirus-software-for-computers-that-run-sql-server

Steps to install SQL Server 2019 
Step 1: Download SQL Server Express Setup (2019). https://go.microsoft.com/fwlink/?linkid=866658

Run SQLServer2019-SSEI-Expr.exe

Click download media:

Step 2Select English as Language and Express Core SQL Server Engine Only option (Default Option). Download and Save file to c:\ drive.

 

Once Download is completed, click Close. Copy downloaded installer “SQLEXPR_x64_ENU.exe” to c: drive. Open command prompt and point to c: drive.

Replace strong alpha numeric password in command below, copy/paste in command prompt and click enter to run installer.

SQLEXPR_x64_ENU.exe /QS /ACTION=Install /INSTANCENAME="MachPanelSQL" /FEATURES="SQLENGINE" /SQLSVCACCOUNT="NT AUTHORITY\SYSTEM" /SQLSYSADMINACCOUNTS="NT AUTHORITY\SYSTEM" /AGTSVCACCOUNT="NT AUTHORITY\Network Service" /IACCEPTSQLSERVERLICENSETERMS /IACCEPTROPENLICENSETERMS /SAPWD="STRONGPASSWORDHERE" /SECURITYMODE=SQL /TCPENABLED=1 /NPENABLED=1 /SQLCOLLATION=SQL_Latin1_General_CP1_CI_AS /ADDCURRENTUSERASSQLADMIN=1

Please execute the installer as “Run as Administrator” and select the first option from the installer “New SQL Server Standalone Installation’.