Symptom

Your are getting errors when trying to connect to the database using the built-in SQL database credentials.


Cause

During installation, SQL Server Database Engine is set to Windows Authentication mode.


Resolution

Change Authentication to mixed mode.


To change security authentication mode:

  1. In SQL Server Management Studio Object Explorer, right-click the server, and then click Properties.  
  2. On the Security page, under Server authentication, select the new server authentication mode, and then click OK.  
  3. In the SQL Server Management Studio dialog box, click OK to acknowledge the requirement to restart SQL Server.