SQL Server

Overview

Overview

This menu installs SQL Server on a Windows Server service Official Template and provides it.
Please refer to Windows Server Service Descriptions for Windows Server.

SQL Server

  • Provision of official image templates

    • SQL Server official image templates, which can be used on a Virtual Server and Dedicated Hypervisor are provided.

  • Provision of the provider license

    • SQL Service license is provided based on the SPLA (Service Provider License Agreement).


Servers/Dedicated Hypervisor that can use SQL Server

  • There are 2 methods to use SQL Server on a server/Dedicated Hypervisor. One is to use an official image template, and the other is for the customer to bring their own SQL Service license and installer.

  • BYOL does not fall within this menu’s coverage.

  • The method to use each server/Dedicated Hypervisor SQL Server is as follows.

OS usage form

Server/Dedicated Hypervisor

 
 

Baremetal Server

Virtual Server

Hyper-V vSphere ESXi

Official Image Template

N Y Y Y

BYOL

Y Y※1 Y Y

*1 BYOL of SQL Server license to a Virtual Server environment is possible only when there is license mobility based on software assurance.


Menu Features

  • On-Demand

    • Customers can subscribe for an SQL Server official image template on a Virtual Server via the Customer Portal.
      *Please refer to the below Service Descriptions for the usage method with Hyper-V and vSphere ESXi. Service Specifications - Guest Image
  • Immediate Start of Service

    • Customers can immediately start using the SQL Server without procuring the provider license on their end.


AVAILABLE FUNCTIONS/SERVICES

Overviews of Available Functions And Services

  • An Official Template, which starts the automatic installation of the SQL Server, is provided.

NOTE: If customers wish to set the OS language in Japanese, they must set the language via the control panel on their own.


Available Product Names And Versions

For information on the products available in this menu, check This PDF file .


Official Image Template

The official image template provided in this menu, check This PDF file . SQL Server license is applied by using this official image template.


List of Available Functions

  • List of Functions provided with this menu’s official image template is as follows:

Functions

Details

Initial Username Settings

Please refer to following URL in order to follow the setting for the Windows Server service .

Initial User Password Settings

Please refer to following URL in order to follow the setting for the Windows Server service .

Locale Settings

The locale setting depends on the language of SQL Server. For details, refer to the following.

Security setting (Windows Firewall setting)

Please refer to following URL in order to follow the setting for the Windows Server service .

Dedicated tool setting

Please refer to following URL in order to follow the setting for the Windows Server service .

Other Initial Settings

Please refer to following URL in order to follow the setting for the Windows Server service .

.NET Framework3.5.1 setting

When installing SQL Server 2014, add the functionality of .NET Framework 3.5.1.

SQL Server Setting

Install as per the following SQL Server setting.

Locale Settings

  • The settings of OS’s Country or Region / Keyboard layout are as follows.

Functions

SQL Server 2014 English

SQL Server 2016 English

SQL Server 2017 English

SQL Server 2019 English

SQL Server 2014 Japanese

SQL Server 2016 Japanese

SQL Server 2017 Japanese

SQL Server 2019 Japanese
Country or Region US JP JP
Keyboard layout US US* JP**
*The keyboard layout at the time of initial installation is set to US. Please change as necessary.
**The Keyboard layout will be US when the password is set at the first startup and when SQL Server is installed.

SQL Server Setting

  • Install the SQL Server setting as per the following settings.


SQL Server version

When installing SQL Server with the default instance name MSSQLSERVER

When installing SQL Server with any instance name other than the default instance name

SQL Server 2014

Please check This PDF file .

Please check This PDF file .

SQL Server 2016

Please check This PDF file .

Please check This PDF file .

SQL Server 2017

Please check This PDF file .

Please check This PDF file .

SQL Server 2019

Please check This PDF file .

Please check This PDF file .


Value that can be selected as the inquiry sequence for the database engine

SQL Server version

 
SQL Server 2014

Please check This PDF file .

SQL Server 2016

Please check This PDF file .

SQL Server 2017

Please check This PDF file .

SQL Server 2019

Please check This PDF file .


SQL Server Management Studio

In SQL Server 2016 and SQL Server 2017 and SQL Server 2019, SQL Server Management Studio is not installed when installing SQL Server.

Install and provide the version of SQL Server Management Studio described in this PDF file .

If necessary, please download the latest version from the download page of Microsoft Corporation and install it.


SQL Server Reporting Services

In SQL Server 2017 and SQL Server 2019, SQL Server Reporting Services is not installed when installing SQL Server.

