I have tried recreating the connection although the connection file ended up being the same anyway.
I tried opening DA to see if the same would happen when it tried to access the database - it froze then too.
I tried using SA on a different DB on a different server and everything worked with no problems.