<< MCITP roadmap begins | Home | The Web Server war >>

Hide a SQL Server 2005 Instance

This is a problem that a customer had in these days: how can I hide a SQL Server 2005 Instance?

Very few SQL admins knows that with SQL Server 2005 you can hide a specific instance while the others still remain visible. In oder to make a SQL 2005 instance as "hide", you've to follow these steps:

  1. Open SQL Server Configuration Manager and expand the SQL Server 2005 Network Configuration node
  2. Right Click on Protocol for  and then select Properties
  3. In Flag pane there's a field called HideInstance. You've to change this flag from No to Yes.

That's all. Now your SQL instance will be hide (it's not viewable via SQL Browser Service).

P.S. You can still connect to the hide instance by specifiying protocol , Server name/IP address and port number or the named pipe directly.

Technorati Tag:

Print | posted on Tuesday, February 06, 2007 11:12 AM

Comments on this post

# Is the Mac Really Safer Then a PC

Requesting Gravatar...


Everyone claims the mac is safer but realisticly isn't it less safe because most people on a mac are not as cautious as pc users. Pc users are running software firewalls to see what connections are coming in and out, sandboxing type software and other security type programs.
If someone personally knows you are on a mac seems they could target you better since they know you proably won't be looking for anything out of the ordinary.

What do you guys think

Left by MayGirrl on May 10, 2007 5:15 AM

# replica jewelry

Requesting Gravatar...
If someone personally knows you are on a mac seems they could target you better since they know you proably won't be looking for anything out of the ordinary.
Left by replica jewelry on Apr 29, 2010 4:23 AM

# re: Hide a SQL Server 2005 Instance

Requesting Gravatar...
ll remain visible. In oder to make a SQL 2005 instance as "hide", you've to follow these steps:

1. Open SQL Server Configuration Manager a laptop battery china and laptop adapter china.
Left by wholesale laptop adapter on May 23, 2010 2:27 PM

# clothing manufacturer

Requesting Gravatar...
f someone personally knows you are on a mac seems they could target you better since they know you proably won't be looking for anything out of the ordinary
Left by clothing manufacturer on Mar 06, 2011 3:36 PM

# re: Hide a SQL Server 2005 Instance

Requesting Gravatar...
That is what i was looking for.
Now i can hide my SQL, works for me:)
How about You?
Left by Rollladen on Jun 08, 2011 12:00 PM

Your comment:

 (will show your gravatar)
 
Please add 4 and 8 and type the answer here: