The Managed Identity has to be assigned to the Azure VM that is hosting the application in addition to being assigned to the SQLMI instance. When I assigned the Identity to the host VM, the connection worked as expected.