Currently Azure marketplace SQL Images are only available in English locale. If you want to change your SQL locale to any other than English, then you can deploy a virtual machine that contains SQL Server initially. We will walk through the steps involved in changing SQL Server language from English to Japanese in this blog.
SQL Server database engine executable file is common to all languages, you can store, extract, and search Japanese data without having to perform the following steps. The default collation of the database can be specified when the database is created. You can explicitly specify the collation of a table column, or if not, the collation of the database is inherited.
If you want to manage from SQL Server Management Studio with a Japanese UI on a remote machine, you do not need to do the following. If you only need the Japanese user interface for administrative tools, you will need to Change locale for SQL Server. The following is an example of SQL Server 2016, but the procedure remains almost the same for other versions of SQL Server:
Uninstall SQL IAAS Extension
From the Azure Portal, navigate to your resource group. Click on your “SQL virtual machine” Resource.
Delete SQL Virtual Machine resource. We are not deleting the Virtual Machine here.
Uninstall SQL Server and its related components.
At the end of this step there are no SQL instance, features or components on this machine. Everything has been uninstalled.
Configure Operating System to Support Localized Versions
Before you can install the Japanese version of SQL Server on an English operating system, you must change the language settings of the operating system. Please follow the below steps:
To change the operating system user interface setting
To change the operating system user locale setting
To change the system locale setting
Installing the SQL Server with your preferred Locale/Language
DefaultSetup.ini
********************
SQL Server 2016 Configuration File
[OPTIONS]
PID:"XXXXX-XXXXX-XXXXX-XXXXX-XXXXX"
PCUSOURCE: ".
********************
The XXXXX becomes the actual product key which we need to use while installing. Start the installation of the Japanese version of SQL Server 2016. (By default, it is mounted on the E drive, so start setup from here.) )
On the Product Key page, you can change the Edition from Evaluation by entering the product key.
For more information about installing SQL, please check Install SQL Server 2016 from the Installation Wizard (Setup)
Reinstall SQL IAAS Extension
Install SQL IAAS Extension . This will sync your billing and the SQL Version/Edition we installed with the Azure Portal.
References
Install non-English language versions of SQL Server Management Studio (SSMS)
Microsoft 2012 SP1 Japanese locale Evaluation
Microsoft 2014,2016,2017,2019 Japanese locale Evaluation Version
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.