###Your drive's SFF-8639 interface isn't compatible with any of the ports on your motherboard

Your Seagate ST6000NM0034 drive has a SFF-8639 12 Gbit/s SAS connector. I couldn't find an image of the actual drive's interface, but it looks like this:

If you look closely (at your drive, not this picture), you'll notice there are pins on the top and bottom of the drive's connector "blade". SATA drives only have these "golden fingers" on one side.

Wikipedia's Serial Attached SCSI article indicates the SFF-8639 is a 68-pin connector, but the SFF-8482 is only a 29 pin connector. The extra pins in the SFF-8639 interface provide additional "lanes" as shown in this image from the AnandTech.com article SFF-8639 Connector Renamed as U.2:

Note: 4GB/s is equivalent to 32Gb/s, which is the maximum throughput of the SFF-8639 interface.

According to Seagate's knowledge base article Cabling - an overview:

The SFF-8639 connector was renamed to a more consumer friendly U.2. This connector is used with some new NVMe SSDs. U.2 utilizes 4 PCIe 3.0 lanes to provide speeds much faster than the SATA interface. Since most motherboards do not have a U.2 connector on them, a M.2 to U.2, or PCIe to U.2 adapter can be used.

In other words, no adapters exist to convert the U.2 interface to a SATA-style connector, not even the SAS-2 SATA connectors on your motherboard.

Your drive's SFF-8639 interface isn't compatible with any of the ports on your motherboard

Your Seagate ST6000NM0034 drive has a SFF-8639 12 Gbit/s SAS connector. I couldn't find an image of the actual drive's interface, but it looks like this:

If you look closely (at your drive, not this picture), you'll notice there are pins on the top and bottom of the drive's connector "blade". SATA drives only have these "golden fingers" on one side.

Wikipedia's Serial Attached SCSI article indicates the SFF-8639 is a 68-pin connector, but the SFF-8482 is only a 29 pin connector. The extra pins in the SFF-8639 interface provide additional "lanes" as shown in this image from the AnandTech.com article SFF-8639 Connector Renamed as U.2:

Note: 4GB/s is equivalent to 32Gb/s, which is the maximum throughput of the SFF-8639 interface.

According to Seagate's knowledge base article Cabling - an overview:

The SFF-8639 connector was renamed to a more consumer friendly U.2. This connector is used with some new NVMe SSDs. U.2 utilizes 4 PCIe 3.0 lanes to provide speeds much faster than the SATA interface. Since most motherboards do not have a U.2 connector on them, a M.2 to U.2, or PCIe to U.2 adapter can be used.

In other words, no adapters exist to convert the U.2 interface to a SATA-style connector, not even the SAS-2 SATA connectors on your motherboard.