SSMS 17 Tools > Options > Environment > Fonts and Colors missing Display items
In a generic SSMS 17.2 install on a Windows 7 64-bit workstation, if I open Tools > Options > Environment > Fonts and Colors, I only get 3 items in the 'Display items:' list: Plain Text, Selected Text, and Inactive Selected Text. I have no options to change anything else. In my SSMS 2016 install, I have over 200 items in the 'Display items:' pick list. Comparison screenshot here: https://imgur.com/a/XiGMm
I have tried resetting all settings to default in the Import and Export Settings Wizard. No change.
Could you check if “C:\Program Files (x86)\Microsoft SQL Server\140\Tools\Binn\ManagementStudio\1033\Microsoft.DataWarehouse.VsIntegration.rll” is missing from your machine?
If it is, you may try two things (either one) to alleviate the pain:
1) Locate ssms.pkgundef (typically at “C:\Program Files (x86)\Microsoft SQL Server\140\Tools\Binn\ManagementStudio\ssms.pkgundef”)
Edit it and add a line line this at the bottom:
[$RootKey$\FontAndColors\Data Warehouse Designer]
2) Grab the missing file from a machine running the same version of SSMS (it could be a temporary VM with just that binary)
It would be helpful if somebody could share (OneDrive or equivalent) the content of the TEMP\SSMSSetup folder (that’s the history of the SSMS setup): it may reveal useful info for us.
Note: there may be sensitive information in those log files (machine names, path names, etc…), so use your best judgement.
Thanks much, this was really annoying. Added line to ssms.pkgundef , closed/reopened and worked as expected. Thanks!
Gavin Paolucci-Kleinow commented
I'm experiencing this problem and “C:\Program Files (x86)\Microsoft SQL Server\140\Tools\Binn\ManagementStudio\1033\Microsoft.DataWarehouse.VsIntegration.rll”does not exist on my machine, though Microsoft.DataTransformationServices.VsIntegration does.
Dmitry Kolchev commented
I solve this problem using this way:
1. uninstall any versions of SSMS
2. install SSMS 17.1 from https://docs.microsoft.com/en-us/sql/ssms/release-notes-ssms?view=sql-server-2017#previous-ssms-releases
3. upgrade to the latest vesrsion from https://docs.microsoft.com/en-us/sql/ssms/release-notes-ssms?view=sql-server-2017#1791-latest-ga-release
I'm in the US, Server is in the US, Tenant is in the US, all Users are in the US, not an e-Com Site, and the only PII in the entire DB is an email address, maybe (not required). Therefore, no GDPR, I believe,
Henry Wyckoff commented
Option 1 worked for me. I used Notepad++ in admin mode to add the one line. Closed SSMS and reopened. Now I can see the full list of font options.
Can gladly share the folder content, but with 41 files and 55MB, I don't have time to edit every file... Could you provide a secure, one-time, upload path, perhaps, please?
Mario Ramos commented
How many years do you need to fix this?? First at all, why did you change the whole environment when the only thing that it was required is the use of the new SQL Server Client, and some special features, like the xEvent profiler??
Yes, PLEASE fix this. I have the same four options in the 'Show Settings For' dropdown; 'Text Editor' is missing. Thanks!
Steve Malcolm commented
As of 17.9.1 this has yet to be fixed and that truly sucks.
Yes please fix this as it seems to be an issue with SSMS installed on a server. The results are way too small to be shown on a projector and would like to be bigger please
Gavin Paolucci-Kleinow commented
I'm experiencing this issue right now. Can we please get a resolution for this?
Arian Papillon commented
Same issue with 17.9.1
Rob Wittner commented
I'm seeing this problem on more than a half-dozen installs on Windows 10. Install Windows 10, then install Visual Studio 2017 Pro, then SQL Server Express + SSMS. Result: minimal customization options. This has been going on for months. Please fix this!
Henry Wyckoff commented
Same problem here. I tried the steps shown here (https://docs.microsoft.com/en-us/sql/ssms/sql-server-management-studio-changelog-ssms?view=sql-server-2017#uninstall-and-reinstall-ssms-17x) and the symptom did not go away.
Mikael Wedham commented
I also have had the same issue. And still do. Installed yesterday with same result.
The things available in Options - Fonts and Colors are:
[All Text Tool Windows]
[Watch, Locals, and Autos Tool Windows]
Importing settings from a really old SSMS where I could change and export works, but I would really like to be able to change the settings myself.
1. I installed a lot of versions up to ( and including 17.9) on a Clean reset Windows 10 OS.
2. I have upgraded also on other Machines - only full install package.
Never uninstalled and reinstalled. I reset the entire OS.
David Austin commented
What does it take to get this fixed?
This is a simple bug.
It's now 5 months later and no update.
John Perry commented
Just updated to 17.9 and I can confirm also, still No "Text Editor" in the drop down.
As requested here is a screen capture of the drop down...
Most certainly I can confirm it. I see it persisting, 15 feet away, too, on my colleague's broken SSMS Install - no "Text Editor" options at all for her. Screen Shot on OneDrive here: https://1drv.ms/u/s!AmPbuTXzClJ7gdYvvK7lNdsjSyoZ5g
SAME ISSUE - brand new Windows Server 2016 Standard. Added SQL 2017 Developer. Added SSMS 17.0 (becuase of this very issue on other boxes), then 17.6. NO TEXT EDITOR FONTS AND COLORS! Updated to 17.7 - SAME! Uninstalled, rebooted, reinstalled 17.7 full - SAME: NOTHING!
Uninstalled - again!
Installed SSMS 16.5.3 - THERE THEY ARE!!!
Installed 17.7 - there they ARE NOT!!!
Why, oh why, oh why, cannot a simple install do what it is supposed to...
PROBLEM HAS BEEN ONGOING SINCE v17 came out. Some of my team are utterly exasperated with this foul up and resigned to zero customization, the worst of which is being STUCK with a glaring white query background. That is no fun...
Please fix this once and for all...