Solved

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

Posted on 2016-08-22
3
86 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 85

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

WordPress Tutorial 1: Installation & Setup

WordPress is a very popular option for running your web site and can be used to get your content online quickly for the world to see. This guide will walk you through installing the WordPress server software and the initial setup process.

Question has a verified solution.

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

Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
Configuring Remote Assistance for use with SCCM
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…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

630 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