Install-WindowsFeature Web-Default-Doc,Web-Dir-Browsing,Web-Http-Errors,Web-Static-Content,Web-Http-Logging,Web-Request-Monitor,Web-Stat-Compression,Web-Filtering,Web-Windows-Auth,Web-Net-Ext,Web-Net-Ext45,Web-Asp-Net,Web-Asp-Net45,Web-ISAPI-Ext, Web-ISAPI-Filter,Web-Mgmt-Console,Web-Metabase,NET-Framework-Core,NET-Framework-45-Core,NET-Framework-45-ASPNET,NET-WCF-HTTP-Activation45,NET-WCF-TCP-PortSharing45,WAS-Process-Model,WAS-Config-APIs
Install-WindowsFeature後---
PS C:\Users\sashizaki> Get-WindowsFeature |Format-Table -AutoSize
Display Name Name Install State
------------ ---- -------------
[ ] Active Directory Certificate Services AD-Certificate Available
[ ] Certification Authority ADCS-Cert-Authority Available
[ ] Certificate Enrollment Policy Web Service ADCS-Enroll-Web-Pol Available
[ ] Certificate Enrollment Web Service ADCS-Enroll-Web-Svc Available
[ ] Certification Authority Web Enrollment ADCS-Web-Enrollment Available
[ ] Network Device Enrollment Service ADCS-Device-Enrollment Available
[ ] Online Responder ADCS-Online-Cert Available
[ ] Active Directory Domain Services AD-Domain-Services Available
[ ] Active Directory Federation Services ADFS-Federation Available
[ ] Active Directory Lightweight Directory Services ADLDS Available
[ ] Active Directory Rights Management Services ADRMS Available
[ ] Active Directory Rights Management Server ADRMS-Server Available
[ ] Identity Federation Support ADRMS-Identity Available
[ ] Device Health Attestation DeviceHealthAttestationService Available
[ ] DHCP Server DHCP Available
[ ] DNS Server DNS Available
[ ] Fax Server Fax Available
[X] File and Storage Services FileAndStorage-Services Installed
[ ] File and iSCSI Services File-Services Available
[ ] File Server FS-FileServer Available
[ ] BranchCache for Network Files FS-BranchCache Available
[ ] Data Deduplication FS-Data-Deduplication Available
[ ] DFS Namespaces FS-DFS-Namespace Available
[ ] DFS Replication FS-DFS-Replication Available
[ ] File Server Resource Manager FS-Resource-Manager Available
[ ] File Server VSS Agent Service FS-VSS-Agent Available
[ ] iSCSI Target Server FS-iSCSITarget-Server Available
[ ] iSCSI Target Storage Provider (VDS and VSS hardware providers) iSCSITarget-VSS-VDS Available
[ ] Server for NFS FS-NFS-Service Available
[ ] Work Folders FS-SyncShareService Available
[X] Storage Services Storage-Services Installed
[ ] Host Guardian Service HostGuardianServiceRole Available
[ ] Hyper-V Hyper-V Available
[ ] Network Controller NetworkController Available
[ ] Network Policy and Access Services NPAS Available
[ ] Print and Document Services Print-Services Available
[ ] Print Server Print-Server Available
[ ] Internet Printing Print-Internet Available
[ ] LPD Service Print-LPD-Service Available
[ ] Remote Access RemoteAccess Available
[ ] DirectAccess and VPN (RAS) DirectAccess-VPN Available
[ ] Routing Routing Available
[ ] Web Application Proxy Web-Application-Proxy Available
[ ] Remote Desktop Services Remote-Desktop-Services Available
[ ] Remote Desktop Connection Broker RDS-Connection-Broker Available
[ ] Remote Desktop Gateway RDS-Gateway Available
[ ] Remote Desktop Licensing RDS-Licensing Available
[ ] Remote Desktop Session Host RDS-RD-Server Available
[ ] Remote Desktop Virtualization Host RDS-Virtualization Available
[ ] Remote Desktop Web Access RDS-Web-Access Available
[ ] Volume Activation Services VolumeActivation Available
[X] Web Server (IIS) Web-Server Installed
[X] Web Server Web-WebServer Installed
[X] Common HTTP Features Web-Common-Http Installed
[X] Default Document Web-Default-Doc Installed
[X] Directory Browsing Web-Dir-Browsing Installed
[X] HTTP Errors Web-Http-Errors Installed
[X] Static Content Web-Static-Content Installed
[ ] HTTP Redirection Web-Http-Redirect Available
[ ] WebDAV Publishing Web-DAV-Publishing Available
[X] Health and Diagnostics Web-Health Installed
[X] HTTP Logging Web-Http-Logging Installed
[ ] Custom Logging Web-Custom-Logging Available
[ ] Logging Tools Web-Log-Libraries Available
[ ] ODBC Logging Web-ODBC-Logging Available
[X] Request Monitor Web-Request-Monitor Installed
[ ] Tracing Web-Http-Tracing Available
[X] Performance Web-Performance Installed
[X] Static Content Compression Web-Stat-Compression Installed
[ ] Dynamic Content Compression Web-Dyn-Compression Available
[X] Security Web-Security Installed
[X] Request Filtering Web-Filtering Installed
[ ] Basic Authentication Web-Basic-Auth Available
[ ] Centralized SSL Certificate Support Web-CertProvider Available
[ ] Client Certificate Mapping Authentication Web-Client-Auth Available
[ ] Digest Authentication Web-Digest-Auth Available
[ ] IIS Client Certificate Mapping Authentication Web-Cert-Auth Available
[ ] IP and Domain Restrictions Web-IP-Security Available
[ ] URL Authorization Web-Url-Auth Available
[X] Windows Authentication Web-Windows-Auth Installed
[X] Application Development Web-App-Dev Installed
[X] .NET Extensibility 3.5 Web-Net-Ext Installed
[X] .NET Extensibility 4.8 Web-Net-Ext45 Installed
[ ] Application Initialization Web-AppInit Available
[ ] ASP Web-ASP Available
[X] ASP.NET 3.5 Web-Asp-Net Installed
[X] ASP.NET 4.8 Web-Asp-Net45 Installed
[ ] CGI Web-CGI Available
[X] ISAPI Extensions Web-ISAPI-Ext Installed
[X] ISAPI Filters Web-ISAPI-Filter Installed
[ ] Server Side Includes Web-Includes Available
[ ] WebSocket Protocol Web-WebSockets Available
[ ] FTP Server Web-Ftp-Server Available
[ ] FTP Service Web-Ftp-Service Available
[ ] FTP Extensibility Web-Ftp-Ext Available
[X] Management Tools Web-Mgmt-Tools Installed
[X] IIS Management Console Web-Mgmt-Console Installed
[X] IIS 6 Management Compatibility Web-Mgmt-Compat Installed
[X] IIS 6 Metabase Compatibility Web-Metabase Installed
[ ] IIS 6 Scripting Tools Web-Lgcy-Scripting Available
[ ] IIS 6 WMI Compatibility Web-WMI Available
[ ] IIS Management Scripts and Tools Web-Scripting-Tools Available
[ ] Management Service Web-Mgmt-Service Available
[ ] Windows Deployment Services WDS Available
[ ] Deployment Server WDS-Deployment Available
[ ] Transport Server WDS-Transport Available
[ ] Windows Server Update Services UpdateServices Available
[ ] WID Connectivity UpdateServices-WidDB Available
[ ] WSUS Services UpdateServices-Services Available
[ ] SQL Server Connectivity UpdateServices-DB Available
[X] .NET Framework 3.5 Features NET-Framework-Features Installed
[X] .NET Framework 3.5 (includes .NET 2.0 and 3.0) NET-Framework-Core Installed
[ ] HTTP Activation NET-HTTP-Activation Available
[ ] Non-HTTP Activation NET-Non-HTTP-Activ Available
[X] .NET Framework 4.8 Features NET-Framework-45-Features Installed
[X] .NET Framework 4.8 NET-Framework-45-Core Installed
[X] ASP.NET 4.8 NET-Framework-45-ASPNET Installed
[X] WCF Services NET-WCF-Services45 Installed
[X] HTTP Activation NET-WCF-HTTP-Activation45 Installed
[ ] Message Queuing (MSMQ) Activation NET-WCF-MSMQ-Activation45 Available
[ ] Named Pipe Activation NET-WCF-Pipe-Activation45 Available
[ ] TCP Activation NET-WCF-TCP-Activation45 Available
[X] TCP Port Sharing NET-WCF-TCP-PortSharing45 Installed
[ ] Background Intelligent Transfer Service (BITS) BITS Available
[ ] IIS Server Extension BITS-IIS-Ext Available
[ ] Compact Server BITS-Compact-Server Available
[ ] BitLocker Drive Encryption BitLocker Available
[ ] BitLocker Network Unlock BitLocker-NetworkUnlock Available
[ ] BranchCache BranchCache Available
[ ] Client for NFS NFS-Client Available
[ ] Containers Containers Available
[ ] Data Center Bridging Data-Center-Bridging Available
[ ] Direct Play Direct-Play Available
[ ] Enhanced Storage EnhancedStorage Available
[ ] Failover Clustering Failover-Clustering Available
[ ] Group Policy Management GPMC Available
[ ] Host Guardian Hyper-V Support HostGuardian Available
[ ] I/O Quality of Service DiskIo-QoS Available
[ ] IIS Hostable Web Core Web-WHC Available
[ ] Internet Printing Client Internet-Print-Client Available
[ ] IP Address Management (IPAM) Server IPAM Available
[ ] LPR Port Monitor LPR-Port-Monitor Available
[ ] Management OData IIS Extension ManagementOdata Available
[ ] Media Foundation Server-Media-Foundation Available
[ ] Message Queuing MSMQ Available
[ ] Message Queuing Services MSMQ-Services Available
[ ] Message Queuing Server MSMQ-Server Available
[ ] Directory Service Integration MSMQ-Directory Available
[ ] HTTP Support MSMQ-HTTP-Support Available
[ ] Message Queuing Triggers MSMQ-Triggers Available
[ ] Multicasting Support MSMQ-Multicasting Available
[ ] Routing Service MSMQ-Routing Available
[ ] Message Queuing DCOM Proxy MSMQ-DCOM Available
[X] Microsoft Defender Antivirus Windows-Defender Installed
[ ] Multipath I/O Multipath-IO Available
[ ] MultiPoint Connector MultiPoint-Connector Available
[ ] MultiPoint Connector Services MultiPoint-Connector-Services Available
[ ] MultiPoint Manager and MultiPoint Dashboard MultiPoint-Tools Available
[ ] Network ATC NetworkATC Available
[ ] Network Load Balancing NLB Available
[ ] Network Virtualization NetworkVirtualization Available
[ ] Quality Windows Audio Video Experience qWave Available
[ ] RAS Connection Manager Administration Kit (CMAK) CMAK Available
[ ] Remote Assistance Remote-Assistance Available
[ ] Remote Differential Compression RDC Available
[ ] Remote Server Administration Tools RSAT Available
[ ] Feature Administration Tools RSAT-Feature-Tools Available
[ ] BitLocker Drive Encryption Administration Utilities RSAT-Feature-Tools-BitLocker Available
[ ] BitLocker Drive Encryption Tools RSAT-Feature-Tools-BitLocker-RemoteAdminTool Available
[ ] BitLocker Recovery Password Viewer RSAT-Feature-Tools-BitLocker-BdeAducExt Available
[ ] BITS Server Extensions Tools RSAT-Bits-Server Available
[ ] DataCenterBridging LLDP Tools RSAT-DataCenterBridging-LLDP-Tools Available
[ ] Failover Clustering Tools RSAT-Clustering Available
[ ] Failover Cluster Management Tools RSAT-Clustering-Mgmt Available
[ ] Failover Cluster Module for Windows PowerShell RSAT-Clustering-PowerShell Available
[ ] Failover Cluster Automation Server RSAT-Clustering-AutomationServer Available
[ ] Failover Cluster Command Interface RSAT-Clustering-CmdInterface Available
[ ] IP Address Management (IPAM) Client IPAM-Client-Feature Available
[ ] Network Load Balancing Tools RSAT-NLB Available
[ ] Shielded VM Tools RSAT-Shielded-VM-Tools Available
[ ] SNMP Tools RSAT-SNMP Available
[ ] Storage Migration Service Tools RSAT-SMS Available
[ ] Storage Replica Module for Windows PowerShell RSAT-Storage-Replica Available
[ ] System Insights Module for Windows PowerShell RSAT-System-Insights Available
[ ] WINS Server Tools RSAT-WINS Available
[ ] Role Administration Tools RSAT-Role-Tools Available
[ ] AD DS and AD LDS Tools RSAT-AD-Tools Available
[ ] Active Directory module for Windows PowerShell RSAT-AD-PowerShell Available
[ ] AD DS Tools RSAT-ADDS Available
[ ] Active Directory Administrative Center RSAT-AD-AdminCenter Available
[ ] AD DS Snap-Ins and Command-Line Tools RSAT-ADDS-Tools Available
[ ] AD LDS Snap-Ins and Command-Line Tools RSAT-ADLDS Available
[ ] Hyper-V Management Tools RSAT-Hyper-V-Tools Available
[ ] Hyper-V GUI Management Tools Hyper-V-Tools Available
[ ] Hyper-V Module for Windows PowerShell Hyper-V-PowerShell Available
[ ] Remote Desktop Services Tools RSAT-RDS-Tools Available
[ ] Remote Desktop Gateway Tools RSAT-RDS-Gateway Available
[ ] Remote Desktop Licensing Diagnoser Tools RSAT-RDS-Licensing-Diagnosis-UI Available
[ ] Remote Desktop Licensing Tools RDS-Licensing-UI Available
[ ] Windows Server Update Services Tools UpdateServices-RSAT Available
[ ] API and PowerShell cmdlets UpdateServices-API Available
[ ] User Interface Management Console UpdateServices-UI Available
[ ] Active Directory Certificate Services Tools RSAT-ADCS Available
[ ] Certification Authority Management Tools RSAT-ADCS-Mgmt Available
[ ] Online Responder Tools RSAT-Online-Responder Available
[ ] Active Directory Rights Management Services Tools RSAT-ADRMS Available
[ ] DHCP Server Tools RSAT-DHCP Available
[ ] DNS Server Tools RSAT-DNS-Server Available
[ ] Fax Server Tools RSAT-Fax Available
[ ] File Services Tools RSAT-File-Services Available
[ ] DFS Management Tools RSAT-DFS-Mgmt-Con Available
[ ] File Server Resource Manager Tools RSAT-FSRM-Mgmt Available
[ ] Services for Network File System Management Tools RSAT-NFS-Admin Available
[ ] Network Controller Management Tools RSAT-NetworkController Available
[ ] Network Policy and Access Services Tools RSAT-NPAS Available
[ ] Print and Document Services Tools RSAT-Print-Services Available
[ ] Remote Access Management Tools RSAT-RemoteAccess Available
[ ] Remote Access GUI and Command-Line Tools RSAT-RemoteAccess-Mgmt Available
[ ] Remote Access module for Windows PowerShell RSAT-RemoteAccess-PowerShell Available
[ ] Volume Activation Tools RSAT-VA-Tools Available
[ ] Windows Deployment Services Tools WDS-AdminPack Available
[ ] RPC over HTTP Proxy RPC-over-HTTP-Proxy Available
[ ] Setup and Boot Event Collection Setup-and-Boot-Event-Collection Available
[ ] Simple TCP/IP Services Simple-TCPIP Available
[ ] SMB 1.0/CIFS File Sharing Support FS-SMB1 Available
[ ] SMB 1.0/CIFS Client FS-SMB1-CLIENT Available
[ ] SMB 1.0/CIFS Server FS-SMB1-SERVER Available
[ ] SMB Bandwidth Limit FS-SMBBW Available
[ ] SNMP Service SNMP-Service Available
[ ] SNMP WMI Provider SNMP-WMI-Provider Available
[ ] Software Load Balancer SoftwareLoadBalancer Available
[ ] Storage Migration Service SMS Available
[ ] Storage Migration Service Proxy SMS-Proxy Available
[ ] Storage Replica Storage-Replica Available
[X] System Data Archiver System-DataArchiver Installed
[ ] System Insights System-Insights Available
[ ] Telnet Client Telnet-Client Available
[ ] TFTP Client TFTP-Client Available
[ ] VM Shielding Tools for Fabric Management FabricShieldedTools Available
[ ] WebDAV Redirector WebDAV-Redirector Available
[X] Windows Admin Center Setup WindowsAdminCenterSetup Installed
[ ] Windows Biometric Framework Biometric-Framework Available
[ ] Windows Identity Foundation 3.5 Windows-Identity-Foundation Available
[ ] Windows Internal Database Windows-Internal-Database Available
[X] Windows PowerShell PowerShellRoot Installed
[X] Windows PowerShell 5.1 PowerShell Installed
[X] Windows PowerShell 2.0 Engine PowerShell-V2 Installed
[ ] Windows PowerShell Desired State Configuration Service DSC-Service Available
[ ] Windows PowerShell Web Access WindowsPowerShellWebAccess Available
[X] Windows Process Activation Service WAS Installed
[X] Process Model WAS-Process-Model Installed
[ ] .NET Environment 3.5 WAS-NET-Environment Available
[X] Configuration APIs WAS-Config-APIs Installed
[ ] Windows Search Service Search-Service Available
[ ] Windows Server Backup Windows-Server-Backup Available
[ ] Windows Server Migration Tools Migration Available
[ ] Windows Standards-Based Storage Management WindowsStorageManagementService Available
[ ] Windows Subsystem for Linux Microsoft-Windows-Subsystem-Linux Available
[ ] Windows TIFF IFilter Windows-TIFF-IFilter Available
[ ] WinRM IIS Extension WinRM-IIS-Ext Available
[ ] WINS Server WINS Available
[X] Wireless LAN Service Wireless-Networking Installed
[X] WoW64 Support WoW64-Support Installed
[X] XPS Viewer
SQL Installation Centerが起動しますので、「Installation」をクリックします。
一番上のスタンドアロンインストレーションをクリックします。
今回は、プロダクトキーを指定してインストールします。
エラーになりました。プロダクトキー配下にあるチェックボックスのいずれかをチェックしないとダメなようですね。
SQL Serverのライセンスのみをチェックしました。
無事に通過しました。
Microsoft Updateを使うために、チェックボックスをチェックします。
Windows Firewallの警告は、必ず表示されますね。
Azure Extensionは、使用しないのでチェックを外します。
見慣れた機能の画面になりました。ここでは、システム要件に基づきデータベースエンジンのみをチェックします。
デフォルトインスタンスのままで、先に進めます。
SQL Server Agentとデータベースエンジンに対してドメインユーザーを指定します。
SQL Server Agentは、自動起動に変えています。
認証モードは、Windows認証のみとして、管理者ユーザーと管理グループを追加します。
データディレクトリは、規定値のままとします。
TempDBは、規定値のままとします。
MaxDOPは、規定値のままとします。
メモリーは、既定値から、割りたてたメモリー量からマイナス4GBにしました。
「Click here」のチェックボックスをチェックしないと、次に進めないのですね。チェックを入れます。
FILESTREAMは、規定値のままとします。
インストールサマリーを確認したら、インストールを開始します。
しばし待つとインストールが完了しました。
続いて、SQL Server Management Studio 21をインストールします。セットアップファイルを起動します。
21は、インストールパラメーターが変わりましたね。。。「AI Assistance」、「Hybrid and Migration」をチェックしてインストールを開始します。
しばし待つとインストール完了しました。これまでバージョンと同様に再起動が必要ですね。
再起動しておきました。
