Hi Johan,
Yes, But, both the sa and my test account are enabled and I can connect to both from another server.
Here is the SQL error log details:
Login failed for user 'sa'. Reason: Password did not match that for the login provided. [CLIENT: <local machine>]
Error: 18456, Severity: 14, State: 8.
This is a very strange issue. At first I thought it could be privileges on my windows account, after confirming that I am an admin it was clear that wasn't the issue.
I can't find anything on the net related to this specific issue.
Any help would be appreciated
Thanks