I have now reinstalled SQL and it solved the problem. This is not the solution that I was hoping for but unfortunately I was running out of time so I had to get it solved. I will try to find out if someone had installed Express on there but I doubt it, this server has not been in use for a while.