Hiding a SQL Server Instance !


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.

Process 

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.

Conclusion

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.


About these ads

2 thoughts on “Hiding a SQL Server Instance !

  1. Interesting technique, that might even help your security. It might slow down hackers, or scare away scripters. Certainly “powerusers” that try to sniff your network for “interesting stuff and servers”. Nice short article showing a setting I never saw before. Compliments! ;)

    • Thank you for taking time to pass on your feedback,really happy about it.

      I actually did verified with some security experts and they confirmed that it might not potentially prevent a hacker as they have various ways,but it will really slow them down !

      As you said,Its really a good feature to hide key servers from users who are just interested to see what is around.

      Thanks again !

Leave a Reply

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

WordPress.com Logo

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

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s