How to set up an SQL Server authentication login for a database instead of using Windows Authentication
Ok found the answer after an hour of trying various options.

Server properties - Security (see image)

Shame there is no warning message somewhere when you create SQL Authentication users that they have no access.