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_SP2_Standard_64_English_include-license_WindowsServer-2012R2_Standard_64_include-license_virtual-server_042

Virtual Server

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

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_SP2_Standard_64_English_include-license_WindowsServer-2012R2_Standard_64_include-license_gen2_Hyper-V_002
Hyper-V SQLServer-2014_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-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_SP2_Standard_64_English_include-license_WindowsServer-2012R2_Standard_64_include-license_hw9_vSphere-ESXi_002
vSphereESXi SQLServer-2014_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-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

9.3.1.1. Procedure Flow : SQL Server Installation

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

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

Make sure “Final result” is “Passed”.

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

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

Open Windows Powershell.

Input [ ssms ] and click [ Enter ].

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 SP2 12.0.5000.0
SQL Server 2014 SP3 12.0.6024.0
SQL Server 2016 SP2 13.0.5026.0
SQL Server 2017 14.0.1000.169

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

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