Quick update:
I have plugged the SSD into another PC and it has detected it with the correct amount of storage space.
I managed to use diskpart to correctly format and partition the drive and successfully installed Windows with no hitch
However, I plugged the SSD back into the original build…same errors
SATA Port 0 Sandisk Milpit(0.0GB-3.0Gb/s)
Name Total Size Free Space
Disk 0 Unallocated Space 0.0MB 0.0MB
This tells me that there is nothing wrong with the SSD, and is in fact a compatibility issue with the SATA drivers and the AHCI controller on the motherboard. I have updated both the drivers on the motherboard and tried looking for an update for the firmware on the SSD (to which there isn’t one) and still the problem persists. I have restored the BIOS to an earlier version and this has no remedy either.
I have posted on the Intel, microsoft and supplier forums hoping that someone somewhere may find a solution