重新安装SQL Server 2008 R2遇到配置错误的解决办法

时间:2022-07-25 00:45:07

转载原文:

大二学数据库,课本以SQL server为例,自己看书比较快,自学sql server 2008高级编程时要安装示例数据库,发现自己装的express不能支持安装实例数据库,果断卸载重装,把sql server安装文件全部卸载删除,并且把注册表清理干净(不然重装可能会失败),然后重装sql server 2008sp2和SQLEXPRADV_x64_CHS.exe,重装真是问题多多啊

在Windows 7下试图将SQL Server 2008 Express升级为R2版时,还未能进入安装界面,就抛出异常。以下是异常的部分信息:

See the end of this message for details on invoking 
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
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, P licKeyToken=b77a5c561934e089' or one of its dependencies. The system cannot find the file specified. (C:\Users\<当前用户>\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, P licKeyToken=b77a5c561934e089' or one of its dependencies. The system cannot find the file specified.
File name: 'System, Version=4.0.0.0, Culture=neutral, P licKeyToken=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)

WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging, set the registry val [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
Note: There is some performance penalty associated with assembly bind failure logging.
To turn this feature off, remove the registry val [HKLM\Software\Microsoft\Fusion!EnableLog].

解决方法:

将C:\Users\<当前用户>\AppData\Local\Microsoft_Corporation\文件夹下的LandingPage.exe*文件夹删除,再运行安装程序即正常。

xp的在:C:\Documents and Settings\Administrator\Local Settings\Application Data\Microsoft_Corporation下(建议先备份一下)

解决方法来自:http://social.msdn.microsoft.com/Forums/en/sqlkjsetupandupgrade/thread/35356bf2-6db7-4785-a104-bc62d18913f7

进入安装后,刚开始最好设为windows默认登录,以后再添加账户,继续,为数据库指定实例名(第二次安装嘛不能用默认),指定管理员,继续下一步,然后为数据库express和报表服务设定为手动(不然安装后只要一开机数据库就会启动,很占资源使系统反应很慢),然后指定登录名和密码,由于系统登录账户没设密码,试了几次都发出错误警告:“[错误消息] 为 SQL Server 服务指定的凭据无效。若要继续操作,请为 SQL Server 服务提供有效的帐户和密码。  [详细信息] Microsoft.SqlServer.Configuration.SqlEngine.ValidationException: 为 SQL Server 服务指定的凭据无效。若要继续操作,请为 SQL Server 服务提供有效的帐户和密码。”,于是马上为账户设密码,安装程序可以继续下一步安装,安装进度比较慢。

为 AdventureWorks 数据库安装配置新的 SQL Server 实例可以参考微软官方网站的资料:http://msdn.microsoft.com/zh-cn/library/gg512108(v=vs.91).aspx?wa=wsignin1.0