1st time:
- window authentication login first
- After that, right click server and click properties
- security: change the login method (SQL Server Authentication actually also allow window authentication)
- restart
Restart SQL Server service:
- Open SQL Server Configuration Manager
- Expand SQL Server Services
- Right-click SQL Server (MSSQLSERVER) or SQL Server (SQLEXPRESS) → Restart
set sa account:
- expand the server, expand security, expand logins
- right click sa, click properties
- set password, set status enable login
- restart
add account:
- expand the server, expand security, expand logins