SQL Server Login attempts fail when using SSMS but succeed when using SQLCMD
Issue seems to be with the local SSMS install on the server. Everything works fine from odbc connections, remote SSMS connections etc.