SQL Server

Overview

Overview

This menu installs SQL Server on a Windows Server service Official Template and provides it.
For Windows Server services, `Windows Server Details</services/docs/os/service-descriptions/rsts/windows.html> See `_.

SQL Server

  • Provision of official image templates

    • Provides SQL Server official image templates that can be used with server instances and hypervisors.

  • Provision of the provider license

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


About servers / hypervisors that can use SQL Server

  • When using SQL Server as a server / hypervisor, there are two methods: using the official image template, and bringing in the SQL Server license and installer by the customer.

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

  • The method for using each server / hypervisor SQL Server is as follows.

* 1 Only if you have license mobility by software assurance, you can bring the SQL Server license to the server instance environment.


Menu Features

  • On-Demand

    • Customers can apply for the SQL Server Official Image Template on the server instance from the Customer Portal.
      * For details on how to use Hyper-V and vSphere ESXi, see `Guest image detailed information.</services/docs/vsphere/service-descriptions/common/overall.html> See `_.
  • 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.

* If you want to set the OS language to Japanese, you need to set it from the control panel by yourself.


Available Product Names And Versions

For product information available in this menu, see `This PDF file<https://ecl.ntt.com/files/SQLServer/ECL2.0_SQLServer_AvailableProduct_08.pdf> Please check `_.


Official Image Template

The official image template provided in this menu is `This PDF file<https://ecl.ntt.com/files/SQLServer/ECL2.0_SQLServer_AvailableProduct_08.pdf> Please check `_. By using this official image template, the SQL Server license will be applied.


List of Available Functions

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

Functions

Details

Initial Username Settings

To follow the settings of the Windows Server service, `Windows Server detailed information</services/docs/os/service-descriptions/rsts/windows.html> See `_.

Initial User Password Settings

To follow the settings of the Windows Server service, `Windows Server detailed information</services/docs/os/service-descriptions/rsts/windows.html> See `_.

Locale Settings

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

Security setting (Windows Firewall setting)

To follow the settings of the Windows Server service, `Windows Server detailed information</services/docs/os/service-descriptions/rsts/windows.html> See `_.

Dedicated tool setting

To follow the settings of the Windows Server service, `Windows Server detailed information</services/docs/os/service-descriptions/rsts/windows.html> See `_.

Other Initial Settings

To follow the settings of the Windows Server service, `Windows Server detailed information</services/docs/os/service-descriptions/rsts/windows.html> See `_.

.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

`This PDF file</docs/files/SQLServer/SDPF_SQLServer_2014_Configuration_DefaultInstance.pdf> Please check `_.

`This PDF file</docs/files/SQLServer/SDPF_SQLServer_2014_Configuration_NotDefaultInstance.pdf> Please check `_.

SQL Server 2016

`This PDF file</docs/files/SQLServer/SDPF_SQLServer_2016_Configuration_DefaultInstance.pdf> Please check `_.

`This PDF file</docs/files/SQLServer/SDPF_SQLServer_2016_Configuration_NotDefaultInstance.pdf> Please check `_.

SQL Server 2017

`This PDF file</docs/files/SQLServer/SDPF_SQLServer_2017_Configuration_DefaultInstance.pdf> Please check `_.

`This PDF file</docs/files/SQLServer/SDPF_SQLServer_2017_Configuration_NotDefaultInstance.pdf> Please check `_.

SQL Server 2019

`This PDF file</docs/files/SQLServer/SDPF_SQLServer_2019_Configuration_DefaultInstance.pdf> Please check `_.

`This PDF file</docs/files/SQLServer/SDPF_SQLServer_2019_Configuration_NotDefaultInstance.pdf> Please check `_.


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

SQL Server version

 
SQL Server 2014

`This PDF file</docs/files/SQLServer/SDPF_SQLServer_Collation.pdf> Please check `_.

SQL Server 2016

`This PDF file</docs/files/SQLServer/SDPF_SQLServer_Collation.pdf> Please check `_.

SQL Server 2017

`This PDF file</docs/files/SQLServer/SDPF_SQLServer_Collation_2017_01.pdf> Please check `_.

SQL Server 2019

`This PDF file</docs/files/SQLServer/SDPF_SQLServer_Collation_2019_01.pdf> Please check `_.


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.

The official image template provided by this service is `This PDF file</docs/files/SQLServer/SDPF_SQLServer_ManagementStudio_08.pdf> Install and provide the version of SQL Server Management Studio listed in `_.

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

For server instances

  • New Subscription:
    Specify the following image template when creating a server instance.

Server instance

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
  SQLServer-2019_Standard_64_English_include-license_WindowsServer-2019_Datacenter_64_include-license_virtual-server_002
  SQLServer-2019_Standard_64_Japanese_include-license_WindowsServer-2019_Datacenter_64_include-license_virtual-server_002
  • Termination
    Delete the server instance created by the SQL Server official image template.

For hypervisors

  • New subscription method/termination subscription method

`Guest image details</services/docs/vsphere/service-descriptions/common/overall.html> See `_.


Conditions With Usage

Conditions of Usage in Combination with Other Services

  • This menu must be combined with either two menus:

    1. Please apply as a set with the server instance.

    2. After applying for a hypervisor, please apply separately.

  • 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.
  • For more information, see `Windows Server More Information</services/docs/os/service-descriptions/rsts/windows.html> See `_.

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

  • Pricing varies by server instance / hypervisor.


Server instance

  • Billing Structures
    You will be charged according to the flavor of the server instance.
    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 multiple volumes containing the official image template of this menu are attached to one instance, the charge for this menu will be added according to the number of volumes. For more information about the relationship between instances and volumes, and the flavors of server instance instances, see `Server Instance Details.</services/docs/server-instance/service-descriptions/virtual-server.html> See `_.

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

  • `This PDF file</docs/files/SQLServer/SDPF_SQLServer_SupportedOfficialImage_08.pdf> Server instances created from the image template described in `_, virtual machines on the hypervisor 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

  • Support period for the SQL Server, which is provided with this menu’s official image templates, is defined as follows and by Microsoft.

  • For Windows Server support deadline, `Windows Server details</services/docs/os/service-descriptions/rsts/windows.html> See `_.

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

  • The operational quality of this menu conforms to the operational quality specified in the standard for this service. For more information, `Support More Information</services/docs/support/service-descriptions/support.html> See `_.

  • The SLA of this menu conforms to the SLA defined as standard for this service. For more information, `SLA More Information</agreement/> See `_.


Region

The provision regions of this menu are as follows.

 

Country

Region

Server instance

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

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

Hyper-V

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

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

vSphereESXi

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

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


The official image templates for the following combinations of server instances are available in a limited region. The provided regions are 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

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

The official image templates for the following combinations of server instances are available in a limited region. The provided regions are as follows.
OS SQL Server
Windows Server 2019 Datacenter Edition SQL Server 2019 Standard Edition

Country

Region

Japan, Hong Kong, UK, USA, Singapore

JP1,JP2,JP4,JP5,JP6,JP7,HK1(GroupA),UK1,US1,SG1(GroupB)

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 menu is a combined service with the Windows Server service. Since the restrictions of the Windows Server service also apply to this service, `Windows Server detailed information</services/docs/os/service-descriptions/rsts/windows.html> See the `_ restriction.


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 SQL Server is installed at the first startup, do not perform any operation that interrupts the process until the installation is completed (Powered Off, Reset, Shutdown, Suspend, Restart, or close the SQL Server Setup screen of the server instance). ..

* If the installation process is interrupted, you will have to delete and recreate the server instance. In that case, the deleted server instance will also be charged.

-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.