Summary

This article is a step by step guide for installing SQL Server 2022.

Applies To

This article applies to SQL Server 2022.

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 2022

Step 1: Download SQL Server 2022 | Microsoft Evaluation Center.  https://www.microsoft.com/en-us/evalcenter/download-sql-server-2022

• Run SQL2022-SSEI-Eval.exe
• Click download media.

Step 2: Select English as Language and choose your package option. Download and Save file to c:\ drive.

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

Run the “SQLServer2022-x64-ENU.exe” and extract files to desired folder e.g. C:\Users\Administrator\Downloads\SQLServer2022-x64-ENU>

Navigate to SQL Server Installation Media Directory to run setup:

C:\Users\Administrator\Downloads\SQLServer2022-x64-ENU>

 OR Run the command:

 Syntax:

C:\Users\Administrator\Downloads\SQLServer2022-x64-ENU>setup.exe /q /IACCEPTSQLSERVERLICENSETERMS /ACTION=Install /FEATURES=SQL /INSTANCENAME=<InstanceName> /SQLSVCACCOUNT="NT AUTHORITY\SYSTEM" /SQLSYSADMINACCOUNTS="NT AUTHORITY\SYSTEM" "YourDomain\YourUsername" /AGTSVCACCOUNT="NT AUTHORITY\NETWORK SERVICE" /SQLSVCINSTANTFILEINIT="True" /SAPWD="<YourStrongSAPassword>" /SECURITYMODE=SQL /TCPENABLED=1 /NPENABLED=1 /SQLCOLLATION=SQL_Latin1_General_CP1_CI_AS

 Replace Highlighted Values:

1. <InstanceName> => Your desired Instanced Name like “MACHSOLDB”
2. “<YourDomain\YourUsername>” — with the fully qualified Windows username of the current user you want to grant sysadmin access to.

   You can get the current user using:

   whoami For example, if it returns:

   machsol-1o7s7h2\administrator

3. <YourStrongPassword> => Your desired strong password for “SA” account.

Then update the command like this and execute in Command:

C:\Users\Administrator\Downloads\SQLServer2022-x64-ENU>setup.exe /q /IACCEPTSQLSERVERLICENSETERMS /ACTION=Install /FEATURES=SQL /INSTANCENAME=MACHSOLDB /SQLSVCACCOUNT="NT AUTHORITY\SYSTEM" /SQLSYSADMINACCOUNTS="NT AUTHORITY\SYSTEM" "machsol-1o7s7h2\administrator" /AGTSVCACCOUNT="NT AUTHORITY\NETWORK SERVICE" /SQLSVCINSTANTFILEINIT="True" /SAPWD="SAP@ssw0rd!@#321" /SECURITYMODE=SQL /TCPENABLED=1 /NPENABLED=1 /SQLCOLLATION=SQL_Latin1_General_CP1_CI_AS

Run above command with all parameters.

​

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

Step 3: In the second step specify your Edition click Next and agree to the License terms and then click Next. Then check for the updates, if available then download the Updates and Install the setup files.

​

​

Step 4: On the next page “Microsoft Update” please check the highlighted option in order to use the recommended option regarding updates and click Next.

​​

Step 5: In the fourth step the installation wizard will automatically install the Install Rules and upon completion please click on Next.

You can choose or skip Azure Extention for SQL Server option:

​

Step 6:  Next up here is the Feature selection. In this step please select the required features as highlighted which are required for MachPanel database. Features to be selected: Database Engine Services, Client tools connectivity & Client tools backward compatibility and then click Next.

From Instance features please select: Database Engine Services

From Shared features please select:  Client tools connectivity & Client tools backward compatibility and click Next.

​

Step 7:  In the Instance Configuration please select the Default instance option as shown below and click Next. If you have already created an instance then please use named instance option and provide the Instance Id as well otherwise default instance will work.

​

Step 8: In this step you will review the account properties as there will be different accounts for different SQL server services. Please proceed with below highlighted setting in service accounts tab as we used Default instance so the properties of the accounts should be like:

​

Under the Collation tab please make sure to select the SQL_Latin1_General_CP1_CI_AS as shown below and click Next.

Step 9: The next step is the Database Engine Configuration. Under Server Configuration tab please select the Authentication Mode as Mixed mode which includes both SQL server authentication and Window authentication and provide the password for Server Administrator (SA) account. It is recommended to provide a strong password and also save it in some safe place. There should be one SQL server administrators specified, you can add multiple by clicking on Add button.

Step 10: After the database configuration settings are configured the installation wizard will itself install feature configuration rules and then the installation will proceed and complete.

SQL Server Management Studio Installation

After SQL server Installation we will have to install the SQL server management studio by running the exe file as an Administrator and click on Install.

To install SQL Server Management Studio Setup (20), use below link to download installer:

Download SQL Server Management Studio (SSMS) 20.2.1