Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

SQL Server Firewall

Posted on 2014-01-29
5
Medium Priority
?
294 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 2000 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

When ransomware hits your clients, what do you do?

MSPs: Endpoint security isn’t enough to prevent ransomware.
As the impact and severity of crypto ransomware attacks has grown, Webroot fought back, not just by building a next-gen endpoint solution capable of preventing ransomware attacks but also by being a thought leader.

Question has a verified solution.

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

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…
Suggested Courses

971 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