Sometimes you have a DUH moment.
I just had was one: I upgraded VMware Workstation to 8.0.2 a couple of days ago.
Today one the less frequently used development virtual machines would not see the SQL Server 2000 alias it could find before.
Reasons:
- the ALIAS cannot be found through DHCP, so it was in the HOSTS table on the development virtual machine.
- the subnet of vmnet1 and vmnet8 got changed because the VMware update actually is performed ad a complete reinstall.
I blogged about the SQL Server 2000 alias last week, but in fact the work had been more than 2 months ago, so it took me a while to add up reasons 1 and 2 and find out the answer was in fact 3:
Reset the VMware vmnet1 and vmnet8 to the subnets they were before, and everything works fine and all is dandy again.
–jeroen