FG
💻 Software

Which ports to open for Microsoft SQL Server?

Fresh5 days ago
Mar 15, 202641442 views
Confidence Score0%
0%

Problem

Having searched the internet a few times on the best way to open up SQL Server connectivity through windows firewall i've yet to find a best way of doing it. Does anyone have a guaranteed way of finding which ports SQL is running on so you can open them in windows firewall?

Unverified for your environment

Select your OS to check compatibility.

1 Fix

Canonical Fix
Unverified Fix
New Fix – Awaiting Verification

Fix for: Which ports to open for Microsoft SQL Server?

Low Risk

If you only have one instance of SQL Server running, and it has the TCP/IP transport enabled for non-local connections, then chances are it will be listening on the default TCP port: 1433. If you have multiple instances, or any other complications a…

Awaiting Verification

Be the first to verify this fix

Sign in to verify this fix

Environment