Sharepoint - SQL Database Connection problem

[Zach]

TSCustomer

I was going to set up the sharepoint server on our webserver which is in a DMZ but I have the SQL Server DB on a server on our Domain. After I was done installing Sharepoint I realized that since it’s in the DMZ I can’t connect to the SQL DB on our server in our domain.

From what I gather all of the computers in the farm need to be in the domain in order for them to be able to talk to each other. Looking forward to an answer.
Thanks for helping me.

[DShack]

Normally if you put a webserver with a SQL backend in a DMZ, you would open ports tcp1433 and udp1434 on your firewall to allow the webserver to query the SQL server. That's the case with SharePoint too.

But the problem with Sharepoint is that you also need to allow the SharePoint server to communicate with your domain controllers, so you have to allow traffic between your web server and the DCs. That would be on quite a few ports, which sort of defeats the purpose of having it in the DMZ.

A better solution would be to put an ISA 2006 server in the DMZ and keep your SharePoint server in your trusted network. Proxy traffic from the ISA to the SharePoint.