Hiding the SQL Server over the network...
Generally we can browse available SQL Instances on network by choosing "<Browse for More..>" from Server Name drop-down list in "Connect to Server" dialog box in Management Studio:
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:
No comments:
Post a Comment