I have one server.
I need a web server and an SQL server for the web applicaitons.
I'm going to install 2003 Server Standard R2 as the base OS and web server.
I'm going to install MS Virtual Server and install another copy of 2003 Server in a virtual machine.
I'm going to install SQL 2005 on that virtual machine.
My question is, what do I need to do to secure the SQL server and protect it from web access?
There is an option for network adapters which are 1. Internal Network and 1. External network (physical NIC)
I would assume that Internal Network would be faster.
Microsoft SQL Server 2005Microsoft SQL ServerOS Security