Do you have a comment or suggestion to improve SQL Server? We’d love to hear it!

← SQL Server

SSMS 18.2 default language display bug

Hi, SSMS 18.2 displays the default language for all logins as Arabic, and my default language is us_english.

I'm using language 1033 so this shouldn't display as Arabic. I tried with a few servers - all the same. This is across all versions of the database engine from 2008, 2012, 2014, 2017 etc.

querying sys.server_principals shows this isn't actually the case so this seems to be display bug in SSMS 18.2

39 votes
Sign in
(thinking…)
Sign in with: Microsoft
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close

We’ll send you updates on this idea

Brent McCracken shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

10 comments

Sign in
(thinking…)
Sign in with: Microsoft
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Phil Breeze commented  ·   ·  Flag as inappropriate

    Discovered this myself yesterday when creating a new SQL user which was assigned Arabic as the default language. Consequently couldn't login with the assigned password!
    Never bothered to set the language in the past as it simply used to inherit the server default so to say it only affects what you see in the UI is not entirely correct.

  • Simon commented  ·   ·  Flag as inappropriate

    Just came accross this bug today and was thinking i was going crazy as all my server logins appeared to be wrong default language!
    - querying server_principals brought the stress level down a touch;
    SELECT default_language_name , name
    FROM master.sys.server_principals

    PLEASE FIX!

  • Randy Hartwig commented  ·   ·  Flag as inappropriate

    Hey MS Guys - This post and followup comments was a month ago; it would be nice if you would have written a post right there under the 18.2 Release Download that mentioned this Arabic issue is benign so others dont waste their time finding it, then thinking there could be a problem related to data, Logins, Linked Servers, data translations and so on. Thank for letting us research this on our own, reverting 18.2 installs back to an older versions of SSMS before finding this link when you already knew about but could have told everyone.

  • Tim commented  ·   ·  Flag as inappropriate

    I just installed it and had the same issue. If I use SSMS on another PC, it displays the default language correctly.

SQL Server: Bugs

Categories

Feedback and Knowledge Base

(thinking…)
Hosted by UserVoice