Cause:
Mixed mode authentication for SQL was not set up.

 

Solution:
Set up Mixed mode authentication.