SSMS Login Properties can't change default language

  • deubel_m

    Old Hand

    Points: 384

    Hello,

    I have a strange problem with my SSMS 18.2. As you can see in the screenshot the default language is set to arabic, despite the default language is set to english. We checked it from another computer. I can't change it to english either.

    Regards

    Marcus

    • This topic was modified 3 weeks, 4 days ago by  Dave Convery.
    Attachments:
    You must be logged in to view attached files.
  • deubel_m

    Old Hand

    Points: 384

    In addition I get the error when I want to change the default language saying "Login failed for user 'xxx'. Reason: Failed to determine the language and date format while revalidating the login on the connection."

    The error is 18456, Severity 14, State 28

    • This reply was modified 3 weeks, 4 days ago by  deubel_m.
  • DinoRS

    SSCrazy

    Points: 2517

    What does

    SELECT @@LANGUAGE

    return? Is it really english? If so, you can change the default language for logins by TSQL using

    USE [master]
    GO
    ALTER LOGIN [John] WITH DEFAULT_LANGUAGE = English
    GO
  • Andrew P

    SSCarpal Tunnel

    Points: 4479

    Hi deubel_m,

    I was also surprised to see this bug. This has been confirmed by Microsoft and a fix is on the way (no ETA has been stated). Note that logins aren't actually being set to Arabic unless I make a selection from the default language drop-down then re-select Arabic. I can see this by right-clicking a SQL login created through the GUI, Script Login AS, CREATE, and you will see the DEFAULT_LANGUAGE is my expected default language.

    I don't have an issue changing the default language of an existing login. How are you trying to change the default language, through the same drop-down? Is this while you're logged in to the account you are changing?

    Andrew

  • deubel_m

    Old Hand

    Points: 384

    Andrew P wrote:

    Hi deubel_m,

    I was also surprised to see this bug. This has been confirmed by Microsoft and a fix is on the way (no ETA has been stated). Note that logins aren't actually being set to Arabic unless I make a selection from the default language drop-down then re-select Arabic. I can see this by right-clicking a SQL login created through the GUI, Script Login AS, CREATE, and you will see the DEFAULT_LANGUAGE is my expected default language.

    I don't have an issue changing the default language of an existing login. How are you trying to change the default language, through the same drop-down? Is this while you're logged in to the account you are changing?

    Andrew

    Thanks for the info Andrew. Actually I didn't want to change the default language but came across this bug and did some investigation. So I found the error in my logs I mentioned and recognised that the default language can't be changed for any login through the GUI.

     

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply