SQL 2005 Fails To Install Workstation Components And Tools
Feb 15, 2007
Hello.
When I install SQL Server 2005, it all goes well except that it fails to install these two:
- SQLXML 4
- workstation components and tools
When I try to install these two from the CD in the Setup folder of the CD 2 with the files sqlxml4.msi and sqlRun_Tools.msi (if I remember these names correctly), it gives me an error:
'Ce package d'installation n'est pas pris en charge par ce type de processeur'
Sorry. My SQL CDs are in french, but it roughly translates to the message:
This installation package is not taken by this processor.
I thought that my hardware configuration does not meet the requirements. But I have a Pentium 4, 2Gig RAM, over 100Gig free HD space. Also I tried to install on other computers to no avail. This is a fresh install, that is, there is no previous SQL Server 2000 in it, no VS.NET 2005 or before. Nothing. I have just a fresh, new computer.
I have installed successfully Microsoft SQL server 2005 in MSCS.
However the set up did not install Workstation components (client tools - SSMS etc).
I have successfully installed workstation components in one node of cluster.
However setup is giving following error while installing workstation components on other node. (From this node MS SQL server 2005 was installed).
Product: Microsoft SQL Server 2005 Tools -- Error 1722. There is a problem with this Windows Installer package. A program run as part of the setup did not finish as expected. Contact your support personnel or package vendor. Action SqlWbSetup.5F46584E_060D_4BCB_ADEE_BD15A7BFCC2A, location: C:Program FilesMicrosoft SQL Server90ToolsBinnVSShellCommon7IDESqlWb.exe, command: /setup
There is a problem with this Windows Installer package. A program run as part of the setup did not finish as expected. Contact your support personnel or package vendor.
I did "C:Program FilesMicrosoft SQL Server90ToolsBinnVSShellCommon7IDESqlWb.exe, /setup".
It executed but no error, no output.
Any gues, help in isolating issue?
Any more information required.(Media is ok. Setup has been tried after reboot. There is enough disk space.)
Regards.
Mahesh =========== Setup
1) Microsoft Cluster of two nodes. 2) Hardare - HP Blade servers 3) OS - Windows 2003 EE with SP2 4) SQL Server 2005 Standard Edition with SP2.
=============================
MSI (s) (B0:7C) [17:40:20:390]: Note: 1: 1722 2: SqlWbSetup.5F46584E_060D_4BCB_ADEE_BD15A7BFCC2A 3: C:Program FilesMicrosoft SQL Server90ToolsBinnVSShellCommon7IDESqlWb.exe 4: /setup MSI (s) (B0:7C) [17:47:23:609]: Product: Microsoft SQL Server 2005 Tools -- Error 1722. There is a problem with this Windows Installer package. A program run as part of the setup did not finish as expected. Contact your support personnel or package vendor. Action SqlWbSetup.5F46584E_060D_4BCB_ADEE_BD15A7BFCC2A, location: C:Program FilesMicrosoft SQL Server90ToolsBinnVSShellCommon7IDESqlWb.exe, command: /setup
MSI (s) (B0:7C) [17:47:35:921]: Note: 1: 1729 MSI (s) (B0:7C) [17:47:35:921]: Product: Microsoft SQL Server 2005 Tools -- Configuration failed.
MSI (s) (B0:7C) [17:47:35:953]: Cleaning up uninstalled install packages, if any exist MSI (s) (B0:7C) [17:47:35:953]: MainEngineThread is returning 1603 MSI (s) (B0:A0) [17:47:36:062]: Destroying RemoteAPI object. MSI (s) (B0:80) [17:47:36:062]: Custom Action Manager thread ending.
I thought I had applied sp2 successfully but I discovered when I tried to apply the hotfix ( sqlserver2005-kb933097-x86-enu.exe), that the SQL Server Tools and Workstation Components wasn't at the 3042 level.
The recommendation in the log file is to:
"Update 3152 is dependent on prerequisite update 3042. Exit setup and refer to the Knowledge Base article to find the prerequisite patch."
Does anyone know where I find the prerequisite patch?
Any help would be appreciated.
Regards Noel
Time: 03/13/2007 18:05:39.045 KB Number: KB933097 Machine: NOEL_EVO OS Version: Microsoft Windows XP Professional Service Pack 2 (Build 2600) Package Language: 1033 (ENU) Package Platform: x86 Package SP Level: 2 Package Version: 3152 Command-line parameters specified: Cluster Installation: No
********************************************************************************** Prerequisites Check & Status SQLSupport: Passed
********************************************************************************** Products Detected Language Level Patch Level Platform Edition SQL Server Database Services 2005 (SQL2005) ENU SP1 2005.090.3042.00 x86 DEVELOPER SQL Server Analysis Services 2005 (SQL2005) ENU SP1 2005.090.3042.00 x86 DEVELOPER SQL Server Reporting Services 2005 (SQL2005) ENU SP1 9.00.3042.00 x86 DEVELOPER SQL Server Notification Services 2005 ENU SP1 9.00.3042.00 x86 DEVELOPER SQL Server Integration Services 2005 ENU SP1 9.00.3042.00 x86 DEVELOPER SQL Server Tools and Workstation Components 2005 ENU SP1 9.1.2153 x86 DEVELOPER
********************************************************************************** Products Disqualified & Reason Product Reason SQL Server Tools and Workstation Components 2005 The product instance SQL Tools does not have prerequisite update 3042 installed. Update 3152 is dependent on prerequisite update 3042. Exit setup and refer to the Knowledge Base article to find the prerequisite patch. Install the prerequisite and rerun the installation.
I've got VS 2008 Pro installed, as well as SQL Sever 200 (which I must keep installed). When I run the install for SQL Server 2005 developer edition, it continually fails to install
I had a perfectly good working copy of SQL Server 2005 installed. However, at some point I needed the Report Services Designer so I could edit my reports in Visual Studio. I inserted the CD and selected the feature from the list and it installed. Only problem being that it has completely removed my Management Studio and practically every other tool I didnt explicitly checked when installing the RS Designer.
When I tried to run the same Setup again and check everything, it tells me that there is no change between what I have selected and what is installed, which sounds like total bs to me, since my pc doesnt have a management studio etc anymore.
Out of pure misery I decided to remove my entire SQL Server installation, inc Instance, hoping to start anew and achieve the result I wanted with the least amount of frustration. I ended up here and followed it all the way: http://support.microsoft.com/kb/909967
When I started reinstalling, I ran into something new. The installer refuses to let me install anything but the Workstation components, books online and development tools. All the other options are greyed out and not even available.
Someone please help me get my SQL Server back up and running because I'm getting hopeless.
I have Vista Ultimate (IIS Enabled), SQL Server 2005 Developer Edition (downloaded and ran the SP2 Update), Visual Studio 2008. VS2008 installs no problem. When I install SQL Server 2005, I get an error when it trys to install the last part( Workstation Components, Management Studio, etc). I have tried FULLY, MANUALLY removing all SQL products and registry entries. I have used Windows Installer Cleanup Utility. I have tried Microsoft's recommended way of manually removing SQL Server 2005. If I manually run SqlRun_Tools.msi the error comes up right away.
The error is: "A component that you have specified in the ADD_LOCAL property is already installed. To upgrade the existing component, refer to the template.ini and set the UPGRADE property to the name of the component."
Here's the Setup Error log: http://toby.pastebin.com/f63405e24 Any help?! Thanks! -Toby
I'm trying to install SQL Server 2005 tools, but keep getting this error,
TITLE: Microsoft SQL Server Setup------------------------------None of the selected features can be installed or upgraded. Setup cannot proceed since no effective change is being made to the machine. To continue, click Back and then select features to install. To exit SQL Server Setup, click Cancel.For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=SQLSetup90&EvtType=28108 Then on the Details, it says the following,
Name: Microsoft SQL Server 2005 ToolsReason: Your upgrade is blocked. For more information about upgrade support, see the "Version and Edition Upgrades" and "Hardware and Software Requirements" topics in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.Build version check:Your upgrade is blocked because the existing component is a later version than the version you are trying to upgrade to. To modify an existing SQL Server component, go to Add or Remove Programs in Control Panel, select the component you would like to modify, and then click Change/Remove.
I uninstalled the Express tools from the system and can't get the tools to install. I've rebooted to no avail. Help!
Hi all... assisting with mass deployment of SQL 2005 Client Tools.
Multiple users are able to pass the System Configuration Check, and click Next. It is on the next screen they see the following:
Microsoft SQL Server 2005 Setup [_][X] ------------------------------------------------------------------- Microsoft SQL Server Installation Setup is preparing to continue with the installation. ------------------------------------------------------------------- Please wait while setup prepares to continue with the installation.
Status: Extracting custom action file from stream ________________________________________________ [________________________________________________]
[Help] [< Back] [Next >] [Cancel]
After eight minutes, the install bombs, and sends an error report to Microsoft.
I saw a similar post here, but these are XP machines and Administrators appear to have the proper permissions. I also do not get the error message "Error writing to file".
Here is a section of the _WI log file generated by the install..
MSI (c) (48:A4) [09:20:49:208]: PROPERTY CHANGE: Adding ENABLERANU property. Its value is '1'. Action ended 9:20:49: SetEnableRanuUI. Return value 1. MSI (c) (48:A4) [09:20:49:208]: Skipping action: UnsetEnableRanuUI (condition is false) MSI (c) (48:A4) [09:20:49:208]: Skipping action: SetSharedVolumePath (condition is false) MSI (c) (48:A4) [09:20:49:208]: Skipping action: UnsetINSTALLSQLDATADIR (condition is false) MSI (c) (48:A4) [09:20:49:208]: Doing action: StreamSupportFiles.D20239D7_E87C_40C9_9837_E70B8D4882C2 Action 9:20:49: StreamSupportFiles.D20239D7_E87C_40C9_9837_E70B8D4882C2. Extracting custom action file from stream Action start 9:20:49: StreamSupportFiles.D20239D7_E87C_40C9_9837_E70B8D4882C2. MSI (c) (48:44) [09:20:49:223]: Invoking remote custom action. DLL: C:DOCUME~1axn4835aLOCALS~1TempMSI117.tmp, Entrypoint: StreamSupportFiles MSI (c) (48:70) [09:20:49:223]: Cloaking enabled. MSI (c) (48:70) [09:20:49:223]: Attempting to enable all disabled priveleges before calling Install on Server MSI (c) (48:70) [09:20:49:223]: Connected to service for CA interface. Action ended 9:20:49: StreamSupportFiles.D20239D7_E87C_40C9_9837_E70B8D4882C2. Return value 3. MSI (c) (48:A4) [09:20:49:301]: Skipping action: FatalError (condition is false) Action ended 9:20:49: INSTALL. Return value 3. MSI (c) (48:44) [09:28:50:859]: Destroying RemoteAPI object. MSI (c) (48:70) [09:28:50:859]: Custom Action Manager thread ending.
And here is a section of the _Core(Local).log
Running: ReportChainingResults at: 2007/0/29 9:28:57 Error: Action "ReportChainingResults" threw an exception during execution. DwLaunchMsiExec() returned : 1603 Error Code: 0x80070643 (1603) Windows Error Text: Fatal error during installation.
Source File Name: sqlchainingsqlchainingactions.cpp Compiler Timestamp: Thu Sep 1 22:23:05 2005 Function Name: sqls::ReportChainingResults::perform Source Line Number: 2992
A section of _Core.log:
Running: LaunchLocalBootstrapAction at: 2007/0/29 9:19:37 Error: Action "LaunchLocalBootstrapAction" threw an exception during execution. Error information reported during run: "C:Program FilesMicrosoft SQL Server90Setup Bootstrapsetup.exe" finished and returned: 1603 Aborting queue processing as nested installer has completed
When the install fails, this is the event signature:
I have VS2008 installed. Now, I need to install the SQL server Management Tools, because of tasks I have on SQL server instances which are installed on other servers. I guess a lot of developers are in such a situation. You develop on your own machine, but deploy the final database on a production machine.And you happen to be the manager of those databases too (well, I am)
Now, it seems impossible to install the neccesary tools as I get messages; The following components that you chose to install are already installed on the machine. To view a report of available options and alternatives click on details (Workstation components, Books Online and development tools 9.2.3042.00)
Then on the Details, it says the following,
Name: Microsoft SQL Server 2005 Tools Express Edition
Reason: Your upgrade is blocked. For more information about upgrade support, see the "Version and Edition Upgrades" and "Hardware and Software Requirements" topics in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.
Build version check:
Your upgrade is blocked because the existing component is a later version than the version you are trying to upgrade to. To modify an existing SQL Server component, go to Add or Remove Programs in Control Panel, select the component you would like to modify, and then click Change/Remove.
Now, I have no clue of what can be safely removed to allow the installation of the Management Tools. I am afraid that I will end up with a non-working SQL server Express installation which is required for VS2008
What should I do to get these Managment Tools installed on my develop machine?
It appears that there is no way to install SQL Server 2005 Workstation Components on an x86 operating system (XP in this case) if you have the x64 install disks (Standard Edition). Can someone verify this?
I am finding it hard to believe that workstation components for a standard Windows client environment are not distributed with the version of SQL Server that matches Windows 2003 x64.
The installation SQL 2008 R2 Management Tools on a Windows 7 workstation fails with the error, The specified account already exists.
Final result:Â SQL Server installation failed. To continue, investigate the reason for the failure, correct the problem, uninstall SQL Server, and then rerun SQL Server Setup.
 Exit code (Decimal):          -2068052700  Exit facility code:           1212  Exit error code:              1316  [code]...
