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

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?
LVL 20
Russ SuterAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
oBdAConnect With a Mentor Commented:
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
 
Haris DjulicCommented:
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
 
Russ SuterAuthor Commented:
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
All Courses

From novice to tech pro — start learning today.