I am having very simular problems with installation and uninstallation as Laydee is having.
There had never been another instance of any type installed on my local computer, I installed SQLExpress because we want to begin migrating to something for the future, and after reviewing all the other options out there decided SQL Server 2005 would be the most efficient use of time and resources.
The initial installation was successful, and we were doing well, writing the new GUI in VB6, then decided we would try VB 2005 in order to take advantage of the .NET framework, stored queries, etc. the first time we accessed the database (Thank God it wasn't the production database) it corrupted something, somewhere and we never could get anything to work. In addition, even the sa login on the instance (the only instance, btw) SQLExpress wouldn't work.
Consequently did an uninstall. But it apparently did not uninstall cleanly.
Re-installed, and could not re-create the instance SQLExpress, since the installation package thinks it's still installed.
Uninstalled again, completely. Online E-Book, sample databases, the whole 9 yards. Even went into the program files directory and deleted the associated directory, and did a re-install. Still was unable to create the named instance SQLExpress. same problem, it thinks that instance already exist.
Uninstalled again, deleted the directory, even went through the registry with a fine toothed comb getting rid of anything that appeared to refer to that instance (SQLExpress), which is no easy task since that instance is also the name of the software package. Re-installed. Same game.
We are about to the point of giving up since we have spent so much time just on trying to get the engine installed again properly that we are considering other, apparently more reliable options. To bad. We already bought SQL Server 2005, and it appears it will be sitting in the vault unopened. If something is this unstable we can't risk installing it on the production systems.
So before I have to declare this whole debacle a total loss, anyone have any suggestions?
I am wondering if I am going to encounter any problems when I uninstall SQL Server 2005 standard edition and install SQL Server 2005 Express Edition.
I am asking this as I found out today that a project I am developing (have been working on this for a few weeks now) that we're to be using Express edition. I am just hoping that I'm not going to come across any problems by doing this?
I know people have put up this question before but I wanted some updated feedback. I just bought Visual Studio Tools for MS Office and it comes with SQL Developer Edition. I am currently using VS.net 2003 and using MSDE with MS SQL Web Data Administrator to build my dbs then export the sql script. I was wondering if I should uninstall the MSDE and install the DEv Ed so I can develop all the triggers, constraints etc through Enterprise Manager, therefore having a better setup DB. I know you can do all that through code but why reinvent the wheel. One last question, with the Dev Ed you just export the schema and scripts to a machine with SQL Server installed once the DB is ready for deployment ? Is this correct? I lied one more question, does the uninstall of MSDE leave much of a mess, what is the best way to get rid of it. Thanks in advance Pete
After going through "Add and Remove Programs" and removing all components of SQL Server 2005 Standard Edition on my desktop I get an error telling me there is a copy already installed and to remove it before continuing. Well nothing shows up under "Add and Remove Programs"; Windows cleanup shows none of the SQL Server components; a check of the register (HOTKEYS.../unistall) have no SQL Server entries; under services all SQL Server services are disabled and not running.
I have followed all the steps in http://support.microsoft.com/kb/909967 (Describes how to uninstall an instance of SQL Server 2005 manually).
Anyone out there got a solution? (Visual Studio 2005 eval is loaded on the box)
I'm the following encountering WMI error message when invoking SQL2005 setup.
The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine CAPRICORN Error:2147942405 (0x80070005).
For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=setup.rll&EvtID=70342
I'ver found other postings related to WMI errors and tried the WMI fix batch, but to no avail. I noted the error code I have is 2147942405 which is different from other postings. And from examining setup log generated, this seems to be security related, but cannot find much help combing thru msdn/google, etc
SCCOpenPerformer Added machine: CAPRICORN RegisterAddCheckArticleCallbackFunction registered callback function
Calling add article callback function for article: WMIServiceWin32OSWorking Callback function returned TRUE Adding Article... Article Id: WMIServiceWin32OSWorking Article type: 4, ARTICLE_WMI_TYPE_VALUES Number of value: 2 Value: 1 Type: ARTICLE_WMI_TYPE_PROPERTY Namespace: cimv2 Class name: Win32_OperatingSystem Property name: OSLanguage Property type: 2 Value: 2 Type: ARTICLE_WMI_TYPE_PROPERTY Namespace: cimv2 Class name: Win32_OperatingSystem Property name: SystemDirectory Property type: 2
Calling add article callback function for article: WMIServiceWin32CompSystemWorking Callback function returned TRUE Adding Article... Article Id: WMIServiceWin32CompSystemWorking Article type: 4, ARTICLE_WMI_TYPE_VALUES Number of value: 1 Value: 1 Type: ARTICLE_WMI_TYPE_PROPERTY Namespace: cimv2 Class name: Win32_ComputerSystem Property name: NumberOfProcessors Property type: 2
Calling add article callback function for article: WMIServiceWin32ProcessorWorking Callback function returned TRUE Adding Article... Article Id: WMIServiceWin32ProcessorWorking Article type: 4, ARTICLE_WMI_TYPE_VALUES Number of value: 1 Value: 1 Type: ARTICLE_WMI_TYPE_PROPERTY Namespace: cimv2 Class name: Win32_Processor Property name: CpuStatus Property type: 2
Calling add article callback function for article: WMIServiceReadRegWorking Callback function returned TRUE Adding Article... Article Id: WMIServiceReadRegWorking Article type: 4, ARTICLE_WMI_TYPE_VALUES Number of value: 1 Value: 1 Type: ARTICLE_WMI_TYPE_REGISTRY DefKey: 0x80000002 Subkey name: SOFTWAREMicrosoftWindowsCurrentVersion Value name: ProgramFilesDir Registry type: 4
Calling add article callback function for article: WMIServiceWin32DirectoryWorking Callback function returned TRUE Adding Article... Article Id: WMIServiceWin32DirectoryWorking Article type: 3, ARTICLE_WMI_TYPE_CLASS Namespace: cimv2 WQL Query: Select * from Win32_Directory where name='C:\'
Calling add article callback function for article: WMIServiceCIMDataWorking Callback function returned TRUE Adding Article... Article Id: WMIServiceCIMDataWorking Article type: 3, ARTICLE_WMI_TYPE_CLASS Namespace: cimv2 WQL Query: Select * from CIM_DataFile where name='C:\'
Calling add article callback function for article: XMLDomDocument Callback function returned TRUE Adding Article... Article Id: XMLDomDocument Article type: 1, ARTICLE_TYPE_GENERIC_FUNCTION RegisterCallbackFunction registered callback function Callback filter = 0x6
Performing check on local machine CAPRICORN Connecting to CAPRICORN machine ConnectServer returned 0 (0x0) ConnectServer returned 0 (0x0) Openning namespace \rootcimv2 GetNamespace \rootcimv2 returned 0 (0x0) Creating class instance Win32_ComputerSystem CreateInstanceEnum Win32_ComputerSystem returned 0 (0x0) Enumerating the first class of Win32_ComputerSystem EnumClass of Win32_ComputerSystem returned 2147942405 (0x80070005) Creating class instance Win32_OperatingSystem CreateInstanceEnum Win32_OperatingSystem returned 0 (0x0) Enumerating the first class of Win32_OperatingSystem EnumClass of Win32_OperatingSystem returned 2147942405 (0x80070005) Creating class instance Win32_OperatingSystem CreateInstanceEnum Win32_OperatingSystem returned 0 (0x0) Enumerating the first class of Win32_OperatingSystem EnumClass of Win32_OperatingSystem returned 2147942405 (0x80070005) Creating class instance Win32_Processor CreateInstanceEnum Win32_Processor returned 0 (0x0) Enumerating the first class of Win32_Processor EnumClass of Win32_Processor returned 2147942405 (0x80070005) Openning namespace \rootdefault GetNamespace \rootdefault returned 0 (0x0) Getting method EnumValues in StdRegProv class GetMethod returned 0 (0x0) Executing method EnumValues in StdRegProv class ExecMethod returned 2147942405 (0x80070005)
Processing article WMIServiceWin32OSWorking Scc Error: 50026 (0xc36a) Error code: 2147942405 (0x80070005) Calling callback function for reason: 0x2 Callback function returned TRUE
Processing article WMIServiceWin32CompSystemWorking Scc Error: 50026 (0xc36a) Error code: 2147942405 (0x80070005) Calling callback function for reason: 0x2 Callback function returned TRUE
Processing article WMIServiceWin32ProcessorWorking Scc Error: 50026 (0xc36a) Error code: 2147942405 (0x80070005) Calling callback function for reason: 0x2 Callback function returned TRUE
Processing article WMIServiceReadRegWorking Scc Error: 50024 (0xc368) Error code: 2147942405 (0x80070005) Calling callback function for reason: 0x2 Callback function returned TRUE
Processing article WMIServiceWin32DirectoryWorking Openning namespace \rootcimv2 GetNamespace \rootcimv2 returned 0 (0x0) Scc Error: 50022 (0xc366) Error code: 70347 (0x112cb) Calling callback function for reason: 0x2 Callback function returned TRUE
Processing article WMIServiceCIMDataWorking Openning namespace \rootcimv2 GetNamespace \rootcimv2 returned 0 (0x0) Scc Error: 50022 (0xc366) Error code: 70347 (0x112cb) Calling callback function for reason: 0x2 Callback function returned TRUE
Processing article XMLDomDocument Scc Error: 0 (0x0) Error code: 0 (0x0) Calling callback function for reason: 0x4 Callback function returned TRUE SccPerformer closed.
Trying to use WMI to monitor a SQLExpress DB and not getting anywhere. In fact, wmiprvse.exe croaks.
Here's the query I'm running from within CIM Studio: select * from Win32_PerfRawData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSDatabases
(Just did a search for SQL and found this class)
When trying to get an instance, WMIPRVSE throws this exception: The exception unknown software exception (0xc000000d) occurred int he application at location 0x7814454d.
Ok to that, then another msgBox shows up with a title of
"Multiview Message" and text as below: Win32: The remote procedure call failed. An error occurred while attempting to retrieve the list of objects.
Any suggestions on this would be appreciated. Or perhaps another WMI class to use?
(XP Pro SP2, current with the patches; SQLExpress and MSDE both running)
********************************************************************************** Processes Locking Files Process Name Feature Type User Name PID
********************************************************************************** Product Installation Status Product : Express Database Services (SQLEXPRESS) Product Version (Previous): 1399 Product Version (Final) : Status : Failure Log File : D:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQL9Express_Hotfix_KB921896_SQLEXPR.EXE SQL Express Features : SQL_Data_Files,SQL_Engine,SQL_Replication,SQL_SharedTools Error Number : 1332 Error Description : *** Shared String ID 1332 Not Found *** ----------------------------------------------------------------------------------
********************************************************************************** Summary One or more products failed to install, see above for details Exit Code Returned: 1332
We are trying to install the Standard Edition of SQL Server 2005. We already have SQL Express installed. Standard won't install and Express won't uninstall.
We have tried every suggestion we can find and some we made up. When we try to install Standard, we get to the bit where you choose what you want to install and the only thing available is workstation components.
There are so many cases of this on the Internat that I can't believe MS have not solved the issue. And I am stunned that they want to charge us more money to talk to us about how to fix something we just paid them an arm and a leg for!
What do I need to tell you to get some idea of where to go next with this?
I need some space on my machine. I have SQL 7 on it, and I want to completely remove it from my system. I have done the following:
1. Used the SQL Uninstall to uninstall 2. Removed MSSQL7 folder using win explorer 3. MSSQL folder in (HKEY_LOCALMACHINESOFTWAREMICROSOFTMSSQL7) 4. Rebooted the machine
Yet I see traces of SQL7 on my machine! When I tried to reinstall, it told me that there was a license already on the machine.
Hello! I tried to uninstall SQL Server 7.0. And I have got error message: " uninstallShieid has detected that c:mssql7Binnsqlmangr.exe in use. please close the application using this file and launch uninstallShield again." I closed all aplications and I stopped all services at SQL Server Service Manager. Somebody knows what else uninstallShield programm wants me to do?. Thank you, Alona
I mistakenly installed SQL express using remote desktop, now I cannot do anything in it. Nobody could help with that either but based on posts with the same message, I tried uninstalling sql server. It wouldn't uninstall nor can I repair or reinstall. Uninstalling thru Add or Remove Programs only resulted in the program listing being removed from Add or Remove Programs. Most of the sql server programs are still installed. They can be run but continue to malfunction. When I try a new installation, I get a message that the programs are already installed. How can I correct this without reinstalling Win XP? Please help. Your valuable feedback is greatly appreciated.
Somehow, ignorantly, I managed to install SQL 7 SP2 on a computer that didn't have SQL 7 yet, only 6.5. Don't ask me how it allowed this, but it did. In any case, now I have a problem. When I try to install SQL 7, it tells me I can't install an older version than what already exists, and that I should uninstall it first. Well, I looked in the Control Panel, but there's no entry there to uninstall. I deleted all the SQL 7.0 keys I could find in the registry, and still it refuses to install. Can anyone tell me just what the heck I have to delete in order to get SQL 7 to install on this machine?
sql 7.0 was previously installed alongside sql 6.5 in the same directory. i now need to uninstall 6.5. microsoft cautions the following -
Caution If you are installing Microsoft® SQL Server™ version 7.0 alongside SQL Server 6.x on the same computer, do not install SQL Server 7.0 in the same directory as SQL Server 6.x.
will there be a problem if i try to use the standard uninstall utility for 6.5? what is the work around for this? please advise.
While trying to 'tidy up' I ran into this error when trying to ininstall an SQL 7.0 beta: 'Unable to locate the installation log file C:MSSQL7Uninst.isu Uninstall will not continue'.
Search confirms that such a file is not present. I would reinstall (with the final product) then try Uninstall again, but disk space prohibits this.
Running version 6.5 on Windows 2000 and I am unable to find an obvious uninstall utility from the start menu or installation cd...can someone please inform me of how to do this?? Thanks!
I had replication installed between my two SQL servers with no problems until I changed the Primary Key attribute on one of the replicating tables. After that one change, I continued to receive errors for one week about failed replication (due to this one table!). I tried removing Replication so that I could "reinstall" it, but my Publicating server will not show the option to 'Install Publishing..' in the Server Tool. I followed the advice found on "SWYNK.com/ch17.asp" as it stated:
"Uninstalling Replication Completely Carefully consider all options before you opt to remove replication entirely from the system. This operation shuts down all replication to all subscribing servers, and it does so in a somewhat brute force manner by removing the replication option from the server and deleting the distribution database.
There are three steps for uninstalling replication in SQL Server, as follows:
1)Discontinue all replication services, all publication and subscription services, between this system and other servers with which it is working. 2)Turn off the replication option at the server engine level. 3)Drop the distribution database. "
I still cannot get the option to Install Publishing again. In fact, I continue to get the option to "Uninstall Publishing.." in the Server tool. I stopped/started services dozens of times with no luck. Any help would be great !!!!
Hi friends I insalled Visual Studio 2005 standard edi on XP machine. as you all know it also installs sqlexpress. i want to uninstall this sqlexpress as i also have sql server 2005 standard edition on my machine.
but i dont see any option to uninstall in add/remove programs or in start menu for sqlexpress. any ideas on this ? Thanks for your help.
Hello there!I have on a machine (named SV-ISDEV) two MSSQL instances installed. Thelocal and the SV-ISDEVPREPROD. Now I want to unistall the PREPRODinstance.Which is the correct way to do this?Do I have to run the installation again?Thanks
I have SQL Server cluster. When I tried to install SSIS on the Active node, it was installed but the SSIS service did not start. Event log says that it is time out error. There is no other error listed.
I have been following this document to uninstall SQL 2005 for a virtual server: http://support.microsoft.com/kb/909967 and when following this step: start /wait msiexec /x GUID /l*v c:sql_uninstall.log for the SQL Server 2005 GUID I get the following error: 'This installer package could not be opened. Verify that the package exists and that you can access it'.
There also is not a sql_uninstall.log file on the server. All other components have uninstalled successfully using Add/Remove Programmes apart from the database engine which gets the below error: 'The set up has encountered an unexpected error while setting internal properties. The error is: Fatal error during installation.'
I have a strange problem here. How to uninstall SQLEXPRESS when it does not appear in the "Add/remove program"?
Another problem is that I can't connect to the local server using SQL Server Enterprise manager. This is the error that i got:
"a connection could not be established to (My Computer name)SQLEXPRESS. Reason: [SQL-DMO]you must use SQL Server 2005 management tools to connect to this server. Please verify SQL Server is running and check your SQL Server registration properties (by right-clicking on the DHH-MCSQLEXPRESS node) and try again. "
I do not want to use SQL 2005 because of some issues. All I need is SQL 2000 to run properly.
I have a copy of SQL 2000 installed locally on my notebook. I would like to remove it and install 2005 however I get the following message: unInstallShield has edetected that 'c:program filesmicrosoft SQL Server oolsinnisqle.exe' is in use. I have not run the query analyzer in some time nor do I see this process running in task manager. I do have a copy of winsql on my machine from Synametric Technologies. Not sure what I need to do to successfully remove 2000 prior to installing 2005.
I'm having problem with uninstallin Microsoft SQL server 2005. I did uninstalled it and did deleted some of it keys, because I didn't need it anymore ( I just need VS 2005 for c++ basic programming ). Now i get these messages when i start up Windows : screenshot :
Have uninstalled SQL Server many times but have message at startup (Your SQL Server installation is either corrupt or has been tampered with (Unknown package id). Please uninstall and re-run setup to correct this problem.
I can not get the reinstall to go as i get a maessage that SQL Server is already on my computer. I am no guru and need simple help on this issue.
Did a regedit and deleted wrong thing and had to reinstall XP again to run computer.
I am just in a mess. Any help would be appreciated
Under Programs and Features, there are two instances of SQL Server: "Microsoft SQL Server 2005 Express Edition" and "Microsoft SQL Server 2005 Tools Express Edition". I have no need for them, and would like to remove them. However, whenever I try to remove them, I get the error message: "The feature you are trying to use is on a network resource that is unavailable. Click OK to try again, or enter an alternate path to a folder containing the installation package 'SqlRun_Tools.msi' in the box below." Subsequently, I click on cancel, and I get the error message: "The installation source for this product is not available. Verify that the source exists and that you can access it." In addition to this, there are many registry entries that begin with "Microsoft.SqlServer." under HKEY_CLASSES_ROOT. My OS is Vista Ultimate 32-bit. Any help is appreciated. THanks.
I am currently running Windows XP Professional Service Pack2. It already has MSDE & SQL Server 2000 installed (although I just uninstalled MSDE in the vain hope that it might present the installer with a more straightforward upgrade).
I have tried installing with the default instance & a new instance (I don't really care - I just need to install the darn thing). I just want the basic database & Books On-line, nothing fancy.
Here is the Summary log, for what it's worth:
Microsoft SQL Server 2005 9.00.1399.06 ============================== OS Version : Microsoft Windows XP Professional Service Pack 2 (Build 2600) Time : Tue Feb 06 16:45:14 2007
Machine : ANTHONYY1 Product : Microsoft SQL Server Setup Support Files (English) Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0011_ANTHONYY1_SQLSupport_1.log -------------------------------------------------------------------------------- Machine : ANTHONYY1 Product : Microsoft SQL Server Native Client Product Version : 9.00.2047.00 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0011_ANTHONYY1_SQLNCLI_1.log -------------------------------------------------------------------------------- Machine : ANTHONYY1 Product : Microsoft Office 2003 Web Components Product Version : 11.0.6558.0 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0011_ANTHONYY1_OWC11_1.log -------------------------------------------------------------------------------- Machine : ANTHONYY1 Product : Microsoft SQL Server VSS Writer Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0011_ANTHONYY1_SqlWriter_1.log -------------------------------------------------------------------------------- Machine : ANTHONYY1 Product : Microsoft SQL Server 2005 Backward compatibility Product Version : 8.05.1054 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0011_ANTHONYY1_BackwardsCompat_1.log -------------------------------------------------------------------------------- Machine : ANTHONYY1 Product : MSXML 6.0 Parser (KB927977) Product Version : 6.00.3890.0 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0011_ANTHONYY1_MSXML6_1.log -------------------------------------------------------------------------------- Machine : ANTHONYY1 Product : Microsoft SQL Server Setup Support Files (English) Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0011_ANTHONYY1_SQLSupport_2.log -------------------------------------------------------------------------------- Machine : ANTHONYY1 Product : Microsoft SQL Server Native Client Product Version : 9.00.2047.00 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0011_ANTHONYY1_SQLNCLI_2.log -------------------------------------------------------------------------------- Machine : ANTHONYY1 Product : Microsoft Office 2003 Web Components Product Version : 11.0.6558.0 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0011_ANTHONYY1_OWC11_2.log -------------------------------------------------------------------------------- Machine : ANTHONYY1 Product : Microsoft SQL Server 2005 Books Online (English) Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0011_ANTHONYY1_BOL_1.log -------------------------------------------------------------------------------- Machine : ANTHONYY1 Product : Microsoft SQL Server 2005 Backward compatibility Product Version : 8.05.1054 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0011_ANTHONYY1_BackwardsCompat_2.log -------------------------------------------------------------------------------- Machine : ANTHONYY1 Product : MSXML 6.0 Parser (KB927977) Product Version : 6.00.3890.0 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0011_ANTHONYY1_MSXML6_2.log -------------------------------------------------------------------------------- Machine : ANTHONYY1 Product : SQLXML4 Error : Setup is preparing to continue with the installation. --------------------------------------------------------------------------------
Here is the SQLSetup0011_ANTHONYY1_Core(Local).log
Microsoft SQL Server 2005 Setup beginning at Tue Feb 06 16:45:14 2007 Process ID : 2560 C:Program FilesMicrosoft SQL Server90Setup Bootstrapsetup.exe Version: 2005.90.1399.0 Running: LoadResourcesAction at: 2007/1/6 16:45:14 Complete: LoadResourcesAction at: 2007/1/6 16:45:14, returned true Running: ParseBootstrapOptionsAction at: 2007/1/6 16:45:14 Loaded DLL:C:Program FilesMicrosoft SQL Server90Setup Bootstrapxmlrw.dll Version:2.0.3604.0 Complete: ParseBootstrapOptionsAction at: 2007/1/6 16:45:14, returned true Running: ValidateWinNTAction at: 2007/1/6 16:45:14 Complete: ValidateWinNTAction at: 2007/1/6 16:45:14, returned true Running: ValidateMinOSAction at: 2007/1/6 16:45:14 Complete: ValidateMinOSAction at: 2007/1/6 16:45:14, returned true Running: PerformSCCAction at: 2007/1/6 16:45:14 Complete: PerformSCCAction at: 2007/1/6 16:45:14, returned true Running: ActivateLoggingAction at: 2007/1/6 16:45:14 Complete: ActivateLoggingAction at: 2007/1/6 16:45:14, returned true Running: DetectPatchedBootstrapAction at: 2007/1/6 16:45:14 Complete: DetectPatchedBootstrapAction at: 2007/1/6 16:45:14, returned true Action "LaunchPatchedBootstrapAction" will be skipped due to the following restrictions: Condition "EventCondition: __STP_LaunchPatchedBootstrap__2560" returned false. Action "BeginBootstrapLogicStage" will be skipped due to the following restrictions: Condition "Setup is running locally." returned true. Running: PerformDotNetCheck2 at: 2007/1/6 16:45:14 Complete: PerformDotNetCheck2 at: 2007/1/6 16:45:14, returned true Running: InvokeSqlSetupDllAction at: 2007/1/6 16:45:14 Loaded DLL:C:Program FilesMicrosoft SQL Server90Setup Bootstrapsqlspars.dll Version:2005.90.1399.0 <Func Name='DwLaunchMsiExec'> Examining 'sqlspars' globals to initialize 'SetupStateScope' Opening 'MachineConfigScope' for [ANTHONYY1] 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. No Instance Name provided on the command line If possible, determine action Machine = ANTHONYY1, Article = WMIServiceWin32OSWorking, Result = 0 (0x0) Machine = ANTHONYY1, Article = WMIServiceWin32CompSystemWorking, Result = 0 (0x0) Machine = ANTHONYY1, Article = WMIServiceWin32ProcessorWorking, Result = 0 (0x0) Machine = ANTHONYY1, Article = WMIServiceReadRegWorking, Result = 0 (0x0) Machine = ANTHONYY1, Article = WMIServiceWin32DirectoryWorking, Result = 0 (0x0) Machine = ANTHONYY1, Article = WMIServiceCIMDataWorking, Result = 0 (0x0) Machine = ANTHONYY1, Article = XMLDomDocument, Result = 0 (0x0) Machine = ANTHONYY1, Article = Processor, Result = 0 (0x0) Machine = ANTHONYY1, Article = PhysicalMemory, Result = 0 (0x0) Machine = ANTHONYY1, Article = DiskFreeSpace, Result = 0 (0x0) Machine = ANTHONYY1, Article = OSVersion, Result = 0 (0x0) Machine = ANTHONYY1, Article = OSServicePack, Result = 0 (0x0) Machine = ANTHONYY1, Article = OSType, Result = 0 (0x0) Machine = ANTHONYY1, Article = iisDep, Result = 0 (0x0) Machine = ANTHONYY1, Article = AdminShare, Result = 0 (0x0) Machine = ANTHONYY1, Article = PendingReboot, Result = 70011 (0x1117b) Machine = ANTHONYY1, Article = PerfMon, Result = 0 (0x0) Machine = ANTHONYY1, Article = IEVersion, Result = 0 (0x0) Machine = ANTHONYY1, Article = DriveWriteAccess, Result = 0 (0x0) Machine = ANTHONYY1, Article = COMPlus, Result = 0 (0x0) Machine = ANTHONYY1, Article = ASPNETVersionRegistration, Result = 0 (0x0) Machine = ANTHONYY1, Article = MDAC25Version, Result = 0 (0x0) ******************************************* Setup Consistency Check Report for Machine: ANTHONYY1 ******************************************* 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: IIS Feature Requirement, Result: CheckPassed Article: Pending Reboot Requirement, Result: CheckPassed Article: Performance Monitor Counter 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'> <Func Name='DisplaySCCWizard'> CSetupBootstrapWizard returned 1 <EndFunc Name='DisplaySCCWizard' Return='0' GetLastError='183'> Failed to find help file for LCID :2057 Loaded DLL:C:Program FilesMicrosoft SQL Server90Setup Bootstrapsqlsval.dll Version:2005.90.1399.0 <EndFunc Name='DwLaunchMsiExec' Return='0' GetLastError='0'> Complete: InvokeSqlSetupDllAction at: 2007/1/6 16:49:35, returned true Running: SetPackageInstallStateAction at: 2007/1/6 16:49:35 Complete: SetPackageInstallStateAction at: 2007/1/6 16:49:36, returned true Running: DeterminePackageTransformsAction at: 2007/1/6 16:49:36 Complete: DeterminePackageTransformsAction at: 2007/1/6 16:49:47, returned true Running: ValidateSetupPropertiesAction at: 2007/1/6 16:49:47 Complete: ValidateSetupPropertiesAction at: 2007/1/6 16:49:47, returned true Running: OpenPipeAction at: 2007/1/6 16:49:47 Complete: OpenPipeAction at: 2007/1/6 16:49:47, returned false Error: Action "OpenPipeAction" failed during execution. Running: CreatePipeAction at: 2007/1/6 16:49:47 Complete: CreatePipeAction at: 2007/1/6 16:49:47, 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/1/6 16:49:47 Complete: PopulateMutatorDbAction at: 2007/1/6 16:49:47, returned true Running: GenerateRequestsAction at: 2007/1/6 16:49:47 SQL_Engine = 3 SQL_Data_Files = 3 SQL_Replication = 3 SQL_FullText = 3 SQL_SharedTools = 3 SQL_BC_DEP = 3 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 = 3 Connectivity = 3 SQL_Tools90 = 3 SQL_WarehouseDevWorkbench = 3 SDK = 3 SQLXML = 3 Tools_Legacy = 3 TOOLS_BC_DEP = 3 SQL_Documentation = 3 SQL_BooksOnline = 3 SQL_DatabaseSamples = -1 SQL_AdventureWorksSamples = -1 SQL_AdventureWorksDWSamples = -1 SQL_AdventureWorksASSamples = -1 SQL_Samples = -1 Complete: GenerateRequestsAction at: 2007/1/6 16:49:48, returned true Running: CreateProgressWindowAction at: 2007/1/6 16:49:48 Complete: CreateProgressWindowAction at: 2007/1/6 16:49:48, returned true Running: ScheduleActionAction at: 2007/1/6 16:49:48 Complete: ScheduleActionAction at: 2007/1/6 16:49:48, 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.11 at: 2007/1/6 16:49:48 Installing: sqlsupport on target: ANTHONYY1 Complete: InstallSqlAction.11 at: 2007/1/6 16:49:51, returned true Running: InstallSqlAction.12 at: 2007/1/6 16:49:51 Installing: sqlncli on target: ANTHONYY1 Complete: InstallSqlAction.12 at: 2007/1/6 16:49:55, returned true Running: InstallSqlAction.18 at: 2007/1/6 16:49:55 Installing: owc11 on target: ANTHONYY1 Complete: InstallSqlAction.18 at: 2007/1/6 16:49:56, returned true Running: InstallSqlAction.21 at: 2007/1/6 16:49:56 Installing: sqlwriter on target: ANTHONYY1 Complete: InstallSqlAction.21 at: 2007/1/6 16:49:58, returned true Running: InstallSqlAction.22 at: 2007/1/6 16:49:58 Installing: bcRedist on target: ANTHONYY1 Complete: InstallSqlAction.22 at: 2007/1/6 16:50:0, returned true Running: InstallSqlAction.9 at: 2007/1/6 16:50:0 Installing: msxml6 on target: ANTHONYY1 Complete: InstallSqlAction.9 at: 2007/1/6 16:50:2, returned true Running: InstallToolsAction.11 at: 2007/1/6 16:50:2 Installing: sqlsupport on target: ANTHONYY1 Complete: InstallToolsAction.11 at: 2007/1/6 16:50:5, returned true Running: InstallToolsAction.12 at: 2007/1/6 16:50:5 Installing: sqlncli on target: ANTHONYY1 Complete: InstallToolsAction.12 at: 2007/1/6 16:50:8, returned true 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. Running: InstallToolsAction.18 at: 2007/1/6 16:50:8 Installing: owc11 on target: ANTHONYY1 Complete: InstallToolsAction.18 at: 2007/1/6 16:50:10, returned true Running: InstallToolsAction.20 at: 2007/1/6 16:50:10 Installing: BOL on target: ANTHONYY1 Complete: InstallToolsAction.20 at: 2007/1/6 16:52:2, returned true Running: InstallToolsAction.22 at: 2007/1/6 16:52:2 Installing: bcRedist on target: ANTHONYY1 Complete: InstallToolsAction.22 at: 2007/1/6 16:52:4, returned true Running: InstallToolsAction.9 at: 2007/1/6 16:52:4 Installing: msxml6 on target: ANTHONYY1 Complete: InstallToolsAction.9 at: 2007/1/6 16:52:6, returned true 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. Running: InstallSqlAction at: 2007/1/6 16:52:7 Installing: sql on target: ANTHONYY1 Error: MsiOpenDatabase failed with 110 Failed to install package This installation package could not be opened. Contact the application vendor to verify that this is a valid Windows Installer package. Error: MsiOpenDatabase failed with 110 for MSI D:ServersSetupSqlRun_SQL.msi Setting package return code to: 1620 Complete: InstallSqlAction at: 2007/1/6 16:52:27, returned false Error: Action "InstallSqlAction" failed during execution. Error information reported during run: Target collection includes the local machine. Invoking installPackage() on local machine. Running: InstallToolsAction.10 at: 2007/1/6 16:52:27 Installing: sqlxml4 on target: ANTHONYY1 Error Code: 0x8007006e (110) Windows Error Text: The system cannot open the device or file specified.
Source File Name: sqlchainingminorbuildactionbehavior.cpp Compiler Timestamp: Mon Jun 13 14:30:04 2005 Function Name: sqls::MinorBuildActionBehavior::modifyRequest Source Line Number: 65
Complete: InstallToolsAction.10 at: 2007/1/6 16:55:59, returned false Error: Action "InstallToolsAction.10" failed during execution. Error information reported during run: Target collection includes the local machine. Invoking installPackage() on local machine. Action "InstallToolsAction" will return false due to the following preconditions: Condition "Action: InstallToolsAction.10 has finished and failed." returned true. Installation of package: "tools" failed due to a precondition. Step "InstallToolsAction" was not able to run. 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: 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: 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. Condition context: sql failed to upgrade and so the uninstall of the upgraded product will not occur. 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. Condition context: sql failed to upgrade and so the uninstall of the upgraded product will not occur. 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. Condition context: sql failed to upgrade and so the uninstall of the upgraded product will not occur. 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. Running: ReportChainingResults at: 2007/1/6 16:55:59 Error: Action "ReportChainingResults" threw an exception during execution. One or more packages failed to install. Refer to logs for error details. : 1620 Error Code: 0x80070654 (1620) Windows Error Text: This installation package could not be opened. Contact the application vendor to verify that this is a valid Windows Installer package.
Source File Name: sqlchainingsqlchainingactions.cpp Compiler Timestamp: Thu Sep 1 22:23:05 2005 Function Name: sqls::ReportChainingResults::perform Source Line Number: 3097
---- Context ----------------------------------------------- sqls::HostSetupPackageInstallerSynch::postCommit sqls::HighlyAvailablePackage::preInstall led due to cancel code received from cancel source: 29539
...and here is the SQLSetup0011_ANTHONYY1_SQL.log:
=== Verbose logging started: 06/02/2007 16:52:14 Build type: SHIP UNICODE 3.01.4000.2435 Calling process: C:Program FilesMicrosoft SQL Server90Setup Bootstrapsetup.exe === MSI (c) (00:54) [16:52:14:284]: Resetting cached policy values MSI (c) (00:54) [16:52:14:284]: Machine policy value 'Debug' is 0 MSI (c) (00:54) [16:52:14:284]: ******* RunEngine: ******* Product: D:ServersSetupSqlRun_SQL.msi ******* Action: ******* CommandLine: ********** MSI (c) (00:54) [16:52:14:284]: Client-side and UI is none or basic: Running entire install on the server. MSI (c) (00:54) [16:52:14:284]: Grabbed execution mutex. MSI (c) (00:54) [16:52:14:299]: Cloaking enabled. MSI (c) (00:54) [16:52:14:299]: Attempting to enable all disabled priveleges before calling Install on Server MSI (c) (00:54) [16:52:14:299]: Incrementing counter to disable shutdown. Counter after increment: 0 MSI (s) (A4:98) [16:52:14:299]: Grabbed execution mutex. MSI (s) (A4:00) [16:52:14:299]: Resetting cached policy values MSI (s) (A4:00) [16:52:14:299]: Machine policy value 'Debug' is 0 MSI (s) (A4:00) [16:52:14:299]: ******* RunEngine: ******* Product: D:ServersSetupSqlRun_SQL.msi ******* Action: ******* CommandLine: ********** MSI (s) (A4:00) [16:52:21:080]: Note: 1: 2203 2: D:ServersSetupSqlRun_SQL.msi 3: -2147024873 MSI (s) (A4:00) [16:52:21:080]: MainEngineThread is returning 1620 MSI (c) (00:54) [16:52:21:080]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1 MSI (c) (00:54) [16:52:21:080]: MainEngineThread is returning 1620 === Verbose logging stopped: 06/02/2007 16:52:21 ===
I suppose an error dialog (or log message) that actually told you what is wrong and then what to do is too much to ask for. (Or an installer than just copied all the files into place). :(
Hi,I’m having a problem uninstalling SQL Server 2005. I went into add/remove programs,clicked on each of the entries for all of the associated services to remove them,then removed SQL Server 2005, rebooted, and the tasks are still listed in services.There are no entries in add/remove programs.I’m removing SQL Server in order to install Visual Studio first - I’ve still gota problem with the “Package Load Failure” that I posted about last week:http://forums.asp.net/thread/1402873.aspxCan anyone give me a clue as to how I can completely remove SQL Server?I’m running Win 2k SP4.Thanks!
Hi all,Afetr a bad install of sql server 2005 which failed due to WMI problem; something that seems unfixable save a reinstall of windows.I am now left with a part installion of sql server 2005. From add/remove programs clicking 'remove' activates nothing as does change. However the files are there in program files.At start up I get multiple fatal errors etc.Does anyone know how I can unistall SQL server 2005 completely - perhaps from the command line?Or..how could I stop SQL server from trying to start at start up?All help most appreciated.TFM
