Monday, May 4, 2015

How to hide my SQL Server instance in network ? TIP #99


In TIP #70  we saw how to find all the running SQL SERVER instance in a network or a machine.

to revise see below image.


This tip is just opposite to tip #70 you don’t want that your co-worker see your SQL Server instance running on your machine machine. (There are several reason behind this Smile  and security is one of the most valuable aspects)

To achieve this you just need to do a very simple setting. Just follow below steps

1) Open “SQL SERVER Configuration Manager”


2) Once the screen is open right click on the instance which you want to hide from network (under  SQL SERVER network  configuration ) as shown below


3) When you click on Properties menu you will get a new screen as shown below

You need to set the value of Hide Instance option to Yes.


4) Click on apply button and restart the services.

Great , We achieved it. Isn’t it simple ?

I appreciate your feedback.




  1. This just prevents the server from showing up in the drop down. In reality, all it does is move the SQL Server listening port to tcp/2433.

    As a result, attackers and security pros alike know to scan for both tcp/1433 and tcp/2433 when looking for SQL Servers.

  2. This aludo prevent the correct function of fail over cluster