SteveTheGeek
MIS
All,
I'm restructuring a customer site with a primary goal of securing it, and I've come to an interesting issue: I've got SQL2000 back-end servers and IIS front-end servers for anonymous and customer access. While I need to keep the SQL servers on the trusted LAN and the webservers on the DMZ, is it generally more secure to have the webservers accessing the SQL servers via SQL authentication and keep the webservers out of the active directory domain, or is it more secure to keep everything in one (or a second trusted) active directory domain so that I can use NT authentication between the SQL and IIS services?
-Steve
I'm restructuring a customer site with a primary goal of securing it, and I've come to an interesting issue: I've got SQL2000 back-end servers and IIS front-end servers for anonymous and customer access. While I need to keep the SQL servers on the trusted LAN and the webservers on the DMZ, is it generally more secure to have the webservers accessing the SQL servers via SQL authentication and keep the webservers out of the active directory domain, or is it more secure to keep everything in one (or a second trusted) active directory domain so that I can use NT authentication between the SQL and IIS services?
-Steve