So, I have MS SQL Server 2008 running on a Windows Server 2003 machine in VMWare with a network interface set to host only.
When I run my 'application' on apache (xampp) on the host machine and connect to the MS SQL server with the IP of the Virtual Machine's Network Interface it works but it's extremely slow, just doing a select for one or two tables can take 10 seconds for the page to load.
However if I do the same but put apache, the same exact configuration, on the machine running MS SQL the pages load near instantaneously both in the browser on the Virtual Machine and the browser on the host machine connecting to the Virtual Machines IP.
Why do the query's take so long when apache and MS SQL are on different machine but not when they are on the same? The connection is done to the same IP with the same username and password in both cases and it's the exact same php sites loading...
Really hope someone might have an idea...