When using the provided adapter, the power indicator LED should turn off when the system is powered on.
If it remains lit when the system is powered on, it may indicate an issue with the connection or cable. See below thread for info:
im having the same issue, my 4070ti is running like normal and does not seem to have any issues, however when the pc is powered on of powered off the red light is always on, all connectors are in properly and im useing separate pcie cables, along with the adaptor out of the box. im not sure what the issue is at this point, and it doesnt seem that there are many fixes out there...