December 20, 2010 at 8:25 am
Hey all,
I have a server which houses two instances of SQL Server 2005 Express. I was able to remove the default instance without issue, however when uninstall the secondary named instance, it begins the uninstall and then just exits. The instance is still on the server and can still be accessed. Here is the SQLSetup log, any thoughts?
The message that is popping out to me that I'm not finding much of anything online worthwhile except for a manual removal (which never seem to have much luck with) is this: Failed to determine installSkuId due to property load failure
Microsoft SQL Server 2005 Setup beginning at Mon Dec 20 10:12:36 2010
Process ID : 816
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\setup.exe Version: 2005.90.3042.0
Running: LoadResourcesAction at: 2010/11/20 10:12:36
Complete: LoadResourcesAction at: 2010/11/20 10:12:36, returned true
Running: ParseBootstrapOptionsAction at: 2010/11/20 10:12:36
Loaded DLL:C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\xmlrw.dll Version:2.0.3609.0
Complete: ParseBootstrapOptionsAction at: 2010/11/20 10:12:36, returned true
Running: ValidateWinNTAction at: 2010/11/20 10:12:36
Complete: ValidateWinNTAction at: 2010/11/20 10:12:36, returned true
Running: ValidateMinOSAction at: 2010/11/20 10:12:36
Complete: ValidateMinOSAction at: 2010/11/20 10:12:36, returned true
Running: PerformSCCAction at: 2010/11/20 10:12:36
Complete: PerformSCCAction at: 2010/11/20 10:12:36, returned true
Running: ActivateLoggingAction at: 2010/11/20 10:12:36
Complete: ActivateLoggingAction at: 2010/11/20 10:12:36, returned true
Running: DetectPatchedBootstrapAction at: 2010/11/20 10:12:36
Complete: DetectPatchedBootstrapAction at: 2010/11/20 10:12:36, returned true
Action "LaunchPatchedBootstrapAction" will be skipped due to the following restrictions:
Condition "EventCondition: __STP_LaunchPatchedBootstrap__816" returned false.
Action "BeginBootstrapLogicStage" will be skipped due to the following restrictions:
Condition "Setup is running locally." returned true.
Running: PerformDotNetCheck2 at: 2010/11/20 10:12:36
Complete: PerformDotNetCheck2 at: 2010/11/20 10:12:36, returned true
Running: InvokeSqlSetupDllAction at: 2010/11/20 10:12:36
Loaded DLL:C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\sqlspars.dll Version:2005.90.3042.0
<Func Name='DwLaunchMsiExec'>
Examining 'sqlspars' globals to initialize 'SetupStateScope'
Opening 'MachineConfigScope' for [<ServerNameRemoved>]
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 = WEBESDB
Trying to find install through Instance Name
Install Type = 1
If possible, determine action
Failed to determine installSkuId due to property load failure.SKU is set to SKU_EXPRESS.
Source File Name: datastore\cachedpropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:27:59 2006
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "InstallSku" {"SetupStateScope", "", ""} in cache
Source File Name: datastore\propertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:28:01 2006
Function Name: SetupStateScope.InstallSku
Source Line Number: 44
----------------------------------------------------------
No collector registered for scope: "SetupStateScope"
Machine = <ServerNameRemoved>, Article = WMIServiceWin32OSWorking, Result = 0 (0x0)
Machine = <ServerNameRemoved>, Article = WMIServiceWin32CompSystemWorking, Result = 0 (0x0)
Machine = <ServerNameRemoved>, Article = WMIServiceWin32ProcessorWorking, Result = 0 (0x0)
Machine = <ServerNameRemoved>, Article = WMIServiceReadRegWorking, Result = 0 (0x0)
Machine = <ServerNameRemoved>, Article = WMIServiceWin32DirectoryWorking, Result = 0 (0x0)
Machine = <ServerNameRemoved>, Article = WMIServiceCIMDataWorking, Result = 0 (0x0)
Machine = <ServerNameRemoved>, Article = XMLDomDocument, Result = 0 (0x0)
Failed to determine installSkuId due to property load failure.SKU is set to SKU_EXPRESS.
Source File Name: datastore\cachedpropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:27:59 2006
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "InstallSku" {"SetupStateScope", "", ""} in cache
Source File Name: datastore\propertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:28:01 2006
Function Name: SetupStateScope.InstallSku
Source Line Number: 44
----------------------------------------------------------
No collector registered for scope: "SetupStateScope"
Machine = <ServerNameRemoved>, Article = Processor, Result = 0 (0x0)
Machine = <ServerNameRemoved>, Article = PhysicalMemory, Result = 0 (0x0)
Machine = <ServerNameRemoved>, Article = DiskFreeSpace, Result = 0 (0x0)
Machine = <ServerNameRemoved>, Article = OSVersion, Result = 0 (0x0)
Machine = <ServerNameRemoved>, Article = OSServicePack, Result = 0 (0x0)
Machine = <ServerNameRemoved>, Article = OSType, Result = 0 (0x0)
Machine = <ServerNameRemoved>, Article = AdminShare, Result = 0 (0x0)
Machine = <ServerNameRemoved>, Article = PendingReboot, Result = 0 (0x0)
Machine = <ServerNameRemoved>, Article = IEVersion, Result = 0 (0x0)
Machine = <ServerNameRemoved>, Article = DriveWriteAccess, Result = 0 (0x0)
Machine = <ServerNameRemoved>, Article = COMPlus, Result = 0 (0x0)
Machine = <ServerNameRemoved>, Article = ASPNETVersionRegistration, Result = 0 (0x0)
Machine = <ServerNameRemoved>, Article = MDAC25Version, Result = 0 (0x0)
Machine = <ServerNameRemoved>, Article = SKUUpgrade, Result = 0 (0x0)
*******************************************
Setup Consistency Check Report for Machine: <ServerNameRemoved>
*******************************************
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: CheckPassed
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
Article: Edition Upgrade Check, Result: CheckPassed
<Func Name='PerformDetections'>
0
<EndFunc Name='PerformDetections' Return='0' GetLastError='0'>
<EndFunc Name='DwLaunchMsiExec' Return='0' GetLastError='0'>
Complete: InvokeSqlSetupDllAction at: 2010/11/20 10:12:49, returned true
Running: SetPackageInstallStateAction at: 2010/11/20 10:12:49
1: SQL_Engine = 1
1: SQL_Data_Files = 1
1: SQL_Replication = 1
1: SQL_FullText = 2
1: SQL_SharedTools = 1
1: SQL_BC_DEP = 2
2: Analysis_Server = 2
2: AnalysisDataFiles = 2
2: AnalysisSharedTools = 2
3: RS_Server = 2
3: RS_Web_Interface = 2
3: RS_SharedTools = 2
4: Notification_Services = 2
4: NS_Engine = 2
4: NS_Client = 2
5: SQL_DTS = 2
6: Client_Components = 2
6: TOOLS_BC_DEP = 2
6: Connectivity = 2
6: Tools_Legacy = 2
6: SQL_Tools90 = 2
6: SQL_WarehouseDevWorkbench = 2
6: SDK = 2
6: SQLXML = 2
6: SQL_BooksOnline = 2
6: SQL_Documentation = 2
6: SQL_Samples = 2
6: SQL_DatabaseSamples = 2
6: SQL_AdventureWorksSamples = 2
6: SQL_AdventureWorksDWSamples = 2
6: SQL_AdventureWorksASSamples = 2
6: SQL_SSMSEE = 2
Complete: SetPackageInstallStateAction at: 2010/11/20 10:12:50, returned true
Running: DeterminePackageTransformsAction at: 2010/11/20 10:12:50
Complete: DeterminePackageTransformsAction at: 2010/11/20 10:12:50, returned true
Running: ValidateSetupPropertiesAction at: 2010/11/20 10:12:50
Complete: ValidateSetupPropertiesAction at: 2010/11/20 10:12:50, returned true
Running: OpenPipeAction at: 2010/11/20 10:12:50
Complete: OpenPipeAction at: 2010/11/20 10:12:50, returned false
Error: Action "OpenPipeAction" failed during execution.
Running: CreatePipeAction at: 2010/11/20 10:12:50
Complete: CreatePipeAction at: 2010/11/20 10:12:50, 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: 2010/11/20 10:12:50
Complete: PopulateMutatorDbAction at: 2010/11/20 10:12:50, returned true
Running: GenerateRequestsAction at: 2010/11/20 10:12:50
SQL_Engine = 2
SQL_Data_Files = 2
SQL_Replication = 2
SQL_FullText = -1
SQL_SharedTools = 2
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_SSMSEE = -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: 2010/11/20 10:12:51, returned true
Running: CreateProgressWindowAction at: 2010/11/20 10:12:51
Complete: CreateProgressWindowAction at: 2010/11/20 10:12:51, returned true
Running: ScheduleActionAction at: 2010/11/20 10:12:51
Complete: ScheduleActionAction at: 2010/11/20 10:12:52, 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.
Running: InstallSqlAction at: 2010/11/20 10:12:52
Installing: sql on target: <ServerNameRemoved>
Error: MsiOpenDatabase failed with 110
Complete: InstallSqlAction at: 2010/11/20 10:12:52, returned true
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.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: 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.23
Skipped: Action "InstallToolsAction.23" was not run. Information reported during analysis:
No install request found for package: "ssmsee", 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: 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.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.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
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.
Error: Action "UninstallForMSDE2000Action" failed during execution. Error information reported during run:
Action: "UninstallForMSDE2000Action" will be marked as failed due to the following condition:
Condition "sql was successfully upgraded." returned false.
Installation of package: "patchMSDE2000" failed due to a precondition.
Error: Action "UninstallForSQLAction" failed during execution. Error information reported during run:
Action: "UninstallForSQLAction" will be marked as failed due to the following condition:
Condition "sql was successfully upgraded." returned false.
Installation of package: "patchLibertySql" failed due to a precondition.
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.
Error: Action "ExposeVistaClusteredResources" failed during execution. Error information reported during run:
Action: "ExposeVistaClusteredResources" will be marked as failed due to the following condition:
Condition "The Clustered SQL Server instance that hosts is installed." returned false.
Running: ReportChainingResults at: 2010/11/20 10:12:52
Complete: ReportChainingResults at: 2010/11/20 10:12:52, returned true
Delay load of action "UploadDrWatsonLogAction" returned nothing. No action will occur as a result.
Message pump returning: 0
December 20, 2010 at 10:58 am
An annoying bug with SQL Server Express and multiple instances. You will most likely need to uninstall the second instance via command line. Take a look at the template.ini in the SQL Server Express installation folder. It contains command line parameters to remove instances of SQL Server.
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
December 21, 2010 at 2:55 am
Hi Chris,
I do not see a template.ini anywhere, so I did a quick search and the syntax appears to be: sqlexpr.exe /qb REMOVE=ALL INSTANCENAME=<InstanceName>
I ran through that, and it appeared to make it further than using appwiz, however ... it did not uninstall.
I also then tried hitting change, instead of remove (in appwiz), and when selecting uninstall, it reported successful (after 3 seconds), and yet again, the instance remains.
Thoughts?
Thanks
December 21, 2010 at 3:24 am
What about reverse approach: try to re-install it to repair the instance, then the uninstall might work better.
December 21, 2010 at 9:57 am
Unless I'm missing something, you can't do a repair in express can you?
However, I went forth with doing a fresh install and let it default to \SQLEXPRESS. I then tried to remove the original named instance to no avail. It then let me remove the newly installed \SQLEXPRESS instance though.
Any additional thoughts on this?
December 22, 2010 at 12:40 am
Adam Bean (12/21/2010)
Unless I'm missing something, you can't do a repair in express can you?
Yes, it seems you're right. I didn't know - I've never needed to reinstall a SQL instance.
I still think that a reinstall should help - and that it might be quite easy to force a tricky reinstall: stopping the service and removing a few registry keys should be the way to do it. Anyway, I'd first try the process on a test box.
Why do you need to remove the SQL instance? If you wish to clean up after some unused app, I think the best way might be just disabling the SQL service: the failing unistall process means that there's somethink wrong on the server box - and any attempt to overcome it might make thinks even worse - you'll never know in advance 🙂
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply