Solved

SQL Server Firewall

Posted on 2014-01-29
5
280 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
[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
  • 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

Learn by Doing. Anytime. Anywhere.

Do you like to learn by doing?
Our labs and exercises give you the chance to do just that: Learn by performing actions on real environments.

Hands-on, scenario-based labs give you experience on real environments provided by us so you don't have to worry about breaking anything.

Question has a verified solution.

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

To setup a SonicWALL for policy based routing to be used with the Websense Content Gateway there are several steps that need to be completed. Below is a rough guide for accomplishing this. One thing of note is this guide is intended to assist in the…
In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…

726 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