Using Korean version of MSSQL

Prev Next

Available in Classic and VPC

Switch installation-type MSSQL to Korean environment

If you use installation-type MSSQL servers in NAVER Cloud Platform, the default environment is set to English. This guide explains how to switch the MSSQL language environment to Korean. You can also switch it to other languages (Japanese, Chinese, etc.) following the same steps.
Follow the sequence below for the switch.

  1. Change the Windows language and system locale
  2. Change MSSQL collation
  3. Install Korean version of SSMS
Caution
  • The tasks in this guide include restarting MSSQL and OS which may impact its services.
  • The MSSQL collation modification task makes changes to the system database, so please make sure to back up the DB and proceed with the task during the time when it would not have impact on the service.
  • The tasks have some risks, so review the content at the Microsoft official web page and make sure you've noted them before you start on these tasks.

Change the Windows language and system locale

Change the language and system locale settings of the MSSQL server created to Korean and Republic of Korea, respectively. You can't install the Korean version of SSMS if this change hasn't been made.

  • Win 2012R2, 2016
    • Click the Control Panel > Clock, Language and Region > Language menu.
      • Set Korean at the top of the priority list.
      • If the language pack is not installed, click Options and install it.
    • Click the Control Panel > Clock, Language and Region > Region menu.
      • Select Home location under the [Location] tab to Korea.
      • Click the [Change system locale...] button under the [Administrative] tab.
      • Select Current system locale as Korean (Korea), and click the [OK] button.
    • Restart the server.
  • Win 2019
    • Click the Windows Settings > Time & Language > Language menu.
      • Set Korean at the top of the priority list in Preferred languages.
      • Click Korean's [Options] button, and install the language pack.
      • Once the Korean language pack is installed, set Windows display language as Korean.
    • Click the Windows Settings > Time & Language > Region menu.
      • Select Korea for Country or region.
    • Click the Control Panel > Clock and Region > Region menu.
      • Click the [Change system locale...] button under the [Administrative] tab.
      • Select Current system locale as Korean (Korea), and click the [OK] button.
    • Restart the server.

Change MSSQL collation

Change MSSQL's collation to Korean. The master database will be rebuilt in the process, so make sure to back up the DB. The following describes how to change it.

  1. Run the CMD (command) program.
  2. Run the following commands to restart the MSSQL server and start the SQL server agent.
net stop mssqlserver
net start mssqlserver
net start sqlserveragent
  1. Go to the Setup Bootstrap folder, according to your MSSQL version.
    • MSSQL 2012
      cd C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\SQLServer2012
    • MSSQL 2014
      cd C:\Program Files\Microsoft SQL Server\120\Setup Bootstrap\SQLServer2014
    • MSSQL 2016
      cd C:\Program Files\Microsoft SQL Server\130\Setup Bootstrap\SQLServer2016
    • MSSQL 2017
      cd C:\Program Files\Microsoft SQL Server\140\Setup Bootstrap\SQL2017
    • MSSQL 2019
      cd C:\Program Files\Microsoft SQL Server\150\Setup Bootstrap\SQL2019
  2. Run the collation switch command.
    .\Setup /QUIET /ACTION=REBUILDDATABASE /INSTANCENAME=MSSQLSERVER /SQLSYSADMINACCOUNTS=administrator /SAPWD=Str0ngUserP@ssw0rd /SQLCOLLATION=Korean_Wansung_CI_AS

Install Korean version of SSMS

SQL Server Management Studio (SSMS) is a GUI-based management tool which is separate to MSSQL Engine. You can download and use the Korean version of SSMS from Microsoft official website for free. Download and use the latest version of SSMS regardless of the MSSQL version.

  1. Disable the IE enhanced security for downloading and installation of the program.
    • Server Manager > Local Server > IE Enhanced Security Configuration > Administrators: Off
  2. Download the Korean version of SSMS from the Microsoft official website and install it.
    • If you have the latest version of SSMS installed on the server, remove the SSMS installed and install the Korean version.
    • You can remove Microsoft SQL Server Management Studio from Control Panel > Uninstall a program.
  3. Set up the SA account's password and login authentication mode.
    • Run the following command in sqlcmd.
  USE [master]
  GO
  ALTER LOGIN [sa] WITH PASSWORD=N'password to set up'
  GO
  ALTER LOGIN [sa] ENABLE
  GO
  EXEC xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer', N'LoginMode', REG_DWORD, 2
  GO