Today I accidently came across the option called ‘Hide Instance’ flag for a SQL Instance.
This property looked pretty useful for me in case I don’t want anyone to browse for my SQL Instances easily.
There are many ways by which you can browse all the SQL Instances. One way is when using SSMS to connect to an Instance.
A look up on Network Servers will show you all the servers within the same domain. In this case we will concentrate in instance SQL2012A which runs SQL Server 2012 edition.
If you set the Hide Instance option as Yes for this instance, then that will prevent the SQL Server Browser service from exposing this instance of the Database Engine to client computers.
You will need to recycle the Engine services after setting this flag as True.
Once the service is recycled this takes into effect and the instance SQL2012A will no longer will be available for browse.
I have never seen this flag being set as a part of security best practices; however I would really focus on this point and will check with few SQL experts if they have similar experience.
Thanks for reading.