SSMS Server Custom Colours not working

  • Hi All,

    Has anyone had problems with using the custom colours feature on SSMS 2016? I selected different colours for our servers we have here, mainly so I can easily tell if I'm on Live, UAT, DEV and Test, and most of the time the colour of the bar at the bottom is always the same. The most annoying part as well, i it's not even any of the colours I've selected, it's a very dark blue! So dark I can't actually read the text at the bottom.

    I decided to reset all my custom colours, but it's still coming up in this dark blue. Does anyone know how to get it back to the default colour? It's really quite frustrating now. I assume there's a option for it in Options->Environment->Fonts and Colours, but I'm yet to find it.

    Can anyone help me? If you can advise how to get the bar colouring working as intended as well, that would be great!

    Thanks 🙂

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • It's working for me here :ermm:

    The default colour is set here:

    You don't have any add-ins/extensions do you ?

    MM



    select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

  • Forum Etiquette: How to post Reporting Services problems
  • [/url]
  • Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
  • [/url]
  • How to Post Performance Problems - by Gail Shaw
  • [/url]

  • On SSMS 2016, no. My Options->Editor Tab and Status Bar -> Single server connections is even set to Khaki, but it's still this really dark blue! 🙁

    I've even uninstalled and reinstalled, but that kept all my settings... Obviously a classic MS "uninstall", where actually it just removes the binaries -_-

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • You could try deleting the user data from %LOCALAPPDATA%\Microsoft\SQL Server Management Studio\13.0

    This is a bit like a "Reset To default" for SSMS, so expect to lose settings - but that's probably good for you.

    be aware that "user extensions" are located in there as well, so you would need to re-install any.

    MM



    select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

  • Forum Etiquette: How to post Reporting Services problems
  • [/url]
  • Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
  • [/url]
  • How to Post Performance Problems - by Gail Shaw
  • [/url]

  • I ended up fixing it by changing the colour of every server in my registered servers. It seems that if you simply use Ctrl+N to create a new query, it just picks up the colour of the server at the top of the list, which it appears SSMS thought was horrid dark blue. It's now a pale blue. All my status bars are now pale blue (and when i right click the server and select new query, the correct colour), but it's better than nothing.

    Seems that the custom colours feature is still a dream 🙁

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

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

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