We help IT Professionals succeed at work.

Can't install SQL Express 2005 unattended.

1,945 Views
Last Modified: 2012-06-21
I have to install SQL Express 2005 unattended.
For the moment I have the following situation :
The setup from the prompt (attended) works fine.
If I try unattended the setup quits without error on screen.
To avoid all other situations I have a new pc with Windows XP and all the updates and no other software.
I unpacked the setup with setup /x and set my ini file correct.
When I run on the prompt : setup /settings c:\dkw.ini /qb then stops the setup after perhaps 20% without error on screen.

Can someone help me with a solution or hint ?

contents of the file 'SQLSetup0001_LUCV-VHD_Core(Local)' :
Microsoft SQL Server 2005 Setup beginning at Thu Oct 04 14:23:07 2007
Process ID      : 256
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\setup.exe Version: 2005.90.1399.0
Running: LoadResourcesAction at: 2007/9/4 14:23:7
Complete: LoadResourcesAction at: 2007/9/4 14:23:7, returned true
Running: ParseBootstrapOptionsAction at: 2007/9/4 14:23:7
Loaded DLL:C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\xmlrw.dll Version:2.0.3604.0
Complete: ParseBootstrapOptionsAction at: 2007/9/4 14:23:7, returned true
Running: ValidateWinNTAction at: 2007/9/4 14:23:7
Complete: ValidateWinNTAction at: 2007/9/4 14:23:7, returned true
Running: ValidateMinOSAction at: 2007/9/4 14:23:7
Complete: ValidateMinOSAction at: 2007/9/4 14:23:7, returned true
Running: PerformSCCAction at: 2007/9/4 14:23:7
Complete: PerformSCCAction at: 2007/9/4 14:23:7, returned true
Running: ActivateLoggingAction at: 2007/9/4 14:23:7
Complete: ActivateLoggingAction at: 2007/9/4 14:23:7, returned true
Running: DetectPatchedBootstrapAction at: 2007/9/4 14:23:7
Complete: DetectPatchedBootstrapAction at: 2007/9/4 14:23:7, returned true
Action "LaunchPatchedBootstrapAction" will be skipped due to the following restrictions:
Condition "EventCondition: __STP_LaunchPatchedBootstrap__256" returned false.
Action "BeginBootstrapLogicStage" will be skipped due to the following restrictions:
Condition "Setup is running locally." returned true.
Running: PerformDotNetCheck2 at: 2007/9/4 14:23:7
Complete: PerformDotNetCheck2 at: 2007/9/4 14:23:8, returned true
Running: InvokeSqlSetupDllAction at: 2007/9/4 14:23:8
Loaded DLL:C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\sqlspars.dll Version:2005.90.1399.0
<Func Name='DwLaunchMsiExec'>
Examining 'sqlspars' globals to initialize 'SetupStateScope'
Opening 'MachineConfigScope' for [LUCV-VHD]
Trying to find Product Code from command line or passed transform
If possible, determine install id and type
Trying to find Instance Name from command line.
Instance Name = DKW
Trying to find install through Instance Name
Install Type = 1
If possible, determine action
Machine = LUCV-VHD, Article = WMIServiceWin32OSWorking, Result = 0 (0x0)
Machine = LUCV-VHD, Article = WMIServiceWin32CompSystemWorking, Result = 0 (0x0)
Machine = LUCV-VHD, Article = WMIServiceWin32ProcessorWorking, Result = 0 (0x0)
Machine = LUCV-VHD, Article = WMIServiceReadRegWorking, Result = 0 (0x0)
Machine = LUCV-VHD, Article = WMIServiceWin32DirectoryWorking, Result = 0 (0x0)
Machine = LUCV-VHD, Article = WMIServiceCIMDataWorking, Result = 0 (0x0)
Machine = LUCV-VHD, Article = XMLDomDocument, Result = 0 (0x0)
Machine = LUCV-VHD, Article = Processor, Result = 0 (0x0)
Machine = LUCV-VHD, Article = PhysicalMemory, Result = 70010 (0x1117a)
Machine = LUCV-VHD, Article = DiskFreeSpace, Result = 0 (0x0)
Machine = LUCV-VHD, Article = OSVersion, Result = 0 (0x0)
Machine = LUCV-VHD, Article = OSServicePack, Result = 0 (0x0)
Machine = LUCV-VHD, Article = OSType, Result = 0 (0x0)
Machine = LUCV-VHD, Article = AdminShare, Result = 0 (0x0)
Machine = LUCV-VHD, Article = PendingReboot, Result = 0 (0x0)
Machine = LUCV-VHD, Article = IEVersion, Result = 0 (0x0)
Machine = LUCV-VHD, Article = DriveWriteAccess, Result = 0 (0x0)
Machine = LUCV-VHD, Article = COMPlus, Result = 0 (0x0)
Machine = LUCV-VHD, Article = ASPNETVersionRegistration, Result = 0 (0x0)
Machine = LUCV-VHD, Article = MDAC25Version, Result = 0 (0x0)
*******************************************
Setup Consistency Check Report for Machine: LUCV-VHD
*******************************************
Article: WMI Service Requirement, Result: CheckPassed
Article: MSXML Requirement, Result: CheckPassed
Article: Operating System Minimum Level Requirement, Result: CheckPassed
Article: Operating System Service Pack Level Requirement, Result: CheckPassed
Article: SQL Compatibility With Operating System, Result: CheckPassed
Article: Minimum Hardware Requirement, Result: Warning
Description: Minimum hardware requirements are not met, therefore, some components may not perform as expected. Action: Make sure minimum hardware requirements are met. Please refer to the readme for minimum requirements.
Article: Pending Reboot Requirement, Result: CheckPassed
Article: Default Installation Path Permission Requirement, Result: CheckPassed
Article: Internet Explorer Requirement, Result: CheckPassed
Article: Check COM+ Catalogue, Result: CheckPassed
Article: ASP.Net Registration Requirement, Result: CheckPassed
Article: Minimum MDAC Version Requirement, Result: CheckPassed
<Func Name='PerformDetections'>
0
<EndFunc Name='PerformDetections' Return='0' GetLastError='0'>
Failed to find help file for LCID :2067
Loaded DLL:C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\sqlsval.dll Version:2005.90.1399.0
<EndFunc Name='DwLaunchMsiExec' Return='0' GetLastError='0'>
Complete: InvokeSqlSetupDllAction at: 2007/9/4 14:23:26, returned true
Running: SetPackageInstallStateAction at: 2007/9/4 14:23:26
Complete: SetPackageInstallStateAction at: 2007/9/4 14:23:26, returned true
Running: DeterminePackageTransformsAction at: 2007/9/4 14:23:26
Complete: DeterminePackageTransformsAction at: 2007/9/4 14:23:26, returned true
Running: ValidateSetupPropertiesAction at: 2007/9/4 14:23:26
Complete: ValidateSetupPropertiesAction at: 2007/9/4 14:23:26, returned true
Running: OpenPipeAction at: 2007/9/4 14:23:26
Complete: OpenPipeAction at: 2007/9/4 14:23:26, returned false
Error: Action "OpenPipeAction" failed during execution.
Running: CreatePipeAction at: 2007/9/4 14:23:27
Complete: CreatePipeAction at: 2007/9/4 14:23:27, returned false
Error: Action "CreatePipeAction" failed during execution.
Action "RunRemoteSetupAction" will be skipped due to the following restrictions:
Condition "Action: CreatePipeAction has finished and passed." returned false.
Running: PopulateMutatorDbAction at: 2007/9/4 14:23:27
Complete: PopulateMutatorDbAction at: 2007/9/4 14:23:27, returned true
Running: GenerateRequestsAction at: 2007/9/4 14:23:27
      SQL_Engine = -1
      SQL_Data_Files = -1
      SQL_Replication = -1
      SQL_FullText = -1
      SQL_SharedTools = -1
      SQL_BC_DEP = -1
      Analysis_Server = -1
      AnalysisDataFiles = -1
      AnalysisSharedTools = -1
      RS_Server = -1
      RS_Web_Interface = -1
      RS_SharedTools = -1
      Notification_Services = -1
      NS_Engine = -1
      NS_Client = -1
      SQL_DTS = -1
      Client_Components = -1
      Connectivity = -1
      SQL_Tools90 = -1
      SQL_WarehouseDevWorkbench = -1
      SDK = -1
      SQLXML = -1
      Tools_Legacy = -1
      TOOLS_BC_DEP = -1
      SQL_Documentation = -1
      SQL_BooksOnline = -1
      SQL_DatabaseSamples = -1
      SQL_AdventureWorksSamples = -1
      SQL_AdventureWorksDWSamples = -1
      SQL_AdventureWorksASSamples = -1
      SQL_Samples = -1
Complete: GenerateRequestsAction at: 2007/9/4 14:23:28, returned true
Running: CreateProgressWindowAction at: 2007/9/4 14:23:28
Complete: CreateProgressWindowAction at: 2007/9/4 14:23:28, returned true
Running: ScheduleActionAction at: 2007/9/4 14:23:28
Complete: ScheduleActionAction at: 2007/9/4 14:23:28, returned true
Skipped: InstallASAction.11
Skipped: Action "InstallASAction.11" was not run.  Information reported during analysis:
No install request found for package: "sqlsupport", referred by package: "as", install will be skipped as a result.
Skipped: InstallASAction.18
Skipped: Action "InstallASAction.18" was not run.  Information reported during analysis:
No install request found for package: "owc11", referred by package: "as", install will be skipped as a result.
Skipped: InstallASAction.22
Skipped: Action "InstallASAction.22" was not run.  Information reported during analysis:
No install request found for package: "bcRedist", referred by package: "as", install will be skipped as a result.
Skipped: InstallASAction.9
Skipped: Action "InstallASAction.9" was not run.  Information reported during analysis:
No install request found for package: "msxml6", referred by package: "as", install will be skipped as a result.
Skipped: InstallDTSAction
Skipped: Action "InstallDTSAction" was not run.  Information reported during analysis:
No install request found for package: "dts", install will be skipped as a result.
Skipped: InstallDTSAction.11
Skipped: Action "InstallDTSAction.11" was not run.  Information reported during analysis:
No install request found for package: "sqlsupport", referred by package: "dts", install will be skipped as a result.
Skipped: InstallDTSAction.12
Skipped: Action "InstallDTSAction.12" was not run.  Information reported during analysis:
No install request found for package: "sqlncli", referred by package: "dts", install will be skipped as a result.
Skipped: InstallDTSAction.18
Skipped: Action "InstallDTSAction.18" was not run.  Information reported during analysis:
No install request found for package: "owc11", referred by package: "dts", install will be skipped as a result.
Skipped: InstallDTSAction.22
Skipped: Action "InstallDTSAction.22" was not run.  Information reported during analysis:
No install request found for package: "bcRedist", referred by package: "dts", install will be skipped as a result.
Skipped: InstallDTSAction.9
Skipped: Action "InstallDTSAction.9" was not run.  Information reported during analysis:
No install request found for package: "msxml6", referred by package: "dts", install will be skipped as a result.
Skipped: InstallNSAction
Skipped: Action "InstallNSAction" was not run.  Information reported during analysis:
No install request found for package: "ns", install will be skipped as a result.
Skipped: InstallNSAction.11
Skipped: Action "InstallNSAction.11" was not run.  Information reported during analysis:
No install request found for package: "sqlsupport", referred by package: "ns", install will be skipped as a result.
Skipped: InstallNSAction.12
Skipped: Action "InstallNSAction.12" was not run.  Information reported during analysis:
No install request found for package: "sqlncli", referred by package: "ns", install will be skipped as a result.
Skipped: InstallNSAction.18
Skipped: Action "InstallNSAction.18" was not run.  Information reported during analysis:
No install request found for package: "owc11", referred by package: "ns", install will be skipped as a result.
Skipped: InstallNSAction.22
Skipped: Action "InstallNSAction.22" was not run.  Information reported during analysis:
No install request found for package: "bcRedist", referred by package: "ns", install will be skipped as a result.
Skipped: InstallNSAction.9
Skipped: Action "InstallNSAction.9" was not run.  Information reported during analysis:
No install request found for package: "msxml6", referred by package: "ns", install will be skipped as a result.
Skipped: InstallRSAction.11
Skipped: Action "InstallRSAction.11" was not run.  Information reported during analysis:
No install request found for package: "sqlsupport", referred by package: "rs", install will be skipped as a result.
Skipped: InstallRSAction.18
Skipped: Action "InstallRSAction.18" was not run.  Information reported during analysis:
No install request found for package: "owc11", referred by package: "rs", install will be skipped as a result.
Skipped: InstallRSAction.22
Skipped: Action "InstallRSAction.22" was not run.  Information reported during analysis:
No install request found for package: "bcRedist", referred by package: "rs", install will be skipped as a result.
Skipped: InstallSqlAction
Skipped: Action "InstallSqlAction" was not run.  Information reported during analysis:
No install request found for package: "sql", install will be skipped as a result.
Skipped: InstallSqlAction.11
Skipped: Action "InstallSqlAction.11" was not run.  Information reported during analysis:
No install request found for package: "sqlsupport", referred by package: "sql", install will be skipped as a result.
Skipped: InstallSqlAction.12
Skipped: Action "InstallSqlAction.12" was not run.  Information reported during analysis:
No install request found for package: "sqlncli", referred by package: "sql", install will be skipped as a result.
Skipped: InstallSqlAction.18
Skipped: Action "InstallSqlAction.18" was not run.  Information reported during analysis:
No install request found for package: "owc11", referred by package: "sql", install will be skipped as a result.
Skipped: InstallSqlAction.21
Skipped: Action "InstallSqlAction.21" was not run.  Information reported during analysis:
No install request found for package: "sqlwriter", referred by package: "sql", install will be skipped as a result.
Skipped: InstallSqlAction.22
Skipped: Action "InstallSqlAction.22" was not run.  Information reported during analysis:
No install request found for package: "bcRedist", referred by package: "sql", install will be skipped as a result.
Skipped: InstallSqlAction.9
Skipped: Action "InstallSqlAction.9" was not run.  Information reported during analysis:
No install request found for package: "msxml6", referred by package: "sql", install will be skipped as a result.
Skipped: InstallToolsAction.11
Skipped: Action "InstallToolsAction.11" was not run.  Information reported during analysis:
No install request found for package: "sqlsupport", referred by package: "tools", install will be skipped as a result.
Skipped: InstallToolsAction.12
Skipped: Action "InstallToolsAction.12" was not run.  Information reported during analysis:
No install request found for package: "sqlncli", referred by package: "tools", install will be skipped as a result.
Skipped: InstallToolsAction.13
Skipped: Action "InstallToolsAction.13" was not run.  Information reported during analysis:
No install request found for package: "PPESku", referred by package: "tools", install will be skipped as a result.
Skipped: InstallToolsAction.18
Skipped: Action "InstallToolsAction.18" was not run.  Information reported during analysis:
No install request found for package: "owc11", referred by package: "tools", install will be skipped as a result.
Skipped: InstallToolsAction.20
Skipped: Action "InstallToolsAction.20" was not run.  Information reported during analysis:
No install request found for package: "BOL", referred by package: "tools", install will be skipped as a result.
Skipped: InstallToolsAction.22
Skipped: Action "InstallToolsAction.22" was not run.  Information reported during analysis:
No install request found for package: "bcRedist", referred by package: "tools", install will be skipped as a result.
Skipped: InstallToolsAction.9
Skipped: Action "InstallToolsAction.9" was not run.  Information reported during analysis:
No install request found for package: "msxml6", referred by package: "tools", install will be skipped as a result.
Skipped: InstallASAction
Skipped: Action "InstallASAction" was not run.  Information reported during analysis:
No install request found for package: "as", install will be skipped as a result.
Skipped: InstallNSAction.10
Skipped: Action "InstallNSAction.10" was not run.  Information reported during analysis:
No install request found for package: "sqlxml4", referred by package: "ns", install will be skipped as a result.
Skipped: InstallRSAction
Skipped: Action "InstallRSAction" was not run.  Information reported during analysis:
No install request found for package: "rs", install will be skipped as a result.
Skipped: InstallToolsAction
Skipped: Action "InstallToolsAction" was not run.  Information reported during analysis:
No install request found for package: "tools", install will be skipped as a result.
Skipped: InstallToolsAction.10
Skipped: Action "InstallToolsAction.10" was not run.  Information reported during analysis:
No install request found for package: "sqlxml4", referred by package: "tools", install will be skipped as a result.
Skipped: RepairForBackwardsCompatRedistAction
Skipped: Action "RepairForBackwardsCompatRedistAction" was not run.  Information reported during analysis:
Action: "RepairForBackwardsCompatRedistAction" will be skipped due to the following condition:
Condition "sql was successfully upgraded." returned false.
Skipped: UninstallForMSDE2000Action
Skipped: Action "UninstallForMSDE2000Action" was not run.  Information reported during analysis:
Action: "UninstallForMSDE2000Action" will be skipped due to the following condition:
Condition "Action: InstallSqlAction was skipped." returned true.
Skipped: UninstallForSQLAction
Skipped: Action "UninstallForSQLAction" was not run.  Information reported during analysis:
Action: "UninstallForSQLAction" will be skipped due to the following condition:
Condition "Action: InstallSqlAction was skipped." returned true.
Skipped: UninstallForRS2000Action
Skipped: Action "UninstallForRS2000Action" was not run.  Information reported during analysis:
Action: "UninstallForRS2000Action" will be skipped due to the following condition:
Condition "Action: InstallRSAction was skipped." returned true.
Running: ReportChainingResults at: 2007/9/4 14:23:28
Complete: ReportChainingResults at: 2007/9/4 14:23:28, returned true
Delay load of action "UploadDrWatsonLogAction" returned nothing. No action will occur as a result.
Message pump returning: 0
Comment
Watch Question

