The solution turned out to be that the
"Web Access: Require SSL conection" had been ticked by mistake.
This meant that the server was trying to find an Https or SSl certificate for the database and had failed.
Unticking this box found on the main database properties tab fixed the problem.