SQL Server 2022 : Install2023/01/13 |
|
Install SQL Server 2022 with stand-alone installation.
On this example, it is based on that download ISO media for SQL Server 2022 installation like here
before installing SQL Server.
|
|
| [1] | Run PowerShell with Admin Privilege and Install SQL Server from ISO media. |
Windows PowerShell Copyright (C) Microsoft Corporation. All rights reserved. # mount ISO media PS C:\Users\Administrator> Mount-DiskImage C:\Users\Administrator\SQLServer2022-x64-ENU.iso Attached : True BlockSize : 0 DevicePath : \\.\CDROM1 FileSize : 1163051008 ImagePath : C:\Users\Administrator\SQLServer2022-x64-ENU.iso LogicalSectorSize : 2048 Number : 1 Size : 1163051008 StorageType : 1 PSComputerName : # confirm where drive ISO mounted PS C:\Users\Administrator> Get-Volume DriveLetter FriendlyName FileSystemType DriveType HealthStatus OperationalStatus SizeRemaining Size ----------- ------------ -------------- --------- ------------ ----------------- ------------- ---- NTFS Fixed Healthy OK 85.68 MB 523 MB FAT32 Fixed Healthy OK 67.21 MB 96 MB E Unknown CD-ROM Healthy Unknown 0 B 0 B D New Volume NTFS Fixed Healthy OK 74.62 GB 79.98 GB F SQLServer2022 Unknown CD-ROM Healthy OK 0 B 1.08 GB C NTFS Fixed Healthy OK 100.1 GB 119.37 GB PS C:\Users\Administrator> cd F:\ PS F:\> ls Directory: F:\ Mode LastWriteTime Length Name ---- ------------- ------ ---- d----- 10/8/2022 8:20 AM 1033_ENU_LP d----- 10/8/2022 8:20 AM Tools d----- 10/8/2022 8:19 AM redist d----- 10/8/2022 8:19 AM resources d----- 10/8/2022 8:20 AM x64 --r--- 10/8/2022 8:20 AM 314 MediaInfo.xml --r--- 10/8/2022 6:39 AM 231328 SqlSetupBootstrapper.dll --r--- 10/8/2022 6:39 AM 45 autorun.inf --r--- 10/8/2022 6:39 AM 133032 setup.exe --r--- 10/8/2022 6:39 AM 532 setup.exe.config # run installation # [/FEATURES=***] : features you'd like to install # ⇒ example below specifies Database, Analysis, Integration services and admin tools # [/ASSYSADMINACCOUNTS=***] : specify admin credential for Analysis Services # ⇒ example below specifies local Administrator account # for other accounts below, those are default accounts (possible change if you need) PS F:\> .\setup.exe /ACTION=install /IACCEPTSQLSERVERLICENSETERMS /QUIET /FEATURES="SQL,AS,IS,Tools" /INSTANCENAME="MSSQLSERVER" /SQLSVCACCOUNT="NT Service\MSSQLSERVER" /SQLSYSADMINACCOUNTS="Builtin\Administrators" /AGTSVCACCOUNT="NT Service\SQLSERVERAGENT" /ASSVCACCOUNT="NT Service\MSSQLServerOLAPService" /ASSYSADMINACCOUNTS="rx-7\Administrator" /ISSVCAccount="NT Service\MsDtsServer160" Microsoft (R) SQL Server 2022 16.00.1000.06 Copyright (c) 2022 Microsoft. All rights reserved. SQL Server 2022 transmits information about your installation experience, as well as other usage and performance data, to Microsoft to help improve the product. To learn more about SQL Server 2022 data processing and privacy controls, please see the Privacy Statement. One or more affected files have operations pending. You should restart your computer to complete this process. # restart to apply changes PS F:\> Restart-Computer -Force |
|
SQL Server 2022 : Install (GUI)
|
| [2] | Mount ISO media and move to the drive, then Click [setup.exe]. |
|
| [3] | Click [Installation] on the left pane and click [New SQL Server stand-alone installation ***] on the top of right pane. |
|
| [4] | Select an Edition of SQL Server you'd like to install. |
|
| [5] | Read License terms well and check a box [I accept the license terms] to agree with it. |
|
| [6] | Select to check important update or not. |
|
| [7] | Setup rules indetify potential ploblems. Check the result and improve if ploblems are detected. For the warning of Windows firewall, it's possbile to configure later for SQL Server, so it's OK to proceed. |
|
| [8] | This is the section of selecting features you'd like to install. On this example, it selects mostly all features except [Machine Learning] and [PolyBase Query Service for External Data]. For [Machine Learning] and [PolyBase Query Service for External Data], those are installed with [Python], [Java], [Microsoft R] for dependency. |
|
| [9] | This is the section of Instance Configuration. Select [Default Instance] or [Named Instance]. (Keep default on this example) |
|
| [10] | This is the section of Service Accounts Configuration. Change them for your requirements. (Keep default on this example) |
|
| [11] | This is the section of Database Configuration. Select Authentication Mode and specify SQL Server administration account. If that's OK, move to [Data Directories] tab. |
|
| [12] | This is the section of Data Directories Settings. Change them for your requirements. (Keep default on this example) If that's OK all, move to [TempDB] tab. |
|
| [13] | This is the section of TempDB Settings. Change them for your requirements. (Keep default on this example) If that's OK all, move to [MaxDOP] tab. |
|
| [14] | This is the section of MaxDOP Settings. Change them for your requirements. (Keep default on this example) If that's OK all, move to [Memory] tab. |
|
| [15] | This is the section of Memory Settings. Change them for your requirements. (Keep default on this example) If that's OK all, move to [FILESTREAM] tab. |
|
| [16] | This is the section of FILESTREAM Settings. Change them for your requirements. (Keep default on this example) If that's OK all, Proceed to next. |
|
| [17] | This is the section of Analysys Services Configurations. Specify Administration Account of Analysys Services. |
|
| [18] | This is the section of Integration Services Scale out (Master Node) Configurations. Change them for your requirements. (Keep default on this example) If that's OK all, Proceed to next. |
|
| [19] | This is the section of Integration Services Scale out (Worker Node) Configurations. Change them for your requirements. (Keep default on this example) If that's OK all, Proceed to next. |
|
| [20] | Comfirm selection of features and it it's OK, Click [Install] button. |
|
| [21] | Installation Starts. |
|
| [22] | After finishing Installation, Click [Close] button to complete and restart Computer. |
|
Matched Content