Menu & Search
Using Custom Connection Colours in SSMS

Using Custom Connection Colours in SSMS


SSMS has an option that allows you to change the colour of your query banner, which is useful if you want visually mark a server that you work with every-day.

A while back, when I was frequently switching between live & test SQL instances, I set them to red/green. Red obviously meaning be cautious!

Nowadays, I think it’s unlikely you’ll have line-of-sight to both production & test environments from the same location (where your SSMS is installed). So, if I’m honest, this isn’t a feature I find myself using all that often.

I thought I’d post it up for a laugh anyway. Follow the steps blow to make the change.


1. Click to connect to a SQL Server instance within SSMS.

2. Click Options.

3. Within the Connection Properties tab, check the box to use custom colours and select your preference.

4. Open a new query window to view the change.