Solved

SQL Server Firewall Rules... what am I missing here?

Posted on 2016-08-22
3
51 Views
Last Modified: 2016-08-22
I've installed a SQL Server named instance. I can connect using SSMS to it locally just fine. If I disable the firewall I can connect to it remotely just fine, also using SSMS. I've added a rule to open port 1433 on the firewall but it's not letting my connection through. What am I missing here?
0
Comment
Question by:Russ Suter
3 Comments
 
LVL 15

Expert Comment

by:Haris Djulic
ID: 41765786
You need to add rule for SQL server browser ...

Paste use SQL Server Browser, you must open UDP port 1434

From https://msdn.microsoft.com/en-us/library/ms175043.aspx
1
 
LVL 83

Accepted Solution

by:
oBdA earned 500 total points
ID: 41765789
A named instance doesn't listen on 1433, it listens by default on a randomly picked port.
Set the port to a static one, and adjust the firewall rules accordingly.
How to assign a static port to a SQL Server named instance – and avoid a common pitfall
https://blogs.msdn.microsoft.com/arvindsh/2012/09/08/how-to-assign-a-static-port-to-a-sql-server-named-instance-and-avoid-a-common-pitfall/
0
 
LVL 20

Author Closing Comment

by:Russ Suter
ID: 41765880
All these years of using SQL Server and I never knew this. Thanks. I was able to lookup the port and add the appropriate rule and it works fine now.
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
In this article, I will show you HOW TO: Install VMware Tools for Windows on a VMware Windows virtual machine on a VMware vSphere Hypervisor 6.5 (ESXi 6.5) Host Server, using the VMware Host Client. The virtual machine has Windows Server 2016 instal…
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
The viewer will learn how to successfully create a multiboot device using the SARDU utility on Windows 7. Start the SARDU utility: Change the image directory to wherever you store your ISOs, this will prevent you from having 2 copies of an ISO wit…

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

22 Experts available now in Live!

Get 1:1 Help Now