Unable to connect to database server using SQL Account

Problem:

User create SQL Account on local database. Unable to connect using SQL Account.

Fix:

Make sure “SQL Server and Windows Authentication mode” is selected in Server Properties of SQL Server.

Restart database server.