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

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 ?
LVL 45
AndyAinscowFreelance programmer / ConsultantAsked:
Who is Participating?
dmwynneConnect With a Mentor Commented:
You could try to turn on firewall logging to see what is being blocked.
EvilPostItConnect With a Mentor Commented:
If the service is running on default ports it will be ports 1433 & 1434.
AndyAinscowFreelance programmer / ConsultantAuthor Commented:
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.
AndyAinscowFreelance programmer / ConsultantAuthor Commented:
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.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.