Monday, May 17, 2010

Hide Instance Option in SQL Server

In SQL Server 2005 it is very easy to find in what machines sql server is installed. If you open management studio and browse for server it automatically list all the sql servers. To avoid this and to hide the sql server instance there is an option provided. Follow the below steps to hide instance of an SQL Server
1. open sql server configuration manager
2. right click on protocols under sql server 2005 network configuration
3. select properties
4. on the flags tab -- select hide instance as "Yes"
5. click on Apply and then OK

After that if you search our sql server instance will not visible via network.

No comments: