Solved

SQL Server Firewall

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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

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…
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…
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

757 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

20 Experts available now in Live!

Get 1:1 Help Now