If'n it works on one of the SATA ports but not another, the most likely issues are
1) SATA port is bad
2) SATA port must be enabled in BIOS
3) SATA port is on a different controller chip that is not configured
The mobo is from Asus; they usually don't have that port enabling nonsense. It does have four SATA ports; have you tried them all?
Does the BIOS recognize the drive but not Windows, or does the BIOS not see it either? If it's one particular port, and nothing you plug into that port works, and the same devices work in port2, a dead (or inactivated) port seems likely.