Hello. I am trying to install only the Workstation Components portion of SQL Server 2005 and I get about halfway through and the installation errors out. The error is:
This happens after the second disk of the installation is about halfway through installing and then it throws an error stating that "The wrong volume is in the drive. Please insert volume SQLSRVRS into drive D. Cancel, Try Again, Continue" I replace the disc with the first disc and if I pick "Continue" it will display the error above. If I pick "Try again" the installation finishes, but there are components missing from Visual Studio.
I have installed the Workstation components on my local PC, which also contains VS 2005 and SQL Express. I installed the WS components so that I could run the full blown version of SQL Management Studio from my PC, to remove SQL 2005 servers.
I tried to update the Workstation components to SP1, but the SP1 package stops at the Setup Support Files, step and terminates claiming the package does not support SQL Express. I realize the package is not intended for Express, I simply need to update Management studio.
I tried running the Post SP1 Tools hotfix and it complains that it will not update SP0 of the tools.
I have successfully updated Express to SP1 and applied the Post hotfixes as well. Is there any way to patch just Management studio on a system with Express installed?
I am having trouble installing disc number 2 on sql standard 2005( I installed disc one) I get the message my workstation components are already installed etc.It will not allow me to go any further It seem like everything installed Here is my summary.... I unistalled vs 2 express 2005---I never used it...... Here is my list on my vista ultimate computer sql server business intelligence, sql server management studio, analysis services installed configuration tools documentation pefmorance tools Did I need to install disc 2 instead of disc 1? one I am using vista Please help ? I tried opening business intelligence studio it says it has compability issues Here is my log: Microsoft SQL Server 2005 9.00.1399.06 ============================== OS Version : Professional (Build 6000) Time : Tue Apr 29 14:13:59 2008
Machine : BILLPREC690 Product : Microsoft SQL Server Setup Support Files (English) Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_BILLPREC690_SQLSupport_1.log -------------------------------------------------------------------------------- Machine : BILLPREC690 Product : Microsoft Office 2003 Web Components Product Version : 11.0.6558.0 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_BILLPREC690_OWC11_1.log -------------------------------------------------------------------------------- Machine : BILLPREC690 Product : Microsoft SQL Server 2005 Backward compatibility Product Version : 8.05.1054 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_BILLPREC690_BackwardsCompat_1.log -------------------------------------------------------------------------------- Machine : BILLPREC690 Product : Microsoft SQL Server Setup Support Files (English) Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_BILLPREC690_SQLSupport_2.log -------------------------------------------------------------------------------- Machine : BILLPREC690 Product : Microsoft SQL Server Native Client Product Version : 9.00.3042.00 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_BILLPREC690_SQLNCLI_1.log -------------------------------------------------------------------------------- Machine : BILLPREC690 Product : Microsoft Office 2003 Web Components Product Version : 11.0.6558.0 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_BILLPREC690_OWC11_2.log -------------------------------------------------------------------------------- Machine : BILLPREC690 Product : Microsoft SQL Server 2005 Backward compatibility Product Version : 8.05.1054 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_BILLPREC690_BackwardsCompat_2.log -------------------------------------------------------------------------------- Machine : BILLPREC690 Product : Microsoft SQL Server Setup Support Files (English) Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_BILLPREC690_SQLSupport_3.log -------------------------------------------------------------------------------- Machine : BILLPREC690 Product : Microsoft SQL Server Native Client Product Version : 9.00.3042.00 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_BILLPREC690_SQLNCLI_2.log -------------------------------------------------------------------------------- Machine : BILLPREC690 Product : Microsoft Office 2003 Web Components Product Version : 11.0.6558.0 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_BILLPREC690_OWC11_3.log -------------------------------------------------------------------------------- Machine : BILLPREC690 Product : Microsoft SQL Server 2005 Backward compatibility Product Version : 8.05.1054 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_BILLPREC690_BackwardsCompat_3.log -------------------------------------------------------------------------------- Machine : BILLPREC690 Product : Microsoft SQL Server Setup Support Files (English) Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_BILLPREC690_SQLSupport_4.log -------------------------------------------------------------------------------- Machine : BILLPREC690 Product : Microsoft Office 2003 Web Components Product Version : 11.0.6558.0 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_BILLPREC690_OWC11_4.log -------------------------------------------------------------------------------- Machine : BILLPREC690 Product : Microsoft SQL Server 2005 Backward compatibility Product Version : 8.05.1054 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_BILLPREC690_BackwardsCompat_4.log -------------------------------------------------------------------------------- Machine : BILLPREC690 Product : Microsoft SQL Server Setup Support Files (English) Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_BILLPREC690_SQLSupport_5.log -------------------------------------------------------------------------------- Machine : BILLPREC690 Product : Microsoft SQL Server Native Client Product Version : 9.00.3042.00 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_BILLPREC690_SQLNCLI_3.log -------------------------------------------------------------------------------- Machine : BILLPREC690 Product : Microsoft Office 2003 Web Components Product Version : 11.0.6558.0 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_BILLPREC690_OWC11_5.log -------------------------------------------------------------------------------- Machine : BILLPREC690 Product : Microsoft SQL Server VSS Writer Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_BILLPREC690_SqlWriter_1.log -------------------------------------------------------------------------------- Machine : BILLPREC690 Product : Microsoft SQL Server 2005 Backward compatibility Product Version : 8.05.1054 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_BILLPREC690_BackwardsCompat_5.log -------------------------------------------------------------------------------- Machine : BILLPREC690 Product : Microsoft SQL Server Setup Support Files (English) Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_BILLPREC690_SQLSupport_6.log -------------------------------------------------------------------------------- Machine : BILLPREC690 Product : Microsoft SQL Server Native Client Product Version : 9.00.3042.00 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_BILLPREC690_SQLNCLI_4.log -------------------------------------------------------------------------------- Machine : BILLPREC690 Product : Microsoft Visual Studio 2005 Premier Partner Edition - ENU Product Version : 8.0.50727.42 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_BILLPREC690_PPESku_1.log -------------------------------------------------------------------------------- Machine : BILLPREC690 Product : Microsoft Office 2003 Web Components Product Version : 11.0.6558.0 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_BILLPREC690_OWC11_6.log -------------------------------------------------------------------------------- Machine : BILLPREC690 Product : Microsoft SQL Server 2005 Books Online (English) Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_BILLPREC690_BOL_1.log -------------------------------------------------------------------------------- Machine : BILLPREC690 Product : Microsoft SQL Server 2005 Backward compatibility Product Version : 8.05.1054 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_BILLPREC690_BackwardsCompat_6.log -------------------------------------------------------------------------------- Machine : BILLPREC690 Product : Microsoft SQL Server 2005 Integration Services Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_BILLPREC690_DTS.log -------------------------------------------------------------------------------- Machine : BILLPREC690 Product : SQLXML4 Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_BILLPREC690_SQLXML4_1.log -------------------------------------------------------------------------------- Machine : BILLPREC690 Product : Microsoft SQL Server 2005 Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_BILLPREC690_SQL.log -------------------------------------------------------------------------------- Machine : BILLPREC690 Product : SQLXML4 Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_BILLPREC690_SQLXML4_2.log -------------------------------------------------------------------------------- Machine : BILLPREC690 Product : Microsoft SQL Server 2005 Analysis Services Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_BILLPREC690_AS.log -------------------------------------------------------------------------------- Machine : BILLPREC690 Product : Microsoft SQL Server 2005 Notification Services Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_BILLPREC690_NS.log -------------------------------------------------------------------------------- Machine : BILLPREC690 Product : Microsoft SQL Server 2005 Reporting Services Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_BILLPREC690_RS.log -------------------------------------------------------------------------------- Machine : BILLPREC690 Product : Microsoft SQL Server 2005 Tools Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_BILLPREC690_Tools.log --------------------------------------------------------------------------------
Hey yall. I'm a DBA in a company where I do NOT have the ability tocontrol who logs into my SQL servers as administrator, so I'm lookingfor a way to uninstall the workstation components WITHOUT completelyuninstalling all of my instances. Does anyone know how to do this?All I can find is the complete removal option in add/remove, and theinstall cd setup doesn't have a remove function that I can find. Anyidea's?The reason for wanting to do this is so that every tom dick and harrythat logs in as administrator doesn't have the ability to just open EMand do what they please. I want to force people to log in fromanother box so I can get tighter control over who can access mydatabases. Any help is awesome, thanks!Joshua Austill
Everytime I do an install of SQL Server 2005 and I don't select to install all components (even if I make sure Workstation components and all sub components are selected) SQL Management Studio never loads. The setup completes without error however there is no SQL Management Studio anywhere on the system. I know I have searched hard for it. Has anyone else had this problem? Am I missing something?
Log Location: C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQL9_Hotfix_KB921896_sqlrun_sql.msp.log MSP Error: 29537 SQL Server Setup has encountered the following problem: [Microsoft][SQL Native Client][SQL Server]Cannot find the object 'dm_exec_query_resource_semaphores', because it does not exist or you do not have permission.. To continue, correct the problem, and then run SQL Server Setup again.
I tried to search internet, however, I couldn't get solution.
My SQL server 2005 is standard version, OS Windows server 2003 sp2, I am using Administrator account to install it.
I have Windows XP Professional Version 2002 Service Pack2.
I Have:
Microsoft SQL Server Management Studio 9.00.2047.00 Microsoft Analysis Services Client Tools 2005.090.2047.00 Microsoft Data Access Components (MDAC) 2000.085.1117.00 (xpsp_sp2_rtm.040803-2158) Microsoft MSXML 2.6 3.0 5.0 6.0 Microsoft Internet Explorer 7.0.5730.11 Microsoft .NET Framework 2.0.50727.42 Operating System 5.1.2600
Service Pack is failing to Install CLIENT COMPONENTS; message is:
Product : Client Components Product Version (Previous): 2047 Product Version (Final) : Status : Failure Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQLTools9_Hotfix_KB921896_sqlrun_tools.msp.log Error Number : 29549 Error Description : MSP Error: 29549 Failed to install and configure assemblies c:Program FilesMicrosoft SQL Server90NotificationServices9.0.242Binmicrosoft.sqlserver.notificationservices.dll in the COM+ catalog. Error: -2147024894 Error message: The system cannot find the file specified. Error description: Could not load file or assembly 'System.EnterpriseServices, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified.
This situation, I am guessing, also preventing me to run import/export from the SQLServer Client.
I have downloaded Microsoft SQL Server 2005 Enterprise Evaluation Edition ISO from the following site and burned it onto a DVD. http://www.microsoft.com/downloads/details.aspx?FamilyId=6931FA7F-C094-49A2-A050-2D07993566EC&displaylang=en
Prior to this I have installed Visual Studio 2005 Professional Edtion. During setup I have selected all the native client components i.e. Management Studio, Business Intelligense Studio. But after the install I am not able to see them under All Programs-> Microsoft SQL Server 2005. On further searching I have come across this link
First of all, there is no sqlrun_tools.msi under setup folder of the dvd. And also when I tried to change component from Add/Remove programs and following the instructions as specified on clicking Change Installed components all that I see are: Connectivity Components and Software Development kit.
Could someone tell me how can I install Management Studio/ Business Intelligence Studio seperately? I don't want to go through the process of re-installation.
and *cannot* get SQL Server 2005 Tools Express Edition CTP to uninstall. I get the following dialog box:
"The setup has encountered an unexpected error in datastore. The action is Write_CommitFlag. The error is:Unable to write property into cache flagCommit Unable to write property into cache: "flagCommit" XmlRW Error: Failure loading xmlrw.dll CheckAllProcedures() returned 2."
I have tried several times to install SQL Server 2005 Developer Edition (most recently from MSDN Disk 3097.1) I have tried to complete an uninstall before each attempt.
I do get the warning about Minimum Hardware Requirement, but can find nothing in the detail requirements to exclude my PCs configuration.
I have installed: IIS and .NET Framework 2.0
I have also used ..aspnet_regiis -r to register ASP.NET
I am, successfully, running Visual Studio 2005.
Why does the installation process stop there and what can I do next?
have removed bsn contact manager and all sql related files from previous installation attempts, rebooted so should be a clean install - but still it fails
what did I miss or what am I doing wrong?
here are the logs with ref to the two items that fail
~~~
Microsoft SQL Server 2005 9.00.1399.06 ============================== OS Version : Professional (Build 6000) Time : Tue Mar 20 18:30:20 2007
Product : OWC11 Error : Error 1706. Setup cannot find the required files. Check your connection to the network, or CD-ROM drive. For other potential solutions to this problem, see C:Program FilesMicrosoft OfficeOFFICE111033SETUP.CHM. --------------------------------------------------------------------------------
Product : Microsoft Office 2003 Web Components Product Version : 11.0.8003.0 Install : Failed Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0012_PATRICES-XPS_OWC11_1.log Last Action : InstallExecute Error String : Setup cannot find the required files. Check your connection to the network, or CD-ROM drive. For other potential solutions to this problem, see C:Program FilesMicrosoft OfficeOFFICE111033SETUP.CHM. Error Number : 1706
thanks for any help/light/suggestions you can share
I am trying to install Sql Server 2005 SP2 (KB921896) on a Windows Server 2003 box that has all the other patches installed. However, the service pack fails on Databse Services and Analysis Serrvices. The Summary.txt file is listed below. I have already done some research and tried putting the NT Authority/SYSTEM in the local Administrators group but I still get the same error. Can anyone help? Thanks Time: 06/21/2007 15:30:09.610 KB Number: KB921896 Machine: PDSQL OS Version: Microsoft Windows Server 2003 family, Standard Edition Service Pack 2 (Build 3790) Package Language: 1033 (ENU) Package Platform: x86 Package SP Level: 2 Package Version: 3042 Command-line parameters specified: Cluster Installation: No
********************************************************************************** Prerequisites Check & Status SQLSupport: Passed
********************************************************************************** Products Detected Language Level Patch Level Platform Edition Setup Support Files ENU 9.2.3042 x86 Database Services (MSSQLSERVER) ENU SP1 2005.090.2047.00 x86 STANDARD Analysis Services (MSSQLSERVER) ENU SP1 2005.090.2047.00 x86 STANDARD Reporting Services (MSSQLSERVER) ENU SP2 9.00.3054.00 x86 STANDARD Notification Services ENU SP2 9.00.3054.00 x86 STANDARD Integration Services ENU SP2 9.00.3054.00 x86 STANDARD SQL Server Native Client ENU 9.00.3042.00 x86 Client Components ENU SP2 9.2.3054 x86 STANDARD MSXML 6.0 Parser ENU 6.10.1129.0 x86 SQLXML4 ENU 9.00.3042.00 x86 Backward Compatibility ENU 8.05.2004 x86 Microsoft SQL Server VSS Writer ENU 9.00.3042.00 x86
********************************************************************************** Products Disqualified & Reason Product Reason Reporting Services (MSSQLSERVER) The product instance MSSQLSERVER been patched with more recent updates. Notification Services The product instance NS been patched with more recent updates. Integration Services The product instance Integration Services been patched with more recent updates. Client Components The product instance SQL Tools been patched with more recent updates.
********************************************************************************** Processes Locking Files Process Name Feature Type User Name PID msftesql Database Services Service NT AUTHORITYSYSTEM 3464 SQLBrowser Database Services Service NT AUTHORITYSYSTEM 5276
********************************************************************************** Product Installation Status Product : Setup Support Files Product Version (Previous): 3042 Product Version (Final) : Status : Not Selected Log File : Error Description : ---------------------------------------------------------------------------------- Product : Database Services (MSSQLSERVER) Product Version (Previous): 2047 Product Version (Final) : Status : Failure Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQL9_Hotfix_KB921896_sqlrun_sql.msp.log Error Number : 29512 Error Description : MSP Error: 29512 SQL Server Setup was unable add user NT AUTHORITYSYSTEM to local group PERSONNELALSQLServer2005SQLAgentUser$PDSQL$MSSQLSERVER. ---------------------------------------------------------------------------------- Product : Analysis Services (MSSQLSERVER) Product Version (Previous): 2047 Product Version (Final) : Status : Failure Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixOLAP9_Hotfix_KB921896_sqlrun_as.msp.log Error Number : 29512 Error Description : MSP Error: 29512 SQL Server Setup was unable add user NT AUTHORITYSYSTEM to local group PERSONNELALSQLServer2005MSOLAPUser$PDSQL$MSSQLSERVER. ---------------------------------------------------------------------------------- Product : Reporting Services (MSSQLSERVER) Product Version (Previous): 3054 Product Version (Final) : Status : NA Log File : Error Description : The product instance MSSQLSERVER been patched with more recent updates. ---------------------------------------------------------------------------------- Product : Notification Services Product Version (Previous): 3054 Product Version (Final) : Status : NA Log File : Error Description : The product instance NS been patched with more recent updates. ---------------------------------------------------------------------------------- Product : Integration Services Product Version (Previous): 3054 Product Version (Final) : Status : NA Log File : Error Description : The product instance Integration Services been patched with more recent updates. ---------------------------------------------------------------------------------- Product : SQL Server Native Client Product Version (Previous): 3042 Product Version (Final) : Status : Not Selected Log File : Error Description : ---------------------------------------------------------------------------------- Product : Client Components Product Version (Previous): 3054 Product Version (Final) : Status : NA Log File : Error Description : The product instance SQL Tools been patched with more recent updates. ---------------------------------------------------------------------------------- Product : MSXML 6.0 Parser Product Version (Previous): 1129 Product Version (Final) : Status : Not Selected Log File : Error Description : ---------------------------------------------------------------------------------- Product : SQLXML4 Product Version (Previous): 3042 Product Version (Final) : Status : Not Selected Log File : Error Description : ---------------------------------------------------------------------------------- Product : Backward Compatibility Product Version (Previous): 2004 Product Version (Final) : Status : Not Selected Log File : Error Description : ---------------------------------------------------------------------------------- Product : Microsoft SQL Server VSS Writer Product Version (Previous): 3042 Product Version (Final) : Status : Not Selected Log File : Error Description : ----------------------------------------------------------------------------------
********************************************************************************** Summary One or more products failed to install, see above for details Exit Code Returned: 29512
I'm having a problem installing SQL Server 2005 and I hope someone can give me an idea how to proceed. I have two machines and it works fine on one but fails to install on the other. The maddening thing is that the message reporting the failure gives me absolutely no feedback other than that the install failed.
I downloaded VB 2005 Express with MSDN and SQL Server 2005 Express. The .NET framework, VB and MSDN installed fine and then it failed on SQL Server. I have uninstalled and tried again several times with the same results. There's nothing unusual about my PC. It's relatively new with plenty of memory and disk storage. It's a Dell PC with a 2.4GHZ processor. There is another database product running on this system. Is that likely to be an issue?
Service Pack 2 fails to install using the Microsoft Update site. After clicking "Find solution", I got directed here.
The only error is with the Database Services (Relevant bits from the logfile):
Code Snippet
---------------------------------------------------------------------------------- Product : Database Services (MSSQLSERVER) Product Version (Previous): 1399 Product Version (Final) : Status : Failure Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQL9_Hotfix_KB921896_sqlrun_sql.msp.log Error Number : 29528 Error Description : MSP Error: 29528 The setup has encountered an unexpected error while Setting Internal Properties. The error is: Fatal error during installation.
This refers to another logfile (yet again, just the interesting bits):
Code Snippet
Property(S): SQL200564Hotfix3042 = d:f13bd9da239b4b5240e6HotFixSQLFilessqlrun_sql.msp MSI (s) (FC:C0) [16:56:04:243]: Product: Microsoft SQL Server 2005 (64-bit) - Update 'Service Pack 2 for SQL Server Database Services 2005 (64-bit) ENU (KB921896)' could not be installed. Error code 1603. Additional information is available in the log file C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQL9_Hotfix_KB921896_sqlrun_sql.msp.log.
MSI (s) (FC:C0) [16:56:04:243]: Note: 1: 1729 MSI (s) (FC:C0) [16:56:04:243]: Transforming table Error.
MSI (s) (FC:C0) [16:56:04:243]: Note: 1: 2262 2: Error 3: -2147287038 MSI (s) (FC:C0) [16:56:04:243]: Transforming table Error.
MSI (s) (FC:C0) [16:56:04:258]: Transforming table Error.
MSI (s) (FC:C0) [16:56:04:258]: Note: 1: 2262 2: Error 3: -2147287038 MSI (s) (FC:C0) [16:56:04:258]: Transforming table Error.
MSI (s) (FC:C0) [16:56:04:258]: Note: 1: 2262 2: Error 3: -2147287038 MSI (s) (FC:C0) [16:56:04:258]: Transforming table Error.
MSI (s) (FC:C0) [16:56:04:258]: Note: 1: 2262 2: Error 3: -2147287038 MSI (s) (FC:C0) [16:56:04:258]: Transforming table Error.
MSI (s) (FC:C0) [16:56:04:258]: Note: 1: 2262 2: Error 3: -2147287038 MSI (s) (FC:C0) [16:56:04:258]: Transforming table Error.
MSI (s) (FC:C0) [16:56:04:258]: Transforming table Error.
MSI (s) (FC:C0) [16:56:04:258]: Note: 1: 2262 2: Error 3: -2147287038 MSI (s) (FC:C0) [16:56:04:274]: Transforming table Error.
MSI (s) (FC:C0) [16:56:04:274]: Note: 1: 2262 2: Error 3: -2147287038 MSI (s) (FC:C0) [16:56:04:274]: Transforming table Error.
MSI (s) (FC:C0) [16:56:04:274]: Note: 1: 2262 2: Error 3: -2147287038 MSI (s) (FC:C0) [16:56:04:274]: Product: Microsoft SQL Server 2005 (64-bit) -- Configuration failed.
MSI (s) (FC:C0) [16:56:04:274]: Attempting to delete file C:WINDOWSInstaller199c46.msp MSI (s) (FC:C0) [16:56:04:274]: Unable to delete the file. LastError = 32 MSI (s) (FC:C0) [16:56:04:274]: Cleaning up uninstalled install packages, if any exist MSI (s) (FC:C0) [16:56:04:274]: MainEngineThread is returning 1603 MSI (s) (FC:0C) [16:56:04:289]: Destroying RemoteAPI object. MSI (s) (FC:68) [16:56:04:289]: Custom Action Manager thread ending. === Logging stopped: 8-5-2007 16:56:04 === MSI (c) (9C:8C) [16:56:04:289]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1 MSI (c) (9C:8C) [16:56:04:289]: MainEngineThread is returning 1603 === Verbose logging stopped: 8-5-2007 16:56:04 ===
I've checked the locations of the file, and they are all installed in the default folder:
Is there a way to get it to install anyways? Manually trying to install it has the exact same result as Microsoft Update. Everything EXCEPT the DataBase Services is upgraded.
I have Vista Ultimate (IIS Enabled), SQL Server 2005 Developer Edition (downloaded and ran the SP2 Update), Visual Studio 2008. VS2008 installs no problem. When I install SQL Server 2005, I get an error when it trys to install the last part( Workstation Components, Management Studio, etc). I have tried FULLY, MANUALLY removing all SQL products and registry entries. I have used Windows Installer Cleanup Utility. I have tried Microsoft's recommended way of manually removing SQL Server 2005. If I manually run SqlRun_Tools.msi the error comes up right away.
The error is: "A component that you have specified in the ADD_LOCAL property is already installed. To upgrade the existing component, refer to the template.ini and set the UPGRADE property to the name of the component."
Here's the Setup Error log: http://toby.pastebin.com/f63405e24
I am trying to install MS SQL Server Express but the installation always fails. I have copied the summary log below and can provide more details if you require.
Hardware:P4 1.7G CPU,30G HDD space,1G memory
Microsoft SQL Server 2005 9.00.2047.00 ============================== OS Version : Microsoft Windows XP Professional Service Pack 2 (Build 2600) Time : Fri Jul 21 15:08:24 2006
Machine : YANGNAN Product : Microsoft SQL Server 安装程åº?支æŒ?文件(英è¯) Product Version : 9.00.2047.00 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0002_YANGNAN_SQLSupport_1.log -------------------------------------------------------------------------------- Machine : YANGNAN Product : Microsoft SQL Server Native Client Product Version : 9.00.2047.00 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0002_YANGNAN_SQLNCLI_1.log -------------------------------------------------------------------------------- Machine : YANGNAN Product : Microsoft SQL Server VSS 编写器 Product Version : 9.00.2047.00 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0002_YANGNAN_SqlWriter_1.log -------------------------------------------------------------------------------- Machine : YANGNAN Product : MSXML 6.0 分æž?程åº? Product Version : 6.00.3883.15 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0002_YANGNAN_MSXML6_1.log -------------------------------------------------------------------------------- Machine : YANGNAN Product : SQL Server Database Services Error : The computer running SQL Server Setup does not meet minimum system requirements for this SQL Server release.Microsoft SQL Server is not supported on this operating system. For details, see Hardware and Software Requirements in the readme or in SQL Server Books Online. -------------------------------------------------------------------------------- Machine : YANGNAN Product : Microsoft SQL Server 2005 Product Version : 9.00.1399.06 Install : Failed Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0002_YANGNAN_SQL.log Last Action : DetectSKUOS Error String : The computer running SQL Server Setup does not meet minimum system requirements for this SQL Server release.Microsoft SQL Server is not supported on this operating system. For details, see Hardware and Software Requirements in the readme or in SQL Server Books Online. Error Number : 28018 --------------------------------------------------------------------------------
After a carefull reading of several post about this error I decided to post mine just in case it gives some clue to somebody with the knowledge I haven´t as I saw there is two kind of customers with this or very similar errors:
1. Some of them finally had success (error: 15209) installing it following the instructions in http://support.microsoft.com/kb/920114/en-us
2. Some still fighting with the problem (err: 29503).
Both errors give the same instructions, to my understand (very poor) and I followed every suggestion, but let me do some history:
1. I have 3 computers at home, all them from different makers and XP bundled on them, now all them SP2 thanks to the Updates service.
2. One has nothing extra on it. Used only to surf the net/play games and nothing more (Wife). One for work (Mine and Main), with VS 2005, Intel Pentium IV HT 3 Ghz and a Toshiba laptop with VS2005 and the same processor with not problems at all.
3. Due to former issues installing SQL server in Mine I decided finally to start from scratch, so I formatted the disk, installed XP and downloaded SP 2 and all automatic updates, then installed VS 2005 Standard and got exactly the same issue as before.
Sorry to make it long. The point is that following the instructions in MS KB documents and several posts to the letter I found out several strange things:
1. None of my computers is able to show an Address bar in Windows Explorer, when checked to be shown only produces a new greyed item in the icons bar at the very right end. If pressing F11 (full screen) then the address bar is shown and can be used.
2. Only the laptop had a folder named Protect in the indicated path.
3. None of them shows a Security tab in the Properties window of any folder or file.
4. In this thread http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=841859&SiteID=1 I thought at the very last post was the solution for my issue but then I found out another strange story: None of my computer have the "Simple file sharing" or "Use Simple file sharing" in the View label of Folder Options.
5. And this is possible the final clue: When examining the options in View label I realized that all the optios were related in my mother tongue (Spanish) whils the rest of the window was in English as I live in England and nearly all my software is in this language. Even some upgrades from MS when I was asked to choice a language I selected Spanish.
6. Only possibly I´m not the only one under these circumstances: https://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=377860&SiteID=1 (Polish)
Doing Action: Do_sqlScript PerfTime Start: Do_sqlScript : Mon Dec 25 11:40:04 2006 Service MSSQLSERVER with parameters '-m SqlSetup -Q -qLatin1_General_CI_AS -T4022 -T3659 -T3610 -T4010' is being started at Mon Dec 25 11:40:05 2006 Service failed unexpectedly (1067) Error Code: 0x8007042b (1067) Windows Error Text: The process terminated unexpectedly. Source File Name: sqlsetuplibservice.cpp Compiler Timestamp: Wed Oct 26 16:37:52 2005 Function Name: sqls::Service::Start Source Line Number: 301
Setting status of unmanaged components and removing unmanaged resources Do_sqlScript SqlScriptHlpr Start service MSSQLSERVER
Error Code: 1067 MSI (s) (F0!A4) [11:40:16:500]: Product: Microsoft SQL Server 2005 Express Edition -- Error 29503. The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually." The error is (1067) The process terminated unexpectedly. .
Error 29503. The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually." The error is (1067) The process terminated unexpectedly. . <Failure Type='Fatal' Error='1067'> <EndFunc Name='LaunchFunction' Return='1067' GetLastError='203'> MSI (s) (F0:4C) [11:40:16:578]: User policy value 'DisableRollback' is 0 MSI (s) (F0:4C) [11:40:16:578]: Machine policy value 'DisableRollback' is 0 Action ended 11:40:16: InstallFinalize. Return value 3.
7. The only difference between my laptop and desktop computers is that in regional settings Laptop has English for Regional options whilst desktop had Spanish.
Tried to change in desktop to English wont produce success installing SQL Server Express so I think there are more deep changes/corrections to do.
Those changes from English to Spanish is some XP windows are not coming from the first install, as the laptop came installed, so they should be produced after some upgrade were I was offered to download a regional version (SP 2?).
Hopefully this long post will give to some body with more brains and knowledge than me to get a work around to this problem, other than reformat, install and download SP 2 this time in English.
Setup has detected a problem with Microsoft .Net Framework installation and cannot proceed. Microsoft .Net Framework 2.0 is either not installed on this system or is corrupt.
I cannot uninstall 2.0, as its part of the Vista. I have tried repairing it.
I tried downloading 2.0 and installing it, but it says that its allready installed.
I was able to install Visual Studio with Sql Server 2005 express.
I am stuck. Is the case that Sql install dosent know about the latest version of 2.0 that came with vista ?
In C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFiles SQLSetup0001_MYSERVER_Core(Local).log I have the following error: ============= Error: Action "ReportChainingResults" threw an exception during execution. One or more packages failed to install. Refer to logs for error details. : 3 Error Code: 0x80070003 (3) Windows Error Text: The system cannot find the path specified. Source File Name: sqlchainingsqlchainingactions.cpp Compiler Timestamp: Thu Nov 16 20:31:57 2006 Function Name: sqls::ReportChainingResults:erform Source Line Number: 3521 ---- Context ----------------------------------------------- sqls::HostSetupPackageInstallerSynch:ostCommit sqls::HighlyAvailablePackage:reInstall led due to cancel code received from cancel source: 29539 Error: Failed to add file :"C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_MYSERVER_.NET Framework 2.0.log" to cab file : "C:SQLEXPRsetup.cab" Error Code : 2 Running: UploadDrWatsonLogAction at: 2008/2/18 18:14:45 Message pump returning: 3 ============ The file :"C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_MYSERVER_.NET Framework 2.0.log" does not exist.
What I've tried so far: 1. Using Add/Remove Programs, uninstall the following: A. Microsoft SQL Server Native Client B. Microsoft SQL Server Setup Support Files (English) C. Microsoft SQL Server VSS Writer D. Microsoft .NET Framework 2.0 (based on a post elsewhere that this resolved someone else problem) 2. Verified that the following Registry Keys were removed: A. HKEY_LOCAL_MACHINESOFTWAREMicrosoftMSSQLServer B. HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL Server C. HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL Native Client (If they were not, I deleted them manually.)
When I was asked to help, the SSE installation had already been attempted 4 times. Part of their resolution attempts had been to install .NET 3.0, but I have not yet re-installed that. It appears that .NET is still the culprit. Here is some information on the system: Host Name: MYSERVER OS Name: Microsoft(R) Windows(R) Server 2003, Standard Edition OS Version: 5.2.3790 Service Pack 2 Build 3790 OS Manufacturer: Microsoft Corporation OS Configuration: Standalone Server OS Build Type: Multiprocessor Free Registered Owner: User Registered Organization: MY LLC Product ID: 69712-OEM-4411902-02111 Original Install Date: 8/30/2007, 3:29:16 PM System Up Time: 0 Days, 2 Hours, 1 Minutes, 56 Seconds System Manufacturer: Dell Computer Corporation System Model: PowerEdge 840 System Type: X86-based PC Processor(s): 2 Processor(s) Installed. [01]: x86 Family 6 Model 15 Stepping 2 GenuineIntel ~2133 Mhz [02]: x86 Family 6 Model 15 Stepping 2 GenuineIntel ~2133 Mhz BIOS Version: DELL - 1 Windows Directory: C:WINDOWS System Directory: C:WINDOWSsystem32 Boot Device: DeviceHarddiskVolume2 System Locale: en-us;English (United States) Input Locale: en-us;English (United States) Time Zone: (GMT-07:00) Mountain Time (US & Canada) Total Physical Memory: 4,095 MB Available Physical Memory: 3,626 MB Page File: Max Size: 5,976 MB Page File: Available: 5,665 MB Page File: In Use: 311 MB Page File Location(s): C:pagefile.sys Domain: WORKGROUP Logon Server: \MYSERVER Hotfix(s): 79 Hotfix(s) Installed. [01]: File 1 [02]: File 1 [03]: File 1 [04]: File 1 [05]: File 1 [06]: File 1 [07]: File 1 [08]: File 1 [09]: File 1 [10]: File 1 [11]: File 1 [12]: File 1 [13]: File 1 [14]: File 1 [15]: File 1 [16]: File 1 [17]: File 1 [18]: File 1 [19]: File 1 [20]: File 1 [21]: File 1 [22]: File 1 [23]: File 1 [24]: File 1 [25]: File 1 [26]: File 1 [27]: File 1 [28]: File 1 [29]: File 1 [30]: File 1 [31]: File 1 [32]: File 1 [33]: File 1 [34]: File 1 [35]: File 1 [36]: File 1 [37]: Q147222 [38]: KB933854 - QFE [39]: Q936181 [40]: IDNMitigationAPIs - Update [41]: NLSDownlevelMapping - Update [42]: KB925398_WMP64 [43]: KB937143-IE7 - Update [44]: KB938127-IE7 - Update [45]: KB939653-IE7 - Update [46]: KB942615-IE7 - Update [47]: KB944533-IE7 - Update [48]: KB921503 - Update [49]: KB924667-v2 - Update [50]: KB925876 - Update [51]: KB925902 - Update [52]: KB926122 - Update [53]: KB927891 - Update [54]: KB929123 - Update [55]: KB930178 - Update [56]: KB931784 - Update [57]: KB932168 - Update [58]: KB933360 - Update [59]: KB933729 - Update [60]: KB933854 - Update [61]: KB935839 - Update [62]: KB935840 - Update [63]: KB936021 - Update [64]: KB936357 - Update [65]: KB936782 - Update [66]: KB937143 - Update [67]: KB938127 - Update [68]: KB941202 - Update [69]: KB941568 - Update [70]: KB941569 - Update [71]: KB941644 - Update [72]: KB942763 - Update [73]: KB943055 - Update [74]: KB943460 - Update [75]: KB943485 - Update [76]: KB944653 - Update [77]: KB946026 - Update [78]: KB948496 - Update [79]: XpsEPSC
My next thought is to try this: http://groups.google.com/group/microsoft.public.windowsupdate/msg/4d76de7769d04493 Does anyone have any better suggestions? Is the .NET Framework the likely problem here?
I have had 3 tries at getting SQL Server 2005 Express installed on my XP Pro 64-bit.
In the System Configuration Check at the start of the install process I get two warnings: COM Plus Catalog Requirement and ASP .NET Version Registration Requirement (64-bit ASP .Net is Registered. Required 32-bit ASP .Net to install Microsoft Reporting Services 2005(32-bit).).
In the Setup Progress I get green ticks for MSXML6, SQL Setup Support Files, SQL Native Client and SQL VSS Writer, but half way through SQL Server Database Services I get a popup - Generic Host Process for Win32 Services has encountered a problem and needs to close. Then another popup - SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client]Shared Memory Provider: Timeout error [258]. ... Final popup is - This system is shutting down... This shutdown was initiated by NT AUTHORITYSYSTEM with the message: Windows must now restart because the Remote Procedure Call (RPC) service terminated unexpectedly.
I am trying to install MS SQL Server Express but the installation always fails. I have copied the summary log below and can provide more details if you require. Web Developer and C# Express install OK.
I have been trying to install this for around 2 weeks now with no luck ... I even had the PC formatted and rebuilt but the install still fails. If it installed and worked before, i cannot understand why it doesn't work now. The summary log is provided below:
Microsoft SQL Server 2005 9.00.1399.06 ============================== OS Version : Microsoft Windows XP Professional Service Pack 2 (Build 2600) Time : Thu Jun 22 10:42:08 2006
GLKD2396800 : The current system does not meet recommended hardware requirements for this SQL Server release. For detailed hardware requirements, see the readme file or SQL Server Books Online. Machine : GLKD2396800 Product : Microsoft SQL Server Setup Support Files (English) Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_GLKD2396800_SQLSupport_1.log -------------------------------------------------------------------------------- Machine : GLKD2396800 Product : Microsoft SQL Server Native Client Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_GLKD2396800_SQLNCLI_1.log -------------------------------------------------------------------------------- Machine : GLKD2396800 Product : Microsoft SQL Server VSS Writer Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_GLKD2396800_SqlWriter_1.log -------------------------------------------------------------------------------- Machine : GLKD2396800 Product : MSXML 6.0 Parser Product Version : 6.00.3883.8 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_GLKD2396800_MSXML6_1.log -------------------------------------------------------------------------------- Machine : GLKD2396800 Product : Microsoft SQL Server Setup Support Files (English) Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_GLKD2396800_SQLSupport_2.log -------------------------------------------------------------------------------- Machine : GLKD2396800 Product : Microsoft SQL Server Native Client Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_GLKD2396800_SQLNCLI_2.log -------------------------------------------------------------------------------- Machine : GLKD2396800 Product : MSXML 6.0 Parser Product Version : 6.00.3883.8 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_GLKD2396800_MSXML6_2.log -------------------------------------------------------------------------------- Machine : GLKD2396800 Product : SQL Server Database Services Error : The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually." -------------------------------------------------------------------------------- Machine : GLKD2396800 Product : SQL Server Database Services Error : The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually." -------------------------------------------------------------------------------- Machine : GLKD2396800 Product : Microsoft SQL Server 2005 Express Edition Product Version : 9.00.1399.06 Install : Failed Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_GLKD2396800_SQL.log Last Action : InstallFinalize Error String : The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually." The error is (1067) The process terminated unexpectedly. Error Number : 29503 -------------------------------------------------------------------------------- Machine : GLKD2396800 Product : Microsoft SQL Server 2005 Tools Express Edition Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_GLKD2396800_Tools.log --------------------------------------------------------------------------------
SQL Server Setup failed. For more information, review the Setup log file in %ProgramFiles%Microsoft SQL Server90Setup BootstrapLOGSummary.txt.
Hello, I'm using the latest version of SQLEXPR32.EXE found here : http://www.microsoft.com/downloads/details.aspx?FamilyID=31711d5d-725c-4afa-9d65-e4465cdff1e7&DisplayLang=en
The only difference between the two is the quiet switches used in the first case : "-q" and "/qn"
After spending some time to understand what is going wrong, it seems that in quied mode, Setup Prerequisite 'SQL Native Client' is not installed. Then the remaining part of the setup fails because of this.
