By default, SQL Server has ’Windows Authentication mode’ enabled. You
need to change this to ’SQL Server and Windows Authentication mode’.
- Right click on Server (top of tree object) and choose Properties
-> Security
- Enable ’SQL Server and Windows Authentication mode’.