I have my IIS webserver outside the fire wall and my SQL Server is behind the firewall . Can IIS Still access the SQL Server for ASP pages, is it for this situation do i need to open the port no 1433 in the firewall for SQL Server, if so is there any security threat?
Thank You for your Time
Yes, you will have to open a port however it does not need to be 1433 You can change the port in the database properties in enterprise manager. There is always a security risk with anything involving the net. You will just have to try and minimize the threat by setting allowed IP address and things of that nature. If you do change the default port you will have to change the connection strings on your pages.