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.
Why write this article?
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. My hard disk is relatively small, and the sharing method is Baidu disk, which is very slow to download directly. I have been in touch with MySQL a little before, and I know that the core components are actually small. So I tried to find a lightweight version of SQL Server 2008 on the official website, and it was not surprising. 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. 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 configuration of the environment can be said to be a crucial step in the process of computer learning. If too much time is wasted on it, it may have a negative effect on the confidence of subsequent learning. After some attempts, I finally succeeded in configuration. Now I record the process and hope to give some help to those in need.
Who is suitable for this article?
SQL Server 2008 Express is a free version of SQL server. It is an ideal platform for learning and building desktop and small server applications, and is very suitable for redistribution by ISV.
Therefore, if you are just learning SQL Server 2008 or SQL language like me, this free lightweight version is quite enough. If you’re using it for work or enterprise development, this article may not be for you.
Does my system support this software?
Supported operating systems
Windows Server 2003 Service Pack 2, Windows Server 2008, Windows Vista, Windows Vista Service Pack 1, Windows XP Service Pack 2, Windows XP Service Pack 3
In fact, it was successfully installed and run on my windows 10 professional edition, so it theoretically supports all versions of windows listed above and after.
How to download
You can visit the Microsoft Download Center: https://www.microsoft.com/zh-cn/download/ Then search for “SQL Server 2008 Express”. I have also prepared the official download link of the simplified Chinese installation package for x86 and x64 for you. Please choose according to your operating system and processor architecture.
SQL Server 2008 Express Chinese simplified installation package
Simplified Chinese installation package for SQL Server 2008 Management Studio Express
This paper takes x64 version as an example.
! please make sure that all “security guards / antivirus software / firewall” have been closed before installation, otherwise the installation will fail.
First, double-click to run“SQLEXPR_x64_CHS.exe”If the “UAC dialog box” pops up, please click “yes”, and the software will start self decompression, which will take about one minute. After the decompression, the software installation interface will pop up automatically.
Click “Install” – > “new SQL server independent installation or add features to existing installation”. Since this is the first time to install SQL Server software, we are actually going to conduct a new installation now.
As shown in the figure, you can click “OK” after all the rules are checked. Note that “restart the computer” may appear here as “failure”, which can be solved after restarting the system. Now click OK.
“Product key” because we are the free version of express, you can click “next”, then check it to agree with the license terms, and finally click “Install”. Here, the program support files are installed. The installation is completed in about one minute. A similar “rule check” will pop up. If the “Windows Firewall” status is shown as “warning”, please close the firewall and click “rerun”. Click “next” when all check items pass.
Jump out of the “function selection” interface, click “select all”, and then click “next”.
Jump out of the “instance configuration” interface. Keep the default here and click “next” directly.
Jump out of the “disk space requirements” interface, confirm that you have enough disk space, and directly click “next”.
Jump out of the “server configuration” interface, select “NT authority / system” at the top of the “account name”, change the “start type” at the bottom to “automatic”, and click “next”.
It is recommended to use “mixed mode” in “authentication mode” when you jump out of the “database engine configuration” interface. The advantage of this mode is that there are many ways to use the database service. You can set a password for the administrator of the built-in SQL server system, and then specify a Windows for the SQL server Administrator, after this setting, you can use both authentication methods at the same time. Continue to click next.
After that, you always click next, and there is a “rule check” in the middle. This time, there should be no possible errors or warnings. Finally, click “Install” and wait patiently for the installation to complete. The waiting time is about 3 minutes.
If the above interface appears, congratulations on successfully installing SQL Server 2008 Express!
Finally, click “next”, and then click “close”. The installation process of the server is finished.
To check whether the service runs successfully, find “SQL server configuration” under SQL Server in the start menu and click open.
As shown in the figure, the service is running normally. SQL Server 2008 Express does not support SQL server agent, so it shows “stopped”. If you try to start it, it will end in failure, but it will not affect the learning of SQL Server database (in fact, only SQL server is running, and browser does not affect learning).
Next, install SSMS. The steps are basically the same as the process of installing server, which will not be repeated here. It should be noted that SSMS needs to be “right-click to run as an administrator”. The entrance of the installation program is still the “SQL server installation center” seen when installing server. However, since the server has already been installed, when you click “new SQL server independent installation or add functions to existing installation”, it is actually adding functions to the server, that is, the management tool SSMS.
The default configuration in the above figure is the checked configuration. Keep the default and go to the next step directly. You may be puzzled, “didn’t you add new functions to the existing instance? “, but in fact, the operation here can be kept by default. If you don’t believe it, you can try to check the second item. As a result, the setup program prompts that there are no new features to add.
Here, check “management tools”, which actually means SSMS. Next step.
All of the following will remain the default, and the next step is OK.
It is believed that readers can successfully complete the installation process according to the existing experience.
Find and open “SQL Server Configuration Manager” again, click “SQL server network configuration” – > “sqlexpress Protocol”, and configure as shown in the figure below. Start the first three items, and the last item “via” remains disabled. Otherwise, SSMS cannot connect to SQL server.
Right click on “TCP / IP”, select “properties”, find “ipall” at the end of “IP” in the right column, set “TCP dynamic port” to null, and set “TCP port” to 1433.
After configuration, the service needs to be restarted to take effect, as shown in the figure below.
If you have successfully installed server and SSMS, the SQL Server 2008 folder in your start menu should look like this:
Click to open “SQL Server Management Studio”
Keep the default configuration. If the “server name” in the default configuration is empty, manually enter (local) and click “connect”.
If the above interface appears, the connection is successful.
This concludes the article. Hope to help more SQL Server 2008 learners in the environment configuration phase less detours. If you have any questions, you can put forward the exchange in the comment area. I will read the comments regularly in my spare time, so that we can learn together and make progress together!