Configuring Language Setting for SQL Server Users

The purpose of this topic is to describe how to configure the language setting for SQL Server users.

Depending on your geographic location, you may need to modify the default language setting for your SQL Server to support your country's regional settings (such as the local date/time format).
Follow these steps to modify SQL Server's default language for new SQL Server logins that you create and to modify any existing logins you have already created:

  1. Open Microsoft SQL Server Management Studio and connect to the SQL Server that will host Aptify.
  2. Right-click the SQL Server in the Object Explorer and select Properties from the pop-up menu to open the Server Properties dialog.

    Access SQL Server Properties

  3. Open the Advanced page of the Server Properties dialog.

    Change SQL Server's Default Language
  4. Select the appropriate language from the Default Language drop-down list. 
  5. Click OK to save your changes and close the Server Properties dialog.
  6. If any logins already exist on the SQL Server (such as the sa user), modify the Default Language selection for these logins as necessary.
    1. Expand the server's Security > Logins heading in the Object Explorer.
    2. Right-click a login and select Properties to open the Login Properties dialog.

      Modify User's Default Language
    3. Select the appropriate language from the Default language drop-down list. 
    4. Click OK to save your changes and close the Login Properties dialog.
  7. Configure the Regional Options for each user's desktop computer to match the Default language specified for his or her SQL Server Login.
    • The Regional Options dialog is typically located in Start > Control Panel > Regional and Language Options.
Was this article helpful?
0 out of 0 found this helpful



Please sign in to leave a comment.