I've solved the issue by giving Rights to IISuser and IUSer , hope this helps someone in future.
This is exactly what my issue was, I set the store up with SSL prior to setting up the DB and I kept getting a redirect. I missed setting up the folder security and that caused the infinite redirects.