无法安装 SQL Server 2008 R2 Express
我在安装 SQL Server 2008 R2 Express 时遇到问题。
在我的计算机上，我安装了 VC# 和 VWebdev 2010 Express。 它内部包含 SQL Server 2008 Express。
之后，我升级到了 SQL Server 2008 R2 Express。
结果是我无法连接到本地服务器本身。因此，我卸载了所有 SQLServer 产品并重新安装。然后我的屏幕上弹出一条错误消息，该消息粘贴在这个问题的末尾。
我的计算机运行 Win7 x64。 SQL Server 安装程序是64 位版本。 我的System.dll，我认为是这个问题的根源，程序集是2.0.0.0版本。
错误信息：
系统.配置.配置错误异常： 创建时发生错误 配置节处理程序 用户设置/Microsoft.SqlServer.Configuration.LandingPage.Properties.Settings： 无法加载文件或程序集 '系统，版本=4.0.0.0， 文化=中立， PublicKeyToken=b77a5c561934e089' 或 它的依赖项之一。系统 找不到指定的文件。 (C:\Users\BenZ\AppData\Local\Microsoft_Corporation\LandingPage.exe_StrongName_ryspccglaxmt4nhllj5z3thycltsvyyx\10.0.0.0\user.config 第 5 行) ---> System.IO.FileNotFoundException：可以 不加载文件或程序集“系统， 版本=4.0.0.0，文化=中立， PublicKeyToken=b77a5c561934e089' 或 它的依赖项之一。系统 找不到指定的文件。文件 name: '系统，版本=4.0.0.0, 文化=中立， PublicKeyToken=b77a5c561934e089' 在 System.Configuration.TypeUtil.GetTypeWithReflectionPermission（IInternalConfigHost 主机，字符串类型字符串，布尔值 抛出错误）在 System.Configuration.RuntimeConfigurationRecord.RuntimeConfigurationFactory.Init(RuntimeConfigurationRecord 配置记录、工厂记录 工厂记录）位于 System.Configuration.RuntimeConfigurationRecord.RuntimeConfigurationFactory.InitWithRestrictedPermissions（RuntimeConfigurationRecord 配置记录、工厂记录 工厂记录）位于 System.Configuration.RuntimeConfigurationRecord.CreateSectionFactory(FactoryRecord 工厂记录）位于 System.Configuration.BaseConfigurationRecord.FindAndEnsureFactoryRecord（字符串 configKey、布尔值& isRootDeclaredHere)
I have a problem with installing SQL Server 2008 R2 Express.
On my computer, I have installed VC# and VWebdev 2010 express.
It included SQL Server 2008 Express inside.
After that, I did an upgrade to SQL Server 2008 R2 Express.
The consequence is I can't connect to a local server itself. So, I uninstall all of SQLServer products and reinstall again. Then an error message pops up on my screen which is pasted on the end of this question.
My computer runs on Win7 x64.
SQL Server installer is a 64-bit version.
My System.dll, which I think a root of this problem, assembly is 2.0.0.0 version.
The error message:
System.Configuration.ConfigurationErrorsException:
An error occurred creating the
configuration section handler for
userSettings/Microsoft.SqlServer.Configuration.LandingPage.Properties.Settings:
Could not load file or assembly
'System, Version=4.0.0.0,
Culture=neutral,
PublicKeyToken=b77a5c561934e089' or
one of its dependencies. The system
cannot find the file specified.
(C:\Users\BenZ\AppData\Local\Microsoft_Corporation\LandingPage.exe_StrongName_ryspccglaxmt4nhllj5z3thycltsvyyx\10.0.0.0\user.config
line 5) --->
System.IO.FileNotFoundException: Could
not load file or assembly 'System,
Version=4.0.0.0, Culture=neutral,
PublicKeyToken=b77a5c561934e089' or
one of its dependencies. The system
cannot find the file specified. File
name: 'System, Version=4.0.0.0,
Culture=neutral,
PublicKeyToken=b77a5c561934e089' at
System.Configuration.TypeUtil.GetTypeWithReflectionPermission(IInternalConfigHost
host, String typeString, Boolean
throwOnError) at
System.Configuration.RuntimeConfigurationRecord.RuntimeConfigurationFactory.Init(RuntimeConfigurationRecord
configRecord, FactoryRecord
factoryRecord) at
System.Configuration.RuntimeConfigurationRecord.RuntimeConfigurationFactory.InitWithRestrictedPermissions(RuntimeConfigurationRecord
configRecord, FactoryRecord
factoryRecord) at
System.Configuration.RuntimeConfigurationRecord.CreateSectionFactory(FactoryRecord
factoryRecord) at
System.Configuration.BaseConfigurationRecord.FindAndEnsureFactoryRecord(String
configKey, Boolean&
isRootDeclaredHere)
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（3）
删除错误消息中提到的 user.config 文件可以解决此问题。
完整路径：
%USERPROFILE%\AppData\Local\Microsoft_Corporation\LandingPage.exe_StrongName_ryspccglaxmt4nhllj5z3thycltsvyyx\10.0.0.0\user.config
注意：我使用的是 Windows 7 Ultimate (64 位) 。
首先，我卸载了 Visual Studio 2010，然后从上述路径中删除了 user.config。
Deleting the user.config file mentioned in the error message resolves this.
Full path:
%USERPROFILE%\AppData\Local\Microsoft_Corporation\LandingPage.exe_StrongName_ryspccglaxmt4nhllj5z3thycltsvyyx\10.0.0.0\user.config
Note: I am using Windows 7 Ultimate (64 bit) .
First I have uninstalled Visual Studio 2010, then I deleted user.config from the above path.
我发现如果我按错误消息框右上角的关闭按钮，它会跳转到正常的安装屏幕。
现在安装成功了。
我终于可以通过 SQL Server Management Studio 连接到服务器了。
但我仍然想知道这之后会发生什么。
I have found that if I press a close button on the right top of the error message box, it will jump to a normal installation screen.
The installation is successful now.
I finally can connect to a server by SQL Server Management Studio.
But I still wonder what will be coming after this.
我在我的笔记本电脑上运行 Windows 7 64 位。我最初安装了带有高级服务的 SQL Server 2008 Express Edition，然后由于它在我的计算机上运行速度太慢，我使用 Revo Uninstaller 将其从我的系统中卸载。那是一个很大的错误！我已经使用 Revo 多年，没有出现任何问题，直到我用它来卸载 SQL Server。
因此，吸取的教训是，如果我将来要删除 SQL Server，请使用控制面板来删除它。我无法重新安装 Windows，因为我在这台机器上配置了太多软件和代码。我无法进行系统还原，因为我的还原点没有回溯到那么远，并且通过将系统还原到 2013 年 4 月上旬，我能够在所有这些更改之前重置我的注册表。可以选择返回更远的地方。
然后我找到了带有工具的 SQL Server 2008R2 Express，这听起来正是我所需要的，因为它运行所需的内存要少得多。但是，我无法安装它。我会尝试在 reqistry 中进行删除，基于我读过的关于如何在使用时手动重新安装 SQL Server 的博客
用于卸载它的第三方工具。我会收到 1605 错误，然后是另一个错误，然后是另一个不同的错误。我尝试了这些不同的方法：
，但没有任何效果。充其量安装了除工具之外的所有内容，但随后我删除了更多注册表项，它甚至无法开始安装。
我从注册表开始回到我第一次开始重新安装时，系统恢复后并尝试再次安装。我所做的就是在 Windows 资源管理器的地址框中键入 %localappdata%\Microsoft_Corporation，然后如上所述删除该文件夹。这让我克服了一个关于安装程序找不到且我以前见过的丢失文件的错误，但这并没有解决其他问题，因为当我尝试安装所有内容时，管理工具 - 基本没有安装并抛出安装错误。
所以我使用了控制面板并仅删除了工具和服务器实例。 看来，如果您可以再次加载 SQL Server，或者大部分情况下，您可以通过 Windows 中的控制面板卸载它或未完全安装的项目，那么这是将事情恢复到正常状态的最佳方法。说明您可以在哪里重新安装它。否则，您将不得不手动编辑注册表，并希望不要把事情搞得更糟。我尝试了五六次注册表技巧，但没有成功！
无论如何，它在尝试删除工具时抛出了一个错误，但已经删除了足够多的内容，以便我可以再次重新安装它，只需添加这两个项目即可我已经通过控制面板删除或部分删除：管理工具和服务器实例。
没有进行任何注册表更改，也不必删除计算机上的任何 SQL Server 文件夹，但这一次它起作用了！工具版本不需要太多内存来运行，所以我的机器可以用 4GB 内存很好地处理它。
I'm running windows 7 64 bit on my laptop. I had originally installed SQL Server 2008 Express Edition with Advanced Services and then because it ran so slow on my machine, I used Revo Uninstaller to uninstall it from my system. That was a big mistake! I have used Revo for years without issue, until I used it for uninstalling SQL Server.
So, the lesson learned is use the control panel to remove SQL Server if I ever do it in the future. I couldn't reinstall windows as I've got too much configured software and code on this machine. I couldn't do a system restore as my restore points didn't go back that far and I was able to get my registry reset prior to all these changes by doing a system restore back to the early part of April 2013. There were no options to go back any farther.
Then I found SQL Server 2008R2 Express with tools and that sounded like what I needed as it required a lot less memory to run. However, I couldn't get it installed. I'd try doing deletes in the reqistry, based on blogs I'd read about how to manually reinstall SQL Server when you used
a 3rd party tool to uninstall it. I'd get a 1605 error, then another error, then another different one. I tried these different ways:
, but nothing worked. At best everything installed, except tools, but then I'd delete more registry items and it wouldn't even start to install.
I started over with the registry back to when I first started the reinstall, after the system restore and tried to install it again. What I did was type %localappdata%\Microsoft_Corporation into the address box in Windows Explorer and then deleted that folder as mentioned above. That got me past one error about a missing file that the installer couldn't find and that I had seen before, but this didn't solve the other problems, as when I tried to install everything, the management tools - basic didn't install and threw an installation error.
So I used the control panel and removed the tools and the server instance only. It seems that if you can get SQL Server loaded up again or mostly so to where you can uninstall it or items that weren't fully installed through the control panel in windows, that is the best way to get things back to a state where you can get it reinstalled. Otherwise you are stuck with manually editing the registry and hoping you don't mess things up worse. I tried the registry tricks five or six times with no successes!
In any event, it threw an error trying to remove the tools, but had removed enough so that I could reinstall it again, just adding in those two items that I had removed or partially remove through the control panel: management tools and the server instance.
No registry changes were made and I didn't have to delete any of the SQL Server folders on my machine, but this time it worked! The tools version doesn't take much memory to run, so my machine can handle it well with 4gb's of ram.