SharePoint Ports

netadmin007 used Ask the Experts™
Dear Experts,

I have firewall between SharePoint Web Server and SharePoint Database, I want to know what specific port should I open on firewall ?
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2013
Awarded 2012


this depends on your SQL Server configuration (default instance vs. named instance, default ports or adjusted ports ...).
The default port for a default instance is TCP 1433. The named instance will get a dynamic port but uses TCP port 1434 for name resolution.

Jamie McAllisterCloud Expert
Most Valuable Expert 2013
Top Expert 2014

The various ports needed in the farm are detailed in this documentation (below is 2013 but it's also available for other versions);

There's also interesting advice for hardening the farm by changing the standard ports, though that goes beyond your question.
IT Engineer
Distinguished Expert 2017
Log on SQL Server machine and open SQL Server Configuration Manager and expand to Network Configuration/Protocols for the instance name (if default then MSSQLSERVER). Double click on TCP/IP and verify what is the TCP Port number.


Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial