Set custom colors to differentiate between environments in SSMS


Generally we have to shift between different environments within SQL Server Management Studio, as Dev Environment, Staging, Production, resulting in the creation of multiple query tabs. With each query tab connected to different environments. This leads to unmanageable sometimes and difficult to keep track of each environment. To resolve this confusion, SSMS provides us with an ability to set different colors for connection to separate environments. The color is displayed in the SSMS status bar, at the bottom of the window.

Set Custom Colors

  • Connect to a SQL Server instance and click on the Options button.
Fig.1 Connect to SQL Instance
  • Then click on the ‘Connection Properties’ tab and you can choose a custom color for your environment
Fig.2 Choose the color for your environment

Once you select a color for an environment, every time you login to that SQL Server instance, it will display the same color in the SSMS status bar. It’s always nice to have a visual indication of the environment you are logged in.

For my Development Environment I have set Green Color and when I open the query window, the status bar’s color will be in green color.

Fig.3 Example Environment with Status Bar Color


In this article, we have discussed about setting color to our SQL Instance Environment. I hope this tips was very useful. Lets discuss some other tips in upcoming articles. Please share your feedback in the comment section.

Consider reading other SQL articles of Mine

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Website Built with

Up ↑

%d bloggers like this: