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
This issue was fixed in SSMS 18.3.1
Phil Breeze commented
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.
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
Kumar Moorthy commented
Is there a newer version of SSMS coming out with a fix. Any ETA ? Thanks !
chris lasecki commented
Is there an ETA for a fix ?
Randy Hartwig commented
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.
I just installed it and had the same issue. If I use SSMS on another PC, it displays the default language correctly.
Anibal Picon commented
Thanks for reporting this. We are on it.
Glenn Burnett commented
I'm also experiencing this issue.
Dave Dustin commented
Can reproduce. Impacts SQL and Windows Logins