In the official image template provided by this service, install SQL Server Reporting Services and provide it.


Subscriptions Methods

In Case of Virtual Server

  • New Subscription:
    Please specify the below Image Template when creating a Virtual Server.

Virtual Server

SQLServer-2014_SP3_Standard_64_English_include-license_WindowsServer-2012R2_Standard_64_include-license_virtual-server_042
  SQLServer-2014_SP3_Standard_64_Japanese_include-license_WindowsServer-2012R2_Standard_64_include-license_virtual-server_042
  SQLServer-2016_SP2_Standard_64_English_include-license_WindowsServer-2012R2_Standard_64_include-license_virtual-server_042
  SQLServer-2016_SP2_Standard_64_Japanese_include-license_WindowsServer-2012R2_Standard_64_include-license_virtual-server_042
  SQLServer-2016_SP2_Standard_64_English_include-license_WindowsServer-2016_Datacenter_64_include-license_virtual-server_002
  SQLServer-2016_SP2_Standard_64_Japanese_include-license_WindowsServer-2016_Datacenter_64_include-license_virtual-server_002
  SQLServer-2017_Standard_64_English_include-license_WindowsServer-2016_Datacenter_64_include-license_virtual-server_002
  SQLServer-2017_Standard_64_Japanese_include-license_WindowsServer-2016_Datacenter_64_include-license_virtual-server_002
  • Termination
    Please delete the Virtual Server, which was created with an SQL Server official image template.

In Case of Dedicated Hypervisor

  • New subscription method/termination subscription method

Please refer to the Dedicated Hypervisor Descriptions. Service Specifications - Guest Image


Conditions With Usage

Conditions of Usage in Combination with Other Services

  • This menu must be combined with either two menus:

    1. Customers must subscribe for a set with a Virtual Server.

    2. Customers must first subscribe for Dedicated Hypervisor and then subscribe for this menu.

  • If the customer is to use the SQL Server service, the service must be provided along with the Windows Server service.

  • Combination conditions for the Windows Server service also apply to this menu.
  • Please refer to Service Descriptions - Windows Server for details.

Minimum Use Period

  • This menu does not have a minimum use period.


Pricing

Initial Fee

There is no initial fee required in this menu.


Monthly Fee

  • The pricing system differs for each server/Dedicated Hypervisor.


Virtual Server

  • Billing Structures
    The fee is charged based on the Virtual Server flavor.
    If the customer uses multiple flavors within the month, the cost will be based on the flavor with the largest number of vCPUs.
  • Billed Items
    Instance, to which the volume containing the SQL Server license is attached.
    *If there are multiple volumes containing this menu’s official image templates attached to one Instance, the cost for this menu will be added according to the number of volumes. *Please refer to the below Service Descriptions for the relationship between Instances and volumes and Virtual Server Instance flavors. Service Descriptions - Virtual Server

Dedicated hypervisor

  • Billing Structures
    The fee is charged based on the number of vCPUs of the guest OS.
    If the customer changes the number of vCPUs within the month, the cost will be based on the largest number of vCPUs.
  • Billed Items
    Guest OS, which is booted even once within the month, shall be a target.

Support

Support Coverage

Supported Official Image Template

  • The virtual server created from the image template and the virtual machine on the dedicated hypervisor described in This PDF file are targeted.

  • If a new SQL Server service pack is released, official image templates, to which the latest service pack is applied, will be provided.

  • Provision of official image templates with a service pack, which no longer has the extended support, will be terminated.


Support Period

SQL Server version and edition

Start Support

End Support

End date of the extended support

SQL Server 2014 Standard Edition 2014/06/05 2019/07/09 2024/07/09
SQL Server 2016 Standard Edition 2016/06/01 2021/07/13 2026/07/14
SQL Server 2017 Standard Edition 2017/09/29 2022/10/11 2027/10/12
SQL Server 2019 Standard Edition 2019/11/04 2025/01/07 2030/01/08

*The displayed support end date is for products, to which the latest service pack has been applied.

SQL Server service pack

Start Support

Service pack support end date

SQL Server 2014 SP1 2015/04/14 2017/10/10
SQL Server 2014 SP2 2016/07/14 2020/01/14
SQL Server 2014 SP3 2018/10/30

Support ends 12 months after the next service pack releases or at the end of the product’s support lifecycle, whichever comes first.

SQL Server 2016 SP1 2016/11/16 2019/07/09
SQL Server 2016 SP2 2018/04/24

Support ends 12 months after the next service pack releases or at the end of the product’s support lifecycle, whichever comes first.


