I.T. Discussion Community!
-Collapse +Expand
DBA
Search DBA Group:

Advanced
-Collapse +Expand DBA Store
PRESTWOODSTORE

Prestwood eMagazine

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

   ► KBSQL ServersMicrosoft SQ...MS SQL 97 / ...   Print This    All Groups  
  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 13 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!)

KB100374

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.


Comments

0 Comments.
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 = P1195A1
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
5665
Since 4/2/2008

Follow PrestwoodBoards on: 


©1995-2019 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech