Hiding the SQL Server over the network...

Hiding the SQL Server over the network...

Hiding the SQL Server over the network...

As you can see all of my instances are visible on the network. If I want to hide this information from people on my network, it can be done easily. SQL Server allows us to hide an instance from being listed on the network. This can be done using SQL Server Configuration Manager.

For example, If I need to hide my SQL Server instance TIRU01

1. Launch SQL Server Configuration Manager

2. Under "SQL Server Network Configuration" > Right-Click "Protocols for TIRU01" > Select Properties

3. Set "Hide Instance" value to "Yes" from the drop-down list:

4. restart the SQL Server instance TIRU01 to take effect

5.After the restart , the instance is restarted it will not longer appear in the "Network Servers" list: