Cannot connect to SQL server through SQL Server Authentication

This was a stupid one.

Use SSMS to check if the MSSQL instance is configure to allow logging in using only Windows Authentication.

Switch to both SQL Server Authentication and Windows Authentication and restart the service.