SharePoint Ports

netadmin007
netadmin007 used Ask the Experts™
on
Dear Experts,

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

Do more with

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

Commented:
Hi,

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.

HTH
Rainer
Jamie McAllisterCloud Expert
Most Valuable Expert 2013
Top Expert 2014

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

https://technet.microsoft.com/en-us/library/cc262849(v=office.15).aspx

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
Commented:
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.

MSSQL_port.PNG

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