Solved

Win 7 firewall problem, peer to peer, SQL Server express

Posted on 2013-07-01
4
322 Views
Last Modified: 2013-07-16
I've got a small problem.  On a P2P network (2 PC's) there is SQL Server 2005 express installed on a new Win 7 machine.  The other PC now can't get at the SQL Server instance.  As soon as I turn the firewall off then access is allowed - so it clearly is a firewall related problem.

What programs/services need to be allowed through the firewall so that the other PC can use the SQL Server based database on the new Win7 box ?
0
Comment
Question by:AndyAinscow
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 16

Assisted Solution

by:EvilPostIt
EvilPostIt earned 250 total points
ID: 39290141
If the service is running on default ports it will be ports 1433 & 1434.
0
 
LVL 14

Accepted Solution

by:
dmwynne earned 250 total points
ID: 39290170
You could try to turn on firewall logging to see what is being blocked.

http://technet.microsoft.com/en-us/library/cc947815(v=ws.10).aspx
0
 
LVL 44

Author Comment

by:AndyAinscow
ID: 39295640
Thanks for the comments.  I've managed to find where I think those functionalities reside (the technet link talks about tabs - I don't see any tabs at all but find something under advanced settings).

I've not got access to the problem network at present - I'll get back in a couple of days with the progress.
0
 
LVL 44

Author Comment

by:AndyAinscow
ID: 39329531
Sorry to be so long with getting back.  The end users have decided just to switch off the firewall for the internal network rather than investigating further.  I'll split assuming both comments would be relevant.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you start your Windows 10 PC and got an "Operating system not found" error or just saw  "Auto repair for startup" or a blinking cursor with black screen. A loop for Auto repair will start but fix nothing.  You will be panic as there are no backā€¦
No single Antivirus application (despite claims by manufacturers) will catch or protect you from all Virus / Malware or Spyware threats. That doesn't stop you from further protecting yourself however - and this article is to show you how.
This Micro Tutorial will give you a basic overview of Windows DVD Burner through its features and interface. This will be demonstrated using Windows 7 operating system.
Viewers will learn how the fundamental information of how to create a table.

740 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question