Windows needs a driver to be able to access a system drive.
If windows was initially installed with a driver for IDE, it will not be able to boot.
You can resolve the problem by reinstalling windows after changing the bios sata mode to AHCI.
Windows 7 will have no problem. Some older versions of windows might need to have a driver included in the install process.