In Connecticut, if someone is drunk or high, they can legally give consent as long as they are not drunk or high to the point of incapacitation. The standard for incapacitation in Connecticut is if someone cannot understand what they’re agreeing to or possible consequences of engaging in an activity. If someone is incapacitated, even if they say “yes” to sexual activity, that does not meet the legal standard for consent.
It is still important to make sure you feel confident that someone wants to engage in a sexual activity before you initiate it when someone is drunk or high, even if they are not incapacitated and can legally give consent.