It says my number is not connected to an account.

Text sign-in only opens an account that already has your number. Sign in with your email link, open Account → Sign in by text, and add the number. Then try the text again.