By default, we can see every instance of SQL Server on the network. The network broadcast is what enables the instance enumeration within various management tools where you can utilize a drop down to select an instance.

There are many cases, particularly in production environments, where you want to hide your instance of SQL Server or in other words, where you do not want SQL Server to broadcast its presence.

Hiding an instance is done for security purposes. This would force an attacker to scan IP ranges in an attempt to locate SQL Servers, an action which any network admin should stop dead in its tracks before it gets very far. Unfortunately, the option to disable the broadcast is hidden away.

To disable the broadcast,

1. Launch SQL Server Configuration Manager.
2. Open the Network Configuration section.
3. Right click on the Protocols for the instance you want
4. Select Properties.
5. You will see a flag value labeled Hide Instance.
6. Set this value to Yes.

Regards,

Sarabpreet Singh