1. The first step of course is to download the first, here is attached: https://msdn.itellyou.cn/opened to find the server to find:
Select need to download, I use here is
2. Download complete, find the download path, unzip open, find the setup application open, if missing. NETFramework 3.5 Clicks He will automatically install. Note: When you are finished installing, you will open the Setup application installation again.
3. Installation is generally the first choice, if a firewall warning, turn off the firewall to run again.
4. Set the role: we select "SQL Server Feature Installation".
5. Function Selection:
Here, we click the "Select All" button, you will find the left tree more than a few items: "Installation Rules" after an "instance configuration", after "disk space requirements" More than "server Configuration", "Database Engine configuration", "Analysis Services Configuration" and " Reporting Services Configuration.
If it is only used as a normal data engine, I often just tick: "Database Engine service" and "management tools-Basic" (Select all also OK, no relationship)
6. Instance configuration: Direct, with the system default
7. Server configuration: Click on all SQL Server services to use the same account, using the first (NT authority\nework service "I use this, as if two no difference"), do not lose the password, click OK.
8. Database Engine configuration: Here is a map (password input, the bottom click to add users, wait a moment, it may take a two seconds, then next line)
9.Analysis Services Configuration (also add current user, Next)
10.Reporting Services Configuration (direct next step)
11. There is no error reporting by this method (hey??), Naughty ... , continue to the next step, install the configuration rules, ready to install are fart words, directly past, start the installation, here need to wait a while ... )
12. I have been waiting for about 10 minutes, when it prompts you to successfully install the time, you just need to close the line, and then, you know, you can open to try.
13. I have opened, created a table, very useful.
SQLSERVER2008R2 Download Installation Tutorial