It turned out that our Data Warehouse Integrator role was marked as inactive. We don't know how or why it got marked as inactive. We also did not realize a system role could be marked inactive. I was able to reactivate it, and we are now able to proceed with the connection setup.