Over a million developers have joined DZone.
{{announcement.body}}
{{announcement.title}}

How to Hide an Instance of SQL Server

DZone's Guide to

How to Hide an Instance of SQL Server

If you have ever wanted to hide an instance of SQL Server, this is the post for you.

· Database Zone ·
Free Resource

Compliant Database DevOps and the role of DevSecOps DevOps is becoming the new normal in application development, and DevSecOps is now entering the picture. By balancing the desire to release code faster with the need for the same code to be secure, it addresses increasing demands for data privacy. But what about the database? How can databases be included in both DevOps and DevSecOps? What additional measures should be considered to achieve truly compliant database DevOps? This whitepaper provides a valuable insight. Get the whitepaper

When you launch SQL Server Management Studio (SSMS), you see the option to connect to an instance. If desired, you have the ability to browse instances running on your network. Just click on the drop-down and at the bottom, there is a Browse for more… option: 

how to hide instance of SQL Server

This allows you to browse for local or network instances. I have four instances running on my laptop. You can see them displayed in this list:

how to hide instance of SQL Server SSMS list

Let’s assume one of these instances is double top-secret and we don’t want users to see the instance name. That’s possible through SQL Server Configuration Manager (SSCM). Open up SSCM and navigate to your SQL Server instances: 

how to hide instance of SQL Server SSCM list

In SSCM, expand SQL Server Network Configuration, right-click Protocols for the instance you want to hide, then select Properties:

how to hide instance of SQL Server properties

On the Flags tab, in the Hide Instance box, select Yes, and then click OK to close the dialog box: 

how to hide instance of SQL Server flagsThe dialog box says to restart SQL to apply the changes, but that is not the case for this specific change. Any new connection will not be able to see this instance listed. Here’s what I see after closing SSMS and trying to browse again:

how to hide instance of SQL Server success

There you go — an easy way to hide your SQL Server instance from anyone who is browsing your network.

Compliant Database DevOps and the role of DevSecOps DevOps is becoming the new normal in application development, and DevSecOps is now entering the picture. By balancing the desire to release code faster with the need for the same code to be secure, it addresses increasing demands for data privacy. But what about the database? How can databases be included in both DevOps and DevSecOps? What additional measures should be considered to achieve truly compliant database DevOps? This whitepaper provides a valuable insight. Get the whitepaper

Topics:
database ,sql server ,tutorial ,ssms

Published at DZone with permission of

Opinions expressed by DZone contributors are their own.

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}