There can be lots of things that can cause this issue. Please open up a support case so we can assist you properly.
I have subsequently managed to resolve the issue myself.
Change the SQL database authentication to mixed mode (Windows and SQL).
Restart the SQL server and the SQL Agent service and I was able to login to MVM successfully.
Thanks for taking the time to read and reply - appreciated.