do you have Microfost .NET Framework 2.0 installed

Author

Commented:
Yes, .Net framework 2.0 (and 3 updates) are installed.
Please look at the %Program Files%\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup*_Core.log file.  It should have a bit of
information in it saying what the conflict is and some GUIDs indicating
the product codes of the conflicting programs.  The section you are looking
for will look something like this (and may repeat):
 
    Running: PerformSCCAction2 at: 2004/6/27 13:54:12
    Product "{982DB00A-9C4E-436B-8707-18E113BAA44C}" versioned
    9.00.823 is not compatible with current builds of SQL
    Server.Expected at least version: 9.00.849
    The Product Name is "Microsoft SQL Server 2005 Analysis
    Services Beta 2"
 
In this case, the offending product is Microsoft SQL Server 2005 Analysis
Services Beta 2" with a product code of
"{982DB00A-9C4E-436B-8707-18E113BAA44C}"
 
If the programs are still visible in the Add/Remove Programs control panel (ARP),
please remove them in the order specified by the readme file.  If they are not in
ARP, please try the Windows Installer clean up tool.
http://download.microsoft.com/download/E/9/D/E9D80355-7AB4-45B8-80E8-983A48D5E1BD/msicuu2.exe

Author

Commented:
Hi,

Thanks for your quick replay.
Here is my file but I don't see what it wrong. I hope you do :-)


Microsoft SQL Server 2005 Setup beginning at Thu Oct 04 14:22:27 2007
Process ID      : 920
C:\MSDE2005\setup.exe Version: 2005.90.1399.0
Running: LoadResourcesAction at: 2007/9/4 14:22:27
Complete: LoadResourcesAction at: 2007/9/4 14:22:27, returned true
Running: ParseBootstrapOptionsAction at: 2007/9/4 14:22:27
Loaded DLL:C:\MSDE2005\xmlrw.dll Version:2.0.3604.0
Complete: ParseBootstrapOptionsAction at: 2007/9/4 14:22:27, returned true
Running: ValidateWinNTAction at: 2007/9/4 14:22:27
Complete: ValidateWinNTAction at: 2007/9/4 14:22:27, returned true
Running: ValidateMinOSAction at: 2007/9/4 14:22:27
Complete: ValidateMinOSAction at: 2007/9/4 14:22:27, returned true
Running: PerformSCCAction at: 2007/9/4 14:22:27
Complete: PerformSCCAction at: 2007/9/4 14:22:27, returned true
Running: ActivateLoggingAction at: 2007/9/4 14:22:27
Complete: ActivateLoggingAction at: 2007/9/4 14:22:27, returned true
Delay load of action "DetectPatchedBootstrapAction" returned nothing. No action will occur as a result.
Action "LaunchPatchedBootstrapAction" will be skipped due to the following restrictions:
Condition "EventCondition: __STP_LaunchPatchedBootstrap__920" returned false.
Running: PerformSCCAction2 at: 2007/9/4 14:22:27
Loaded DLL:C:\WINDOWS\system32\msi.dll Version:3.1.4000.4039
Loaded DLL:C:\WINDOWS\system32\msi.dll Version:3.1.4000.4039
Complete: PerformSCCAction2 at: 2007/9/4 14:22:27, returned true
Running: PerformDotNetCheck at: 2007/9/4 14:22:27
Complete: PerformDotNetCheck at: 2007/9/4 14:22:28, returned true
Running: ComponentUpdateAction at: 2007/9/4 14:22:28
Complete: ComponentUpdateAction at: 2007/9/4 14:23:6, returned true
Running: DetectLocalBootstrapAction at: 2007/9/4 14:23:6
Complete: DetectLocalBootstrapAction at: 2007/9/4 14:23:6, returned true
Running: LaunchLocalBootstrapAction at: 2007/9/4 14:23:6
Error: Action "LaunchLocalBootstrapAction" threw an exception during execution.  Error information reported during run:
"C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\setup.exe" finished and returned: 0
Aborting queue processing as nested installer has completed
Message pump returning: 0
hope this site helps you

http://www.petefreitag.com/item/458.cfm

sorry I can't be more of assistance, getting busy at work.
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
I found my error :
; ADDLOCAL specifies which components to install.  If ADDLOCAL is not specified, setup will fail.

Thanks for your quick reply and helping links.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.