MS SQL Server 2008R2 Installation Guide (New Installation)
Generally speaking, "Step one" is not necessary, it usually appears after "User Account Control" is turned on on your computer, click "Yes" to proceed to the next step.
At this time, if the service of MS SQL Server 2008 R2 is not installed on your computer, you should select "Fresh Installation", note that we do not recommend installing multiple MSSQL services on a computer when it is not necessary, and they are not completely compatible with each other.
During the installation process, if the item "Cannot restart the computer" fails, you need to delete a registry key.
As shown in the figure, "Fresh Installation" we need to select the first radio button (new installation or add sharing function), and then continue to the next step.
In this interface, you can select the first item to manually specify the version, or you can select by entering the key. Please support your use of genuine software to protect your rights.
Please read carefully and fully understand the "MicroSoft Software License Terms" here, and check "I accept the license terms" to proceed to the next step.
Because we are doing a new installation this time, so choose the first item and proceed to the next step.
Non-developer users usually only need to use "Database Engine Service" and "Basic Management Tools", if you need to manage multiple MS SQL Server servers on one computer, we recommend that you also check the "Client Tool Backward" compatibility".
Create an example name here, if only a single MS SQL Server service is going to be installed on the computer, we recommend using the "default instance".
When using the MS SQL Server service, we generally need it to be started with the system, instead of manually entering the service management interface to start this service, and setting the SQL Server service running identity.
Choose an account, the former will have less authority than the latter (SYSTEM), you can directly choose the SYSTEM account.
Since our software generally supports two authentication methods, we recommend selecting "Mixed Mode", after selecting this mode, you need to fill in the password, this is the SA administrator account password, for security reasons, please be sure to set as strong as possible " sa" password, and remember this password.
Wait for the installation to complete, you can start the MS SQL Server service on your computer, and manage your database through the client tool.