The problem is MSSQL password complexity. I have spent 4hrs trying to resolve the same issue but later found that if you sa password does not meet the minimum password requirement policy, authentication will fail. In my case, Your password must include at least (2 numeric values),(2 uppercase letters)(2 special char) and other letters.