Due to the installation of VS2010 and the installation of SQL Server R2, there are some problems with SQL Server (for example: Begin...end ... Cannot be collapsed, causing the stored procedure to look hundreds of rows to be very painful), so simply reload SQL Server directly.
Unloading load SQL Server is a troublesome issue, with reference to other people's method of unloading (http://blog.csdn.net/wl_ldy/article/details/7882806), and cleaning up the registry, The following error occurred while reinstalling:
Could not open key:UNKNOWNComponentsABFE44842C12B390AF18C3B9B1A1EE8021599B0090400100000000F01FEC.Verify The sufficient access to that key, or the contact your the support personnel.
Here's how to fix it:
Run the cmd command prompt as an administrator, enter the following statement and run it OK
secedit/configure/cfg%windir%\inf\defltbase.inf/db defltbase.sdb/verbose
Follow the error prompts to find the registry key 000021599B0090400100000000F01FEC, but this administrator permissions can not be authorized, but also can not be removed, know is the problem here, but how can not be changed, Some registry tools do not work, and this command resets the system permissions configuration.
Red Word Part command parsing: In all, this command means to reset the system security configuration to the system default settings;defltbase.inf is the system Security configuration template,defltbase.sdb is the system Security Configuration Library , which is to rewrite the system security Configuration library with the system default security template. This command resolves many of the permissions issues that are encountered with the installation software, most of which are previously installed with the same software, the uninstallation does not completely cause the registry key to be locked, the permissions cannot be changed, or the table entry is deleted.
SQL Server R2 Installation Error: Could not open key