To overcome the limitation, users can download a pre-modified Windows XP ISO image that includes SATA AHCI drivers. These custom ISOs are created by enthusiasts and integrate the necessary drivers, allowing users to install Windows XP on SATA drives with AHCI mode enabled.