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. Read on.

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 dropdown 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 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 flags

 

The dialogue 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 that is browsing your network.

6 thoughts on “How To Hide an Instance of SQL Server”

  1. Beware that there is a problem with this scenario for named instances and SQL2016, where the SQL Server Agent service stops. Microsoft is aware of this issue.

    Reply
  2. I believe it is too early for that. It has to do with the release of SQL2016/CU7+KB4057119 (the security patch released as CU7). We have an open Microsoft support case, but it has not yet been reported/confirmed as a bug.

    Reply
  3. We have noticed that the instance will not stay hidden. It reappears after awhile and the only way to hide it again is to restart the sql browser service but again it is only temporary.

    Reply

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.