The one from AutoZone (pictured above) does in fact work.

The one you rent from Advance Auto is the same exact one shown from Harbor Freight & if I remember correctly, I could not get any of those adapters to work.