• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 348
  • Last Modified:

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 ?
0
AndyAinscow
Asked:
AndyAinscow
  • 2
2 Solutions
 
EvilPostItCommented:
If the service is running on default ports it will be ports 1433 & 1434.
0
 
dmwynneCommented:
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
 
AndyAinscowAuthor 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.
0
 
AndyAinscowAuthor 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.
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now