To learn SQL Server to install it first, but many friends in the process of installation, always encounter such a problem, and finally lead to installation failure, the most hateful is the prompt "installation completed but failed", too hateful! I have just been liberated from this dilemma, in the installation process also got a lot of friends help, thank you, Brother Bird in his "bird Brother's Linux private food" mentioned in the internet has been helped, read other people's blog, must not forget to give others thanks, encourage others to provide better articles, a gentle thank you, Let us work together to create a positive network learning environment! Specific installation process Please refer to this friend from the Digital Resources Network blog http://www.downcc.com/tech/4135.html, written in very detailed, what I want to say here is that before the installation must do a good job of preparation, these jobs may not be every item is necessary, However, because SQL Server once installed failure, it is difficult to uninstall completely, many friends finally helpless can only reinstall the system, so, must not be taken lightly. Before installing, be sure to:
1. Modify the computer name. A friend in the bar, mentioned that when the login and computer name duplication is not successful installation, I install SQL Server on the WIN8 when the installation of Win8 need to modify the computer name, so there is no problem, so, first to modify the computer name.
2. Turn off the Win7 two firewalls.
3. Turn off all anti-virus software, security guard, especially 360. 360 is the enemy of all developers, I am an abomination.
4. www.microsoft.com download and install PowerShell directly into the official website search can be downloaded to, I downloaded the Windows Management Framework 4.0 includes PowerShell program, after the installation is complete, in "Run" to enter PowerShell, you can open a command-line window. No PowerShell can be used, but there will be error prompts, as a developer, this is not tolerated, so, recommended installation.
5. Setup.exe be sure to right-click to install as Administrator.
Above five, perhaps not all is necessary, but for the installation of SQL Server friends, perhaps, your current system is only one chance, do the above five, ensure foolproof, I wish you a successful installation!!
R2 Considerations for installing SQL Server under Windows 7