MS SQL Server

When logging in with SQL Server Login, make sure that this is allowed.
This is set to the Server Properties under Security at Server authentication: