SQL Server installation note

SQL Server & SQL Server Manager

SQL Server Download (Choose SQL Server 2022 Developer)
https://www.microsoft.com/en-us/sql-server/sql-server-downloads

SQL Server Manager Download
https://learn.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver16

After installed SQL Server you can see

SQL Server 2022 Configuration Manager
image-20230424132339092.png

In computer manager , find Service and Applications
image-20230424132539393.png

Change SQL Server Browser to Automatic and start it /

Then back to SQL server managere

You can see SQL Server Browser is display on SQL Server Services
image-20230424132708037.png

Windows Authentication Mode and SQL Server Authentication Mode

https://learn.microsoft.com/en-us/sql/relational-databases/security/choose-an-authentication-mode?view=sql-server-ver16

During setup, you must select an authentication mode for the Database Engine. There are two possible modes: Windows Authentication mode and mixed mode. Windows Authentication mode enables Windows Authentication and disables SQL Server Authentication. Mixed mode enables both Windows Authentication and SQL Server Authentication. Windows Authentication is always available and cannot be disabled

image-20230424133334696

image-20230424133534547.png

image-20230424133631030.png

image-20230424133742289.png

image-20230424134048661.png

After the setup is complete, Please remember restart SQL Server service

image-20230424134630948.png

Then try to connect SQL server use SQL Server Authentication

image-20230424134313812.png

image-20230424134752451.png

In Visual Studio 2022

image-20230424135023769.png
image-20230424135326596.png

image-20230424135554978.png

Complete

image-20230424135633676.png