Solved

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

Posted on 2016-08-22
3
79 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
[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 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 84

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

Business Impact of IT Communications

What are the business impacts of how well businesses communicate during an IT incident? Targeting, speed, and transparency all matter. Find out more in this infographic.

Question has a verified solution.

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

When you try to extract and to view the contents of a Microsoft Update Standalone Package (MSU) for Windows Vista, you cannot extract the files from the MSU. Here we are going to explain how to extract those hotfix details without using any third pa…
Configuring Remote Assistance for use with SCCM
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…

739 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