Now I record the process and hope to give some help to those in need. After some attempts, I finally succeeded in configuration.
If too much time is wasted on it, it may have a negative effect on the confidence of subsequent learning. The configuration of the environment can be said to be a crucial step in the process of computer learning.
Because the online installation and configuration tutorials are basically based on the full version of SQL Server 2008 (with SSMS and other components), and I have installed SQL Server Express and SSMS express independently, so there are no articles that meet my requirements. The download process is very smooth, the first installation process is also OK, but finally open SSMS can not connect to the database, which can really hurt the brain. So I tried to find a lightweight version of SQL Server 2008 on the official website, and it was not surprising. I have been in touch with MySQL a little before, and I know that the core components are actually small. My hard disk is relatively small, and the sharing method is Baidu disk, which is very slow to download directly. In the first database principle class of this semester, the lecturer shared the materials needed for the course, including a 3.1gb SQL Server 2008 installation package.
DOWNLOAD MICROSOFT SQL SERVER MANAGEMENT STUDIO EXPRESS HOW TO
This article mainly talks about how to download, install, configure SQL Server 2008 Express and SMSs step by step, and finally use SMSs to connect to local database services.