安装sql server 2016报错误1402(请验证您是否具有足够的权限访问该项/Verify that you have sufficient access to that key)的解决办法

原创 2017年05月02日 16:16:56

安装sql server 2016报错


找了国内外N多解决办法,折腾了2个小时弄好了。


先出现的问题是“Microsoft Visual Studio 2010 可再发行组件 /  Microsoft Visual C++ 2010 Redistributable Package ”引起的,

Windows Installer 不允许更新经过管理的播发产品。应用更新程序之前,必须至少安装产品的一个功能。原因是 它可能已经在 Visual Studio 中注册了加载项。现在由于插件被删除、但在 Visual Studio 中没有反注册,造成后者认为其依然存在,所以阻碍了正常的重新安装过程。请重新安装删除的插件,然后用 Windows Installer Cleanup Utility   清理一下残留的 Visual Studio 注册信息 [


按照这篇文章的指引,先用Windows Installer Cleanup Utility这款工具,把Microsoft Visual C++ 2010 x64 Redistributable给清除了



然后重新安装Microsoft Visual C++ 2010 Redistributable Package(注意x86和x64):

https://www.microsoft.com/en-US/download/confirmation.aspx?id=5555

-----------------------------------------------------------------------------------------------------

这个弄完后,前面的错误不报了,又报个新错误


标题: Microsoft SQL Server 2016 安装程序
------------------------------


出现以下错误:


Error 1402.Could not open key: UNKNOWN\Components\{guid}\{guid}.   Verify that you have sufficient access to that key, or contact your support personnel.


解决办法我是参照这篇这篇文章弄好的:

1.open the registry
2.locate the HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Installer\UserData\S-1-5-18\Components\{guid} key and attempt to open
3.grant full access


注意,第2步的时候,Typically an "Access Denied" error will be generated if the issue above is occurring.这个时候就要用到后一片文章里说的工具psexec 。


1.Download and install psexec utility from the following link: http://technet.microsoft.com/en-us/sysinternals/bb897553.aspx


2:Open a command prompt (on Vista/Windows 7/2008) using ‘run as administrator’  option, for Windows (2000 /XP/2003) Hold down the shift key and right click on command prompt and choose run as.


3.In the command prompt Navigate to the folder where PSEXEC is installed.


4.Execute the following from the command prompt:  psexec -i -s cmd.exe


5.This will invoke another command prompt running under ‘Local System’(这一步就是当前登录的用户)


6.Using this command prompt open Registry Editor :

regedit




7.In registry editor navigate to the following hive: 
HKLM\Software\Microsoft\Windows\CurrentVersion\Installer\UserData\S-1-5-18\Components\




8. Add the user account used to run the installation under permissions for the above hive and grant ‘Full control’ for that user.


9.Under the Advanced security settings for Components choose the user and check the “Replace all existing inheritable permissions…………” check box as shown below and click OK




10.Re-run the installation.

Could not open key: ***** Verify that you have sufficient access to that key

安装MSI类型的软件,提示这个错误,很是头疼:              1、找到上面错误提示对应的那个注册表项: 在HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\W...
  • code_style
  • code_style
  • 2014-04-15 17:36:50
  • 9513

This server could not verify that you are authorized to access the document requested.

今天配置Apache + SVN实现通过http方式来访问svn服务器。经过在网上搜索“svn http”,得出这篇介绍还有这篇是比较全面的。于是按照上面的步骤一步步进行:     1、打开Ap...
  • luoshao20120430
  • luoshao20120430
  • 2013-11-30 14:10:47
  • 5751

通过http访问svn服务器的配置方法

    今天配置Apache + SVN实现通过http方式来访问svn服务器。经过在网上搜索“svn http”,得出这篇介绍还有这篇是比较全面的。于是按照上面的步骤一步步进行:    1、打开Ap...
  • derryzhang
  • derryzhang
  • 2009-12-25 16:36:00
  • 51574

Error 1402. Could not open key UNKNOWN\Components\.... Verify that you have sufficient access to tha

转自:http://www.symantec.com/business/support/index?page=content&id=TECH135922 Issue Err...
  • penaiyan
  • penaiyan
  • 2014-01-14 11:14:56
  • 4339

SQL Server 2008 R2 安装过程中出错的一种解决方法

可能是先装了vs2010,它会装部分与sql2008相关的东西,之后再装sql2008或sql2008r2版本,就可能会出错装不了。。 先下载:Total_Uninstall6.3.1,卸载sql...
  • pukuimin1226
  • pukuimin1226
  • 2013-10-07 15:21:55
  • 18444

Error 1310 Error writing to file:C:\Windows\...*.dll. Verify that you have access to that directory

一次手滑引发的悲剧
  • wuhuijun165
  • wuhuijun165
  • 2015-07-25 11:04:59
  • 3054

AcroIEHelper.dll无法写入,Verify that you have access to that directory

今天安装acrobat8.0,发现了一个问题: AcroIEHelper.dll无法写入C:\Program Files\Adobe\Acrobat 8.0\Acrobat\ActiveX,Veri...
  • u011115875
  • u011115875
  • 2016-01-04 10:47:56
  • 827

安装sqlserver时出现错误:Could not open key: UNKNOWNComponents

安装sqlserver时出现错误:Could not open key: UNKNOWNComponents1FA18F7974E099CD0AF18C3B9B1A1EE8536B55D6A91882...
  • haijs
  • haijs
  • 2017-01-24 13:24:23
  • 2552

无法打开键 请验证你对该键有足够的访问权限

无法打开键 ************, 请验证你对该键有足够的访问权限 在用windows7或者window8的时候,安装软件有时会出现如下图所示: 这个时候怎么办呢?这个问题肯定是注册表的问...
  • chchong1234
  • chchong1234
  • 2014-03-16 00:38:23
  • 5144

错误 1402 无法打开项 UNKNOWNComponents(2008/2005sql安装)

– 错误 1402。无法打开项 UNKNOWN\Components\7ABFE44842C12B390AF18C3B9B1A1EE8\54D21D49F3A8C1C49AC11A1B6445A83E...
  • moxiaoya1314
  • moxiaoya1314
  • 2016-07-11 21:02:37
  • 1044
收藏助手
不良信息举报
您举报文章:安装sql server 2016报错误1402(请验证您是否具有足够的权限访问该项/Verify that you have sufficient access to that key)的解决办法
举报原因:
原因补充:

(最多只允许输入30个字)