Hi all.

Ok I have solved this problem and how I did it so if anyone else has this problem they can try it.

The sql server sa login password wasn’t the same as the login so I downloaded SSMS and changed the password of the SA user and problem solved.