Support Method

  • This menu offers support with initial setting, initial login to the server, and OS license authentication.

  • This menu supports the initial installation of SQL Server.

  • Even in the event that Customers request Support with regards to the reports of failure, errors or any troubles Customers face at installation, Setup, basic functioning, NTTCom will not activate Support Service (which includes investigation, troubleshooting, and technical advice).


Qualities of Operations


Region

The provision regions of this menu are as follows.

 

Country

Region

Virtual Server

Japan, Hong Kong, UK, USA, Singapore, Germany, Australia, France

JP1,JP2,JP4,JP5,JP6,HK1,UK1,US1,SG1,DE1,FR1
Hyper-V

Japan, Hong Kong, UK, USA, Singapore, Germany, Australia, France

JP1,JP2,JP4,JP5,JP6,HK1,UK1,US1,SG1,DE1,FR1
vSphereESXi

Japan, Hong Kong, UK, USA, Singapore, Germany, Australia, France

JP1,JP2,JP4,JP5,JP6,HK1,UK1,US1,SG1,DE1,FR1


The following official image templates are limited to be provided region. The provided region is as follows.
OS SQL Server
Windows Server 2016 Datacenter Edition SQL Server 2016 SP2 Standard Edition
Windows Server 2016 Datacenter Edition SQL Server 2017 Standard Edition

Country

Region

Japan, Hong Kong, UK, USA, Singapore, Germany, Australia, France

JP1,JP2,JP4,JP5,JP6,HK1(GroupA),UK1,US1,SG1(GroupB),DE1(GroupA,GroupC,GroupD),FR1

Restrictions

Performance Guarantee

  • This menu does not guarantee performance. Depending on the accommodation situation, this menu may not demonstrate sufficient performance.


Fail-over Repairs

  • In the event of a virtual machine failure, NTT Com is not responsible for recovering the virtual machine, all installed software and data.


Services Provider Use Rights

  • Utilizing this menu implies that the customer has agreed to the Services Provider Use Rights (SPUR). Please refer to the following URL for details.

Microsoft Services Provider Use Rights (SPUR):
Please refer to the latest version of Services Provider Use Rights (Worldwide) (Japanese).

Windows Server

  • This service is to be used along with the Windows Server service. Please refer to the restrictions in the [Under preparation: Dedicated Hypervisor release] Service Descriptions Ver. 1.0 - Windows Server (Release Version), due to the fact that the restrictions for the Windows Server service also apply to this service. <https://ecl.ntt.com/documents/service-descriptions/OS/rsts/windows.html>


SQL Server

  • In this menu, only one Instance can be used on 1 virtual machine.

  • Due to the constraints of SQL Server Standard Edition, there is a limit on the number of vCPUs available for one instance as SQL Server. SQL Server 2014 is limited to 4 sockets or 16 cores whichever smaller, SQL Server 2016 and SQL Server 2017 and SQL Server 2019 to 4 sockets or 24 cores whichever is smaller.

*The number of vCPUs, which are not being used by the SQL Server, will also be charged based on the number of vCPUs that are recognized as OS.

  • Since the SQL Server is installed at the time of the initial boot, please do not perform operations that would stop the process (powering off, resetting, shutdown, suspending, and restarting the Virtual Server and closing the SQL Server setup screen) until the installation is completed.

*If the installation process is stopped, the customer must delete the Virtual Server and re-create it. When this happens, the deleted Virtual Server will also fall under the scope of the cost.

-Do not forcibly terminate the Powershell screen executed at the first start with Ctrl + C. In case of forced termination, instance name is MSSQLSERVER, database engine collation order is installed as SQL _ Latin 1 _ General _ CP 1 _ CI _ AS for English version, and Japanese _ CI _ AS for Japanese version.

  • Instance name cannot be changed after the completion of the SQL Server installation.

  • Database engine inquiry sequence cannot be changed after the completion of the SQL Server installation.

  • Customers cannot copy the server, on which the SQL Server installation has been completed.

*Please create it 1VM at a time based on the official template.

  • SQL Server can not be translated into Japanese even when the Windows Server is made Japanese. Please use the official image template in which the Japanese version of SQL Server was installed beforehand when using SQL Server in Japanese.

  • Backup services (file backup, file restore, system backup, system restore) can not be used for this menu according to the backup service specifications.

  • When using SQL Server 2016 and SQL Server 2017 and SQL Server 2019, the function of PolyBase query service for external data can not be used.

Support Period

  • Support is not provided to products, on which Microsoft’s support has run out. No extension is given to the support period.