Link to home
Start Free TrialLog in
Avatar of dbaSQL
dbaSQLFlag for United States of America

asked on

SQL Server Installation error/exception/failure

Using the install cd, trying to install v2008 R2 Developer Edition on my laptop.  Windows 7 Professional, 64bit OS.  Have had v2005 and v2008 here before, but removed it all before this installation.  Installation begins fine, but once it reaches the 'Setup Support Files' dialog, as it is processing ExecuteCalculateScenarioWorkflow, the green progress bar gets about 3/4 of the way through, then it just stops.  Dialog closes, no errors, no nothing, it just stops doing anything.

Task Mgr shows setup still running, but the install doesn't pick back up, and continue.  

The SQL Server Installation Center dialog is still open, when I attempt to close it, I receive an unhandled exception, w/the following detail:

************** 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, PublicKeyToken=b77a5c561934e089' or one of its dependencies. The system cannot find the file specified. (C:\Users\myUsername\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)


There's a great deal more about JIT debugging, loaded assemblies, and configuration.  Please let me know if anymore of the exception output is necessary.

Reboot, try again, same thing.  
If I go into the Install Center and report any problems with the machine that may prevent install, it comes back clean.  None of the checks report a failure.

Any ideas?
Avatar of Wouter Boevink
Wouter Boevink
Flag of Netherlands image

Try installing .NET4.0 manually
Avatar of dbaSQL

ASKER

Same thing, the installation ends while in the Setup Support Files dialog.  Only difference is that now when I close the installation center window, it doesn't issue the exception.  No errors anywhere, the installation just stops completely.
SOLUTION
Avatar of Ryan McCauley
Ryan McCauley
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of dbaSQL

ASKER

I got the support tools in manually, by themselves, as you've suggested.  Went very smoothly.  Then I attempted the installation again -- same thing.  It gets to that dialog box, makes it a little bit further than ExecuteCalculateScenarioWorkflow, and then the installation ends.  No errors at all.  It just closes.  When I close the installation center dialog, there are no errors or exceptions.  

I've done it several times.  I will do it again now and see if i can catch where it's at just before the install stops.  

Have been working with SQL for years, and years.  Never had this problem.  Any insight is greatly appreciated.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of dbaSQL

ASKER

Rebooted, started the installation again -- this time we've got a failure, and much earlier.  After hitting setup.exe, but before the Installation Center dialog comes up, I get the exception copied at the bottom of all of this.  I hit OK, then the Installation Center dialog comes up.

In control panel/remove programs, the only things in there are:  
 Microsoft SQL Server 2008 R2 Setup (English)
 Microsoft SQL Server 2008 Setup Support Files

The support files are the ones I installed manually, the Setup (English) issues me this if/when I try to remove it:

  Warning 26003. Microsoft SQL Server 2008 R2 Setup
  Support Files cannot be uninstalled because the
  following products are installed:
  SQL Server 2008 R2 Common Files
  SQL Server 2008 R2 Database Engine Shared

I hit OK, and then I get 'The feature you are trying to use is on a network resource that is unavailalble'.  The path listed in the 'use source' is garbage:  c:\ba2c326d9d870d8dc9f0a8\1033_ENU_LP\x64\setup\sqlsupport_msi\

Lastly, I receive this:  'An installation package for the product Microsoft SQL Server 2008 R2 Setup (English) cannot be found. Try the installation again using a valid copy of the installation package 'sqlsupport.msi'.'


--This is the exception I get a few seconds after hitting setup.exe:

************** 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, PublicKeyToken=b77a5c561934e089' or one of its dependencies. The system cannot find the file specified. (C:\Users\myUsername\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)

WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging, set the registry value [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 value [HKLM\Software\Microsoft\Fusion!EnableLog].

   --- End of inner exception stack trace ---
   at System.Configuration.BaseConfigurationRecord.FindAndEnsureFactoryRecord(String configKey, Boolean& isRootDeclaredHere)
   at System.Configuration.BaseConfigurationRecord.GetSectionRecursive(String configKey, Boolean getLkg, Boolean checkPermission, Boolean getRuntimeObject, Boolean requestIsHere, Object& result, Object& resultRuntimeObject)
   at System.Configuration.BaseConfigurationRecord.GetSection(String configKey)
   at System.Configuration.ClientConfigurationSystem.System.Configuration.Internal.IInternalConfigSystem.GetSection(String sectionName)
   at System.Configuration.ConfigurationManager.GetSection(String sectionName)
   at System.Configuration.ClientSettingsStore.ReadSettings(String sectionName, Boolean isUserScoped)
   at System.Configuration.LocalFileSettingsProvider.GetPropertyValues(SettingsContext context, SettingsPropertyCollection properties)
   at System.Configuration.SettingsBase.GetPropertiesFromProvider(SettingsProvider provider)
   at System.Configuration.SettingsBase.GetPropertyValueByName(String propertyName)
   at System.Configuration.SettingsBase.get_Item(String propertyName)
   at System.Configuration.ApplicationSettingsBase.GetPropertyValue(String propertyName)
   at System.Configuration.ApplicationSettingsBase.get_Item(String propertyName)
   at Microsoft.SqlServer.Configuration.LandingPage.LandingPageForm.OnLoad(EventArgs e)
   at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
   at System.Windows.Forms.Control.CreateControl()
   at System.Windows.Forms.Control.WmShowWindow(Message& m)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


************** Loaded Assemblies **************
mscorlib
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4952 (win7RTMGDR.050727-4900)
    CodeBase: file:///C:/Windows/Microsoft.NET/Framework64/v2.0.50727/mscorlib.dll
----------------------------------------
LandingPage
    Assembly Version: 10.0.0.0
    Win32 Version: 10.50.1600.1 ((KJ_RTM).100402-1539 )
    CodeBase: file:///D:/x64/LandingPage.exe
----------------------------------------
System.Windows.Forms
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Drawing
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
Microsoft.SqlServer.Configuration.Sco
    Assembly Version: 10.0.0.0
    Win32 Version: 10.50.1600.1 ((KJ_RTM).100402-1539 )
    CodeBase: file:///D:/x64/Microsoft.SqlServer.Configuration.Sco.DLL
----------------------------------------
Microsoft.SqlServer.Chainer.Infrastructure
    Assembly Version: 10.0.0.0
    Win32 Version: 10.50.1600.1 ((KJ_RTM).100402-1539 )
    CodeBase: file:///D:/x64/Microsoft.SqlServer.Chainer.Infrastructure.DLL
----------------------------------------
System.Xml
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
Accessibility
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Accessibility/2.0.0.0__b03f5f7f11d50a3a/Accessibility.dll
----------------------------------------
Microsoft.SqlServer.Management.Controls
    Assembly Version: 10.0.0.0
    Win32 Version: 10.50.1600.1 ((KJ_RTM).100402-1539 )
    CodeBase: file:///D:/x64/Microsoft.SqlServer.Management.Controls.DLL
----------------------------------------
System.Configuration
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------

************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

For example:

<configuration>
    <system.windows.forms jitDebugging="true" />
</configuration>

When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.


Are you installing from a network share?
Avatar of dbaSQL

ASKER

Interesting.  I do have Detail_LandingPage.txt and a Summary_mymachine_20110105_090940_LandingPage.txt from this most recent installation attempt.  The summary doesn't really tell me too much, and best I can tell, the only thing of question in the detailed output is this:

2011-01-05 09:10:02 Slp: ----------------------------------------------------------------------
2011-01-05 09:10:02 Slp: Skipping Action: SetRoleAndUIModeForExpressMedia
2011-01-05 09:10:02 Slp: Action is being skipped due to the following restrictions:
2011-01-05 09:10:02 Slp: Condition "IsMediaExpress" did not pass as it returned false and true was expected.
2011-01-05 09:10:02 Slp: ----------------------------------------------------------------------
2011-01-05 09:10:02 Slp: Running Action: ValidateChainerSetting
2011-01-05 09:10:09 Slp: -- PidPublicConfigObject : ValidateSettings is normalizing input pid=[PID value hidden]
2011-01-05 09:10:09 Slp: -- PidPrivateConfigObject : NormalizePid found null or empty pid
2011-01-05 09:10:09 Slp: -- PidPublicConfigObject : ValidateSettings proceeding with normalized pid=[PID value hidden]
2011-01-05 09:10:09 Slp: -- PidPrivateConfigObject : Initialize is initializing using input pid=[PID value hidden]
2011-01-05 09:10:09 Slp: -- PidPrivateConfigObject : NormalizePid found null or empty pid
2011-01-05 09:10:09 Slp: -- PidPrivateConfigObject : Initialize proceeding with normalized pid=[PID value hidden]
2011-01-05 09:10:09 Slp: -- PidPrivateConfigObject : Initialize called ValidatePid, output is pid=[PID value hidden] validateSuccess=True output editionId=EVAL(0x2467BCA1)
2011-01-05 09:10:09 Slp: -- PidPublicConfigObject : ValidateSettings initialized private object, result is initializeResult=Success
2011-01-05 09:10:09 Slp: Completed Action: ValidateChainerSetting, returned True
2011-01-05 09:10:09 Slp: ----------------------------------------------------------------------
2011-01-05 09:10:09 Slp: Running Action: ProcessFeatureCommandLineArguments
2011-01-05 09:10:09 Slp: ----------------------------------------
2011-01-05 09:10:09 Slp: Completed Action: ProcessFeatureCommandLineArguments, returned True
2011-01-05 09:10:09 Slp: ----------------------------------------------------------------------
2011-01-05 09:10:09 Slp: Running Action: ProcessMediaFeatureConfigFileArguments
2011-01-05 09:10:09 Slp: Completed Action: ProcessMediaFeatureConfigFileArguments, returned True
2011-01-05 09:10:09 Slp: ----------------------------------------------------------------------
2011-01-05 09:10:09 Slp: Running Action: ProcessFeatureConfigFileArguments
2011-01-05 09:10:09 Slp: Completed Action: ProcessFeatureConfigFileArguments, returned True
2011-01-05 09:10:09 Slp: ----------------------------------------------------------------------
2011-01-05 09:10:09 Slp: Running Action: StartSqmSession
2011-01-05 09:10:09 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine
2011-01-05 09:10:09 Slp: Sco: Attempting to open registry subkey Software\Microsoft\Microsoft SQL Server\100
2011-01-05 09:10:09 Slp: Sco: Attempting to get registry value CustomerFeedback
2011-01-05 09:10:09 Slp: SQM is opted-out by command line parameter /SQMREPORTING or registry key setting, SQM session is closed
2011-01-05 09:10:09 Slp: Completed Action: StartSqmSession, returned True
2011-01-05 09:10:09 Slp: ----------------------------------------------------------------------
2011-01-05 09:10:09 Slp: Running Action: ValidateSettingsAgainstScenario
2011-01-05 09:10:09 Slp: Scenario: LandingPage
2011-01-05 09:10:09 Slp: Completed Action: ValidateSettingsAgainstScenario, returned True
2011-01-05 09:10:09 Slp: Completed Action: ExecuteBootstrapAfterExtensionsLoaded, returned True
2011-01-05 09:10:09 Slp: ----------------------------------------------------------------------
2011-01-05 09:10:09 Slp: Running Action: LandingPage
2011-01-05 09:10:09 Slp: Landing page action
2011-01-05 09:10:09 Slp: Starting Landing Page: Path = D:\x64\LandingPage.exe, Arguments =  /ENU /MEDIASOURCE="D:\\"
2011-01-05 09:38:04 Slp: Completed Action: LandingPage, returned True
2011-01-05 09:38:04 Slp:
2011-01-05 09:38:04 Slp:
2011-01-05 09:38:04 Slp: ----------------------------------------------------------------------
2011-01-05 09:38:04 Slp:
2011-01-05 09:38:04 Slp: Setup result: 0



Any ideas?  I can upload the two log files, if needed.
Avatar of dbaSQL

ASKER

No, not from a share.  Just from the install cd, in my laptop.
Are you installing from a network share?
From some msdn blogs:

delete the contents of the %userprofile%\local settings\application data\Microsoft_Corporation

Since the error message mentioned 4.0.0.0, it seems that the installation cannot found the assembly of previous version of Microsoft .Net Framework and trying to load the assembly of Microsoft .Net Framework 4.0. Since Microsoft .Net Framework 3.5 SP1 and 4.0 are incompatibility, this issue might be caused by that you just installed Microsoft .Net Framework 4.0 without installing Microsoft .Net Framework 3.5 SP1, I would like to recommend that you download Microsoft .Net Framework 3.5 SP1 from the following link and try again:

http://www.microsoft.com/downloads/en/details.aspx?FamilyID=ab99342f-5d1a-413d-8319-81da479ab0d7&displaylang=en
Avatar of dbaSQL

ASKER

The .Net 3.5 would never launch, I removed/reinstalled .Net 4, and tried again.  It got much further into it, but it still ended.  No errors or exceptions anywhere.  The detailed log output is much bigger this time, and attached.

Near the end, here are the items of note:


2011-01-05 12:20:33 Slp: ------------------------------------------------------------
2011-01-05 12:20:33 Slp: D:\x64\FixSqlRegistryKey_x86.exe exit code: 0
2011-01-05 12:20:33 Slp: Completed Action: FixSqlRegistryKey, returned True
2011-01-05 12:20:33 Slp: ----------------------------------------------------------------------
2011-01-05 12:20:33 Slp: Running Action: PostMsiTimingConfigAction
2011-01-05 12:20:33 Slp: The object state property 'workflow' is null/empty.
2011-01-05 12:20:33 Slp: Error: Action "PostMsiTimingConfigAction" failed during execution.
2011-01-05 12:20:33 Slp: Completed Action: PostMsiTimingConfigAction, returned False
2011-01-05 12:20:33 Slp: Completed Action: ExecuteStandardTimingsWorkflow, returned True
2011-01-05 12:20:33 Slp: ----------------------------------------------------------------------
2011-01-05 12:20:33 Slp: Running Action: ExecuteCloseWorkflow
2011-01-05 12:20:33 Slp: Workflow to execute: 'CLOSE'
2011-01-05 12:20:33 Slp: ----------------------------------------------------------------------
2011-01-05 12:20:33 Slp: Skipping Action: ProduceStatusLogs
2011-01-05 12:20:33 Slp: Action is being skipped due to the following restrictions:
2011-01-05 12:20:33 Slp: Condition "Is the datastore flag /Scenario/GlobalFlags/AreProductFeaturesSupported set" did not pass as it returned false and true was expected.
2011-01-05 12:20:33 Slp: ----------------------------------------------------------------------
2011-01-05 12:20:33 Slp: Running Action: FinalizeProgressStatus
2011-01-05 12:20:33 Slp: Completed Action: FinalizeProgressStatus, returned True
2011-01-05 12:20:33 Slp: ----------------------------------------------------------------------
2011-01-05 12:20:33 Slp: Running Action: RebootMessageAction
2011-01-05 12:20:33 Slp: Completed Action: RebootMessageAction, returned True
2011-01-05 12:20:33 Slp: ----------------------------------------------------------------------
2011-01-05 12:20:33 Slp: Skipping Action: FinishPage
2011-01-05 12:20:33 Slp: Action is being skipped due to the following restrictions:
2011-01-05 12:20:33 Slp: Condition "Is the user's scenario set to EditionUpgrade" did not pass as it returned false and true was expected.
2011-01-05 12:20:33 Slp: ----------------------------------------------------------------------
2011-01-05 12:20:33 Slp: Skipping property RequireMode of class: StopAction
2011-01-05 12:20:33 Slp: Input of property will not be set due to the following failed restriction(s):
2011-01-05 12:20:33 Slp: Condition "Is the user's scenario set to ComponentUpdate" did not pass as it returned true and false was expected.
2011-01-05 12:20:33 Slp: ----------------------------------------------------------------------
2011-01-05 12:20:33 Slp: Running Action: CloseUI
2011-01-05 12:20:33 Slp: Stop Action
2011-01-05 12:20:33 Slp: Completed Action: CloseUI, returned True
2011-01-05 12:20:33 Slp: Completed Action: ExecuteCloseWorkflow, returned True
2011-01-05 12:20:33 Slp: ----------------------------------------------------------------------
2011-01-05 12:20:33 Slp: Running Action: PassPidBackFromComponentUpdate
2011-01-05 12:20:33 Slp: Pass the flag CuPidDisplayed to the main setup
2011-01-05 12:20:33 Slp: ENU value specified, trying to pass the value to main setup
2011-01-05 12:20:33 Slp: PID value specified, trying to pass the value to main setup
2011-01-05 12:20:33 Slp: SQMREPORTING value is specified in CU workflow, trying to pass the value to main setup
2011-01-05 12:20:33 Slp: Completed Action: PassPidBackFromComponentUpdate, returned True
2011-01-05 12:20:34 Slp:
2011-01-05 12:20:34 Slp:
2011-01-05 12:20:34 Slp: ----------------------------------------------------------------------
2011-01-05 12:20:34 Slp:
2011-01-05 12:20:34 Slp: Setup result: 0
Detail-GlobalRules.txt
Detail-ComponentUpdate.txt
Avatar of dbaSQL

ASKER

This one is really odd, I have never seen this before.  I really need to get this darned installation done.  Any suggestions?  
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of dbaSQL

ASKER

Unfortunately, I am going to have to agree with you.   I will split the points, and close the inquiry.  Thank you each for taking the time to look.
Avatar of dbaSQL

ASKER

Your time is appreciated.  I will post back when I've determined the cause of the problem.
Just remembered I had something similar with a microsoft 2010 product on windows 2008, I had to install .net framework 2.0 to get the install working.