Login
      Contents x
      Using Korean version of MSSQL
        • Print
        • PDF
        Contents

        Using Korean version of MSSQL

          • Print
          • PDF
          Article Summary

          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
          Was this article helpful?
          What's Next
          Change password!
          Changing your password will log you out immediately. Use the new password to log back in.
          Change profile
          Success!
          First name must have atleast 2 characters. Numbers and special characters are not allowed.
          Last name must have atleast 1 characters. Numbers and special characters are not allowed.
          Enter a valid email
          Enter a valid password
          Your profile has been successfully updated.
          Logout