Table of Contents
Install Microsoft SQL Server
1. Mount downloaded image file then run the installer (setup.exe).
![Bg012](https://bonguides-1e199.kxcdn.com/wp-content/uploads/2022/05/bg012.png)
2. On the left, select install link then install a new SQL Server.
![Bg013](https://bonguides-1e199.kxcdn.com/wp-content/uploads/2022/05/bg013.png)
3. Now, you can insert the product key or install free Express edition of SQL Server.
![Bg014](https://bonguides-1e199.kxcdn.com/wp-content/uploads/2022/05/bg014.png)
You have several free editions: Evaluation, Develop and Express.
![Bg015](https://bonguides-1e199.kxcdn.com/wp-content/uploads/2022/05/bg015.png)
4. The installer will check potential problems before install.
![Bg016](https://bonguides-1e199.kxcdn.com/wp-content/uploads/2022/05/bg016.png)
5. Select features to install.
![Bg017](https://bonguides-1e199.kxcdn.com/wp-content/uploads/2022/05/bg017.png)
6. Instance configuration, you can use default instance or type a name of the instance as you need.
![Bg018](https://bonguides-1e199.kxcdn.com/wp-content/uploads/2022/05/bg018.png)
7. Specify the service accounts.
![Bg019](https://bonguides-1e199.kxcdn.com/wp-content/uploads/2022/05/bg019.png)
8. Select Mixed Mode under Authentication Mode then create a password for sa account.
![Bg020](https://bonguides-1e199.kxcdn.com/wp-content/uploads/2022/05/bg020.png)
It could take several minutes to complete depending on how many features you have install.
![Bg021](https://bonguides-1e199.kxcdn.com/wp-content/uploads/2022/05/bg021.png)
The installation was successful, move to the next step to connect to the SQL Server using SQL Management Studio.
![Bg022](https://bonguides-1e199.kxcdn.com/wp-content/uploads/2022/05/bg022.png)
Connect to a SQL Server
Download then install SSMS from https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms
![Bg023](https://bonguides-1e199.kxcdn.com/wp-content/uploads/2022/05/bg023.png)
Connect to a SQL Server:
- Server name: Name or IP address of the SQL Server.
- Authentication: SQL Server Authentication.
- Login: sa
- Password: Password of sa account you create while install the SQL Server.
![Bg024](https://bonguides-1e199.kxcdn.com/wp-content/uploads/2022/05/bg024.png)
![Bg025](https://bonguides-1e199.kxcdn.com/wp-content/uploads/2022/05/bg025.png)