Docs

RDS for SQL Server

FAQ

How to change the locale of rds for sql server?

This article describes how to modify the SQL Server locale to Chinese.

Modify the default locale of an instance through the SQL Server console

This method only works for newly created accounts, and the created accounts are still in the language environment before modification. To modify the locale of a created account, see Modifying the default locale of an instance account via SSMS.

Gets the value of the instance parameter default language when changing the locale of the instance to Simplified Chinese:

Connect the instance via SSMS. For more details, see Connection instance.

Open a session and execute the following command to view the value in Simplified Chinese:

EXEC sp_helplanguage;

The expected output is shown in the figure below, which shows that the value of the instance parameter default language is 30 when the locale is Simplified Chinese.

Sets the value of the instance parameter default language.

In the upper left corner of the top menu bar, select the project and region to which the instance belongs.

In the left navigation bar, click Instance List.

On the Instance List page, click the name of the target instance.

On the target instance details page, click Parameter Configuration.

On the parameter configuration tab, modify the parameter run value column of the parameter default language parameter run value column of the parameter default language to 30.

Click Submit at the top left of the page, confirm Modify instance parameters? Dialog box Click OK.

Modify the default locale of the instance account through SSMS

This method can modify the default locale of the specified account.

Connect the instance via SSMS. For more details, see Connection instance.

In the left navigation bar, select Security > Logins.

Right-click the target account and click Properties.

On the Properties page of the login account, set the Default language.

Set Default language to Simplified Chinese - Simplified Chinese.

Click OK.

After completing the modification, you need to reopen a session to verify that the locale modification was successful.

Modify the locale of the current session via SSMS

This method can only modify the locale of the current session and does not apply to reopened new sessions.

Connect the instance via SSMS. For more details, see Connection instance.

Execute the following command to modify the locale of the current session:

SET LANGUAGE 'Simplified Chinese';

Execute the following command to verify that the locale of the current session was successfully modified:

SELECT DATENAME (weekday, GETDATE ()) AS'Today is';

Last updated: 2025.06.30 17:03:56