Solved

SQL Server Firewall

Posted on 2014-01-29
5
279 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

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

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

A long time ago (May 2011), I have written an article showing you how to create a DLL using Visual Studio 2005 to be hosted in SQL Server 2005. That was valid at that time and it is still valid if you are still using these versions. You can still re…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

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