Solved

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

Posted on 2013-07-01
4
311 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
  • 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

How does your email signature look on mobiles?

Do your employees use mobile devices to reply to emails? With mobile becoming increasingly important to the business world, it is in your best interest to make sure that your email signature looks great across all types of devices.

Join & Write a Comment

Suggested Solutions

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

743 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now