I have a webserver with VMware Server (free) running on it.
I want to install a virtual machine on it with 2003 Server and SQL using VMware Server (free).
What would be the best way to set it up so that the webserver can get data from SQL but the SQL server remains protected from the internet?
The server has 2 network cards, and I know I can assign one card specifically to the virtual machine.... but is there a more efficient way such as 'Host only Networking'? I'm concerned with the traffic on the hardware switch affecting SQL response times.