Answered my own problem but not sure what I missed...
After watching the install video I noticed that he started with the sqlserverwebconfig, so I deleted my modified default web.config and used the sql one instead,
the only change being the connection string.
Life is too short to check line by line what is different so I am happily moving forward!
Moral: don't be a mug - watch the video first.