Solved

SQL Server Firewall

Posted on 2014-01-29
5
277 Views
Last Modified: 2014-01-30
I'm always having difficulties connecting to a SQL Server on a network through the Windows firewall from a Windows 8 PC to a Windows 7 PC.

I've got a software application that automatically adds the following exe as an exception to both inbound and outbound rules.
C:\Program Files\Microsoft SQL Server\MSSQL10_50.ZURE\MSSQL\Binn\sqlservr.exe

The only way to get it to work is to disable to firewall on both PCs for private and public networks, then connect to the database.  
After a successful connection I can turn it back on again and it's working.

My problem is that I have a lot of users who are not very familiar with the advanced setting on Windows.

I just want them to run my installation and start working.

Is there something that I miss?
0
Comment
Question by:koossa
  • 3
  • 2
5 Comments
 
LVL 3

Expert Comment

by:BertSublime
ID: 39817597
SQL Need a variety of ports opened on the server firewall to allow access,  depending on what you want the client to access will dictate how you open the firewall,  once the server firewall is open you shouldn't have to make any changes to the client machine,  

the following should guide you on what ports you need to open on the server firewall.  

http://technet.microsoft.com/en-us/library/cc646023.aspx#BKMK_default
0
 

Author Comment

by:koossa
ID: 39820249
I'm using a dynamic port, that is why I add the sqlservr.exe to the firewall.
0
 
LVL 3

Accepted Solution

by:
BertSublime earned 500 total points
ID: 39820295
you will still need exceptions for the browser service,  put in to the firewall,  it should be inbound rules only that are necessary.  TCP/UDP port 1434.

if you are accessing via HTTPS you will need TCP 443 opened.

can you also check that the application you have  allowed,  is the correct sql instance.
0
 

Author Closing Comment

by:koossa
ID: 39820414
Thanks a lot!!!
0
 
LVL 3

Expert Comment

by:BertSublime
ID: 39820421
no problem
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering 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

Today I had a very interesting conundrum that had to get solved quickly. Needless to say, it wasn't resolved quickly because when we needed it we were very rushed, but as soon as the conference call was over and I took a step back I saw the correct …
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

839 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