I've provisioned Heroku Connect and I'm trying to authorize it to access my sandbox org, but I'm unable to login to Salesforce using my production credentials.
When a sandbox org is created, it copies the configured users over from the production environment along with the rest of your data, but Salesforce usernames are unique across all environment, which requires that they change for the sandbox environment. When you create a sandbox, you're asked to give it a short name (for example,
test), and that name gets appended to the end of the usernames you already have configured. So
email@example.com in production would be
firstname.lastname@example.org when copied into the