Go 4 Sharepoint

Search:

Welcome: Guest!

Sharepoint Forum

Home » Forum » Sharepoint

Ask a question

RSS Feeds

Firewalls

Asked By: Israel Haynes Date: Apr 18, 2004 Category: Sharepoint Views: 218

I have a question about configuring Sharepoint 2 and firewalls. I
plan to host my SQL server on a seperate box behind a firewall and my
Webserver (also running all the other functions, pretty much
everything except SQL) on my DMZ so it will be available over the
internet.

Does anybody know where I can out what changes I need to make to my
firewall to support this configuration? I've looked in the
Administrators Guide, but I haven't been able to find anything. I've
pretty much got this setup now, but my web server cannot communicate
with my SQL server. I have other web servers (that do not run SPS)
on my dmz talking with other SQL servers which work fine, so I
suspect that SPS must use some other port configuration.

Tagged:firewalls

1 Answer Found

Answer #1 Answered By: Skyler Poole Answered On: Apr 18, 2004

We scoped out the ports and found that you need to open two ports possibly
three!

For SQLSever you need to open 1433 in addition to the web ports 80 and 443.
Also if you use a SMTP servr that is outside of the DMZ that port needs to
be opened for the SMTP traffic to correctly flow otherwise on the web server
you'll see things stuck in the queue, Sharepoint will not cough up a error
on that!!

What we also noticed in our netmon traces was that there where actually two
ports used between the SQLServer and the Web server the second port is
dynamic and meant we had to set it in the web servers registry to a
permanent value

In the registry it is at Microsoft SQL Server > Sharepoint > MSSQLServer >
SuperSocket > TCP > TcpDynamicPorts

We assigned this to a high port number

Didn't find what you were looking for? Find more on Firewalls Or get search suggestion and latest updates.

Your Answer

Answer should be atleast 30 Characters.
Please put code inside [Code] your code [/Code].

Please login to post comment

Previous: Users asked to give their username and password

Next: 'PRIMARY' File Group is full error

Go4Sharepoint, is a Microsoft Featured Community. Microsoft, Windows, Sharepoint, Sharepoint logo, Windows logo, etc are trademarks of the Microsoft Corporation. All product names, logos, copyrights, and trademarks mentioned are acknowledged as the registered intellectual property of their respective owners. This site is not in any way affiliated with, nor has it been authorized, sponsored, or otherwise approved by, Microsoft Corporation.