9.3.1. Procedure : How to Install a SQL Server

By utilizing an Official Template of the below SQL Server, introduce the installation procedure after Virtual Machine creation.

Virtual Server

SQLServer-2014_SP3_Standard_64_English_include-license_WindowsServer-2012R2_Standard_64_include-license_virtual-server_042

Virtual Server

SQLServer-2014_SP3_Standard_64_Japanese_include-license_WindowsServer-2012R2_Standard_64_include-license_virtual-server_042

Virtual Server

SQLServer-2016_SP2_Standard_64_English_include-license_WindowsServer-2012R2_Standard_64_include-license_virtual-server_042

Virtual Server

SQLServer-2016_SP2_Standard_64_Japanese_include-license_WindowsServer-2012R2_Standard_64_include-license_virtual-server_042

Virtual Server

SQLServer-2016_SP2_Standard_64_English_include-license_WindowsServer-2016_Datacenter_64_include-license_virtual-server_002

Virtual Server

SQLServer-2016_SP2_Standard_64_Japanese_include-license_WindowsServer-2016_Datacenter_64_include-license_virtual-server_002

Virtual Server

SQLServer-2017_Standard_64_English_include-license_WindowsServer-2016_Datacenter_64_include-license_virtual-server_002

Virtual Server

SQLServer-2017_Standard_64_Japanese_include-license_WindowsServer-2016_Datacenter_64_include-license_virtual-server_002
Hyper-V SQLServer-2014_SP3_Standard_64_English_include-license_WindowsServer-2012R2_Standard_64_include-license_gen2_Hyper-V_002
Hyper-V SQLServer-2014_SP3_Standard_64_Japanese_include-license_WindowsServer-2012R2_Standard_64_include-license_gen2_Hyper-V_002
Hyper-V SQLServer-2016_SP2_Standard_64_English_include-license_WindowsServer-2012R2_Standard_64_include-license_gen2_Hyper-V_002
Hyper-V SQLServer-2016_SP2_Standard_64_Japanese_include-license_WindowsServer-2012R2_Standard_64_include-license_gen2_Hyper-V_002
Hyper-V SQLServer-2016_SP2_Standard_64_English_include-license_WindowsServer-2016_Standard_64_include-license_gen2_Hyper-V_002
Hyper-V SQLServer-2016_SP2_Standard_64_Japanese_include-license_WindowsServer-2016_Standard_64_include-license_gen2_Hyper-V_002
Hyper-V SQLServer-2017_Standard_64_English_include-license_WindowsServer-2016_Standard_64_include-license_gen2_Hyper-V_002
Hyper-V SQLServer-2017_Standard_64_Japanese_include-license_WindowsServer-2016_Standard_64_include-license_gen2_Hyper-V_002
vSphereESXi SQLServer-2014_SP3_Standard_64_English_include-license_WindowsServer-2012R2_Standard_64_include-license_hw9_vSphere-ESXi_002
vSphereESXi SQLServer-2014_SP3_Standard_64_Japanese_include-license_WindowsServer-2012R2_Standard_64_include-license_hw9_vSphere-ESXi_002
vSphereESXi SQLServer-2016_SP2_Standard_64_English_include-license_WindowsServer-2012R2_Standard_64_include-license_hw9_vSphere-ESXi_002
vSphereESXi SQLServer-2016_SP2_Standard_64_Japanese_include-license_WindowsServer-2012R2_Standard_64_include-license_hw9_vSphere-ESXi_002
vSphereESXi SQLServer-2016_SP2_Standard_64_English_include-license_WindowsServer-2016_Standard_64_include-license_hw9_vSphere-ESXi_002
vSphereESXi SQLServer-2016_SP2_Standard_64_Japanese_include-license_WindowsServer-2016_Standard_64_include-license_hw9_vSphere-ESXi_002
vSphereESXi SQLServer-2017_Standard_64_English_include-license_WindowsServer-2016_Standard_64_include-license_hw9_vSphere-ESXi_002
vSphereESXi SQLServer-2017_Standard_64_Japanese_include-license_WindowsServer-2016_Standard_64_include-license_hw9_vSphere-ESXi_002
vSphereESXi SQLServer-2019_Standard_64_English_include-license_WindowsServer-2019_Standard_64_include-license_hw11_vSphere-ESXi_002
vSphereESXi SQLServer-2019_Standard_64_Japanese_include-license_WindowsServer-2019_Standard_64_include-license_hw11_vSphere-ESXi_002

9.3.1.1. Procedure Flow : SQL Server Installation

Procedure Flow : SQL Server 2014, SQL Server 2016, SQL Server 2017

Flow

Procedure Flow : SQL Server 2019

Flow

9.3.1.2. Procedure : SQL Server Installation

Connect a Virtual Machine to a console.

Specify a password.

Input a password, click [ Finish ].

../../../_images/image218.png

SQL Server Instance Name Modification

If you change a SQL Server Instance Name, input [ Yes ]; otherwise, if you do not change one, input [ No ] and click [ Enter ].

../../../_images/image316.png

Input a SQL Server Instance Name, then click [ Enter ].

../../../_images/image48.png

If the input details are correct, write down [ Yes ]; otherwise if not correct, write down [ NO ], and click [ Enter ].

../../../_images/image54.png

Select Database Engine Collation.

Select the Database Engine Collation, click [ OK ].

../../../_images/image64.png

If the selected details are correct, input [ Yes ], while if the one are NOT correct, input [ No ], click [ Enter ].

../../../_images/image74.png

Select Analysis Services configuration (displayed only in SQL Server 2019)

Select Analysis Services configuration, click [OK].

../../../_images/image123.png

If the selected details are correct, input [ Yes ], while if the one are NOT correct, input [ No ], click [ Enter ].

../../../_images/image134.png

Install SQL Server

Once the SQL Server Installation has started, wait for a while until the installation will have completed and the login screen will display.

9.3.1.3. Health Check

Install Log Check

Open Summary.txt file in the folder specified below by notepad.

SQL Server 2014 C:\Program Files\Microsoft SQL Server\120\setup BootStrap\Log\Summary.txt
SQL Server 2016 C:\Program Files\Microsoft SQL Server\130\setup BootStrap\Log\Summary.txt
SQL Server 2017 C:\Program Files\Microsoft SQL Server\140\setup BootStrap\Log\Summary.txt
SQL Server 2019 C:\Program Files\Microsoft SQL Server\150\setup BootStrap\Log\Summary.txt

Make sure “Final result” is “Passed”.

../../../_images/image84.png

Check the items, such as the Instance Name, the Collation and the Version.

Steps to start SQL Server Management Studio

The startup method of SQL Server Management Studio (SSMS) depends on the installed SQL Server version. The startup method for each version is described below.

For SQL Server 2014, 2016, 2017

Open Windows Powershell.

Input [ ssms ] and click [ Enter ].

For SQL Server 2019

Enter "ssms" in the "Search Box" and select "Microsoft SQL Server Management Studio 18" from the search results.

../../../_images/ssms18_image001.png

Confirm that "Microsoft SQL Server Management Studio 18" started

../../../_images/ssms18_image002.png

Confirmation procedure after starting SQL Server Management Studio

Click [ Connect ] with a default variable.

../../../_images/image94.png

Right click on server name and click “Properties”.

../../../_images/image104.png

If you specified a default instance, confirm that only the server host name is displayed in "Name". If an instance name is specified, confirm that the server host name specified instance name is displayed in "Name"

Make sure the number of “Version” is the same.

SQL Server 2014 SP3 12.0.6024.0
SQL Server 2016 SP2 13.0.5026.0
SQL Server 2017 14.0.1000.169
SQL Server 2019 15.0.2000.5

Check that the variable is selected by [ Server Collation ].

../../../_images/image1110.png