Firewall Ports to Open for SQL Connect

Question

Hi,

We have a web server that is sitting on the DMZ and we will have an ASP.NET application that requires access to the SQL Backend which is on the production LAN. What ports should i open on the firewall?

Thanks
TagaR

Answer 1

Hello TagaR,

if you mean the ports for TCP/IP comunication with a Sql Server:
The default port for the first instance is port 1433 TCP/IP, if you want to use the Sql Server Browser to resolve the instance name (not really necessary) its port 1434 UPD.
But these are the default ports, the used ports you can look up in Sql Server Configuration Manager under protocol or in the Sql Server log.

---

Olaf Helper ----------- * cogito ergo sum * errare humanum est * quote erat demonstrandum * Wenn ich denke, ist das ein Fehler und das beweise ich täglich http://olafhelper.over-blog.de

Answer 2

As a follow-up question;

The Web server is on the DMZ as i mentioned in my post and will be accessing the SQL backend on the production LAN, would i be able to browse the instance if port is opened? or should i use the ip address then? My web server is not joined to the domain.

Thanks