SSMS英文版本菜单显示意大利语问题求助及相关报错排查

Hey there, I totally get how frustrating it is to have SSMS stuck in Italian when everything else is set to English. Let’s break down the possible causes and fix this step by step—your original Italian Windows 10 with an added English language pack is almost certainly part of the mix here, since system locale settings can sneakily affect app language loading.

Possible Root Causes #

• Your system might still have non-Unicode program locale set to Italian, which SSMS can pick up even if your display language is English.
• Even though you have Visual Studio installed, its language pack might not match SSMS’s requirements, or the language sync between VS and SSMS is broken.
• Residual registry entries or configuration files from the original Italian Windows setup are forcing SSMS to load Italian resources.

Step-by-Step Solutions #

1. Fix Windows System Locale Settings #

This is often the culprit for language mismatches in desktop apps:

• Open Settings > Time & Language > Language & Region
• Scroll down and click Administrative language settings
• In the Administrative tab, click Change system locale
• Select English (United States) (or your preferred English region) and restart your PC
• Also double-check the Region tab: set "Format" and "Location" to an English-speaking region (e.g., United States)

2. Verify and Repair VS/SSMS Language Packs #

The error about missing Visual Studio likely means SSMS can’t access the right English language components from VS:

• Open the Visual Studio Installer, find your installed VS version, and click Modify
• Go to the Language packs section, make sure English is checked, and set it as the default language if the option exists. Click Modify to apply changes.
• For SSMS, run its installer again (you can find it in Apps & features by searching for "SQL Server Management Studio") and select Modify. Ensure the English language pack is selected, then proceed with the repair/installation.

3. Manually Edit SSMS Configuration File #

If the above steps don’t work, force SSMS to use English via its config file:

• Navigate to your SSMS installation directory. For SQL Server 2016, this is typically C:\Program Files (x86)\Microsoft SQL Server Management Studio 17\Common7\IDE (note the version number might vary—adjust if needed)
• Find the devenv.exe.config file, right-click it, and open with Notepad (run as Administrator to save changes)
• Search for the section starting with <userSettings>, then locate this line:

  <setting name="InternationalSettings.UICulture" serializeAs="String">
      <value>it-IT</value> <!-- This will be set to Italian's LCID -->
  </setting>
  

• Change the <value> to en-US, save the file, and restart SSMS

4. Clean Up SSMS Registry Entries (Advanced) #

If all else fails, check for residual language settings in the registry:

• Open Registry Editor by typing regedit in the Start menu (run as Administrator)
• Navigate to HKEY_CURRENT_USER\Software\Microsoft\SQL Server Management Studio\<Your SSMS Version>\General
• Look for a key named UILanguage—set its value to 1033 (this is the LCID for English)
• Repeat the check in HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SQL Server Management Studio\<Your SSMS Version>\General and ensure UILanguage is also set to 1033

Final Notes #

Since your Windows started as Italian, even after adding the English language pack, some system-level settings can linger and override app-specific language preferences. These steps should cover most scenarios where SSMS is pulling Italian resources instead of English.

内容的提问来源于stack exchange，提问作者Al3xI98O