Your full service technology partner! 
-Collapse +Expand
Search DBA Group:

-Collapse +Expand DBA Store

Prestwood eMagazine

October Edition
Subscribe now! It's Free!
Enter your email:

   ► KBSQL ServersMicrosoft SQ...MS SQL 97 / ...   Print This     
  From the December 2010 Issue of Prestwood eMag
DBA MS SQL 97 / 2000:
What do to when a fresh SQL Server 2005 install can't be accessed from the network
Posted 15 years ago on 5/18/2006 and updated 12/20/2010
Take Away:

Have you installed SQL Server 2005, set all the right SQL Server settings, and still can't browse the server? If you're running XP Pro service pack 2 or later, you may have forgotten to fix this issue at the FIREWALL! (doh!)


You'd think a product as large and important as SQL Server 2005 would be clever enough to either a) punch its own hole in the Windows firewall, or b) at least tell the installer that s/he needs to do something to make the server network-accessible.  But it doesn't.  Follow the below steps to allow browsing of your server after installation:

1) Launch Control Panel
2) Start the Windows Firewall control panel applet
3) Select the [Exceptions] Tab, and click [Add Program...]
4) Click Browse, and browse to the file sqlservr.exe.  In a default installation, this is found at:
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\sqlservr.exe
5) Click [Open]
6) Click [OK] to close the [Add a Program] dialog

Those steps allow SQL Server 2005 to accept network connections through the firewall (you still need to have configured the right protocols and enabled SQL Browser, of course)

7) Click the [Add Port...] button
8) in the Name: box, type [SQL Browser Access]
9) in the Port: box, type 1434
10) set the radio button selection to UDP
11) Click [OK] to close the [Add a Port] dialog

Those steps allow SQL Browser to "talk" through the firewall, letting users browse for the server.  This step isn't strictly necessary to allow access to the server, as the users could type in the server name directly if it's known; it allows a much more user-friendly environment though.

12) Click [OK] to close the [Windows Firewall] control panel applet.

You've completed the steps.


Share a thought or comment...
Write a Comment...
Sign in...

If you are a member, Sign In. Or, you can Create a Free account now.

Anonymous Post (text-only, no HTML):

Enter your name and security key.

Your Name:
Security key = P1274A1
Enter key:
KB Post Contributed By Joshua Delahunty:
I am a software engineer with many years professional experience, using everything from 6809 assembly language to C, C++, Delphi, Paradox for Windows, and Borland JBuilder.
Visit Profile

 KB Article #100374 Counter
Since 4/2/2008
Sales Website: Or visit our legacy sales site:

©1995-2021 Prestwood IT Solutions.   [Security & Privacy]