Sql Server 2005 Sp2 Install Failure 29528 On Windows Xp Sp2 On Domain
Mar 27, 2007
I have an xp dev machine i use which has sql server 2005. I skipped installin sp1 on sql server and went to sp2 directly. I tried over and over again but getting following errors. Not sure how to fix it.
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 Installing Local Groups. The error is: A member could not be added to or removed from the local group because the member does not exist.
----------------------------------------------------------------------------------
Product : Analysis Services (MSSQLSERVER)
Product Version (Previous): 1399
Product Version (Final) :
Status : Failure
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixOLAP9_Hotfix_KB921896_sqlrun_as.msp.log
Error Number : 29528
Error Description : MSP Error: 29528 The setup has encountered an unexpected error while Installing Local Groups. The error is: A member could not be added to or removed from the local group because the member does not exist.
----------------------------------------------------------------------------------
Product : Reporting Services (MSSQLSERVER)
Product Version (Previous): 1399
Product Version (Final) :
Status : Failure
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixRS9_Hotfix_KB921896_sqlrun_rs.msp.log
Error Number : 29528
Error Description : MSP Error: 29528 The setup has encountered an unexpected error while Installing Local Groups. The error is: A member could not be added to or removed from the local group because the member does not exist.
After going into detailed log file i noticed this account its trying to use,
MSI (s) (A8!54) [17:13:45:891]: PROPERTY CHANGE: Adding SQLBROWSERACCOUNT property. Its value is 'PHXNT1ADMINISTRATOR'.
MSI (s) (A8!54) [17:13:45:907]: PROPERTY CHANGE: Adding AGTACCOUNT property. Its value is 'PHXNT1ADMINISTRATOR'.
Restored account SQLBROWSERACCOUNT=PHXNT1ADMINISTRATOR
MSI (s) (A8!54) [17:13:45:907]: PROPERTY CHANGE: Adding SQLACCOUNT property. Its value is 'NT AUTHORITYSYSTEM'.
Restored account AGTACCOUNT=PHXNT1ADMINISTRATOR
MSI (s) (A8!84) [17:13:48:109]: PROPERTY CHANGE: Adding Rollback_sqlGroupMember.D20239D7_E87C_40C9_9837_E70B8D4882C2 property. Its value is '100Installing Local Groups50000SQLServer2005SQLBrowserUser$PHOENIXDEV2PHXNT1ADMINISTRATOR'.
MSI (s) (A8!84) [17:13:48:343]: PROPERTY CHANGE: Adding Do_sqlGroupMember.D20239D7_E87C_40C9_9837_E70B8D4882C2 property. Its value is '110Installing Local Groups50000SQLServer2005SQLBrowserUser$PHOENIXDEV2PHXNT1ADMINISTRATOR'.
my domain was upgraded from nt to 2003 long time ago from phxnt1 to phxad1 which i dont know why it still try's to use the old account. The old domain is still online would this cause this problem not sure.
I cannot get SQL Server 2005 Express installed on a 2003 Small Business Server. I am logged in as an admin.
The error:
Code Block
Product: Microsoft SQL Server 2005 Express Edition -- Error 29528. The setup has encountered an unexpected error while Installing performance counters. The error is: Access is denied.
I have uninstalled all instances of SQL Server. Rebooted server and tried again, but get same error.
I'm currently receiving the following error message whilst attempting to install SQL Server 2005 Standard Edition on Windows Server 2003 (32 Bit): Error 29528. The setup has encountered an unexpected error while Installing performance counters. The error is: The system cannot find the file specified.
This server already has an install of SQL Server 2000 as the default instance. I'm attempting to install a new named instance of SQL Server 2005.
Extract from log:
<Func Name='LaunchFunction'> Function=Do_sqlPerfmon2 <Func Name='GetCAContext'> <EndFunc Name='GetCAContext' Return='T' GetLastError='0'> Doing Action: Do_sqlPerfmon2 PerfTime Start: Do_sqlPerfmon2 : Tue Jun 12 10:20:02 2007 <Func Name='Do_sqlPerfmon2'> <EndFunc Name='Do_sqlPerfmon2' Return='0' GetLastError='2'> PerfTime Stop: Do_sqlPerfmon2 : Tue Jun 12 10:20:02 2007 MSI (s) (4C:FC) [10:20:02:833]: Executing op: ActionStart(Name=Rollback_Do_sqlPerfmon2.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Removing performance counters,) <EndFunc Name='LaunchFunction' Return='0' GetLastError='0'> MSI (s) (4C:FC) [10:20:02:849]: Executing op: CustomActionSchedule(Action=Rollback_Do_sqlPerfmon2.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1281,Source=BinaryData,Target=Rollback_Do_sqlPerfmon2,CustomActionData=100Removing performance counters200000DTSPipelineC:Program FilesMicrosoft SQL Server90DTSBinnDTSPERF.INI) MSI (s) (4C:FC) [10:20:02:849]: Executing op: ActionStart(Name=Do_sqlPerfmon2.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Installing performance counters,) MSI (s) (4C:FC) [10:20:02:849]: Executing op: CustomActionSchedule(Action=Do_sqlPerfmon2.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1025,Source=BinaryData,Target=Do_sqlPerfmon2,CustomActionData=100Installing performance counters200000C:Program FilesMicrosoft SQL Server90DTSBinnDTSPERF.INIC:Program FilesMicrosoft SQL Server90DTSBinnDTSPERF.HC:Program FilesMicrosoft SQL Server90DTSBinnDTSPipelinePerf.dllDTSPipeline0DTSPipelinePrfData_OpenPrfData_CollectPrfData_Close) MSI (s) (4C:94) [10:20:02:864]: Invoking remote custom action. DLL: C:WINDOWSInstallerMSI1683.tmp, Entrypoint: Do_sqlPerfmon2 <Func Name='LaunchFunction'> Function=Do_sqlPerfmon2 <Func Name='GetCAContext'> <EndFunc Name='GetCAContext' Return='T' GetLastError='0'> Doing Action: Do_sqlPerfmon2 PerfTime Start: Do_sqlPerfmon2 : Tue Jun 12 10:20:02 2007 <Func Name='Do_sqlPerfmon2'> <EndFunc Name='Do_sqlPerfmon2' Return='2' GetLastError='2'> PerfTime Stop: Do_sqlPerfmon2 : Tue Jun 12 10:20:02 2007 Gathering darwin properties for failure handling. Error Code: 2 MSI (s) (4C!F0) [10:23:46:381]: Product: Microsoft SQL Server 2005 Integration Services -- Error 29528. The setup has encountered an unexpected error while Installing performance counters. The error is: The system cannot find the file specified.Error 29528. The setup has encountered an unexpected error while Installing performance counters. The error is: The system cannot find the file specified.
You can ignore this and it will complete the installation, but subsequently trying to patch with SP2 will fail on the same sections - Hotfix.exe crashes whilst attempting to patch Database Services, Integration Services and Client Components (3 separate crashes).
I've removed SQL Server 2005 elements and tried to re-install, but it's not improved the situation.
Hi,I have a peculiar problem (or maybe not). I have SQL clients installedon XP boxes. These XP boxes are a member of let us say "XYZ" domain.SQL Server is installed on one of the boxes having Windows 2000 Serverin the same network. The installation has been done on local domainaccount. Since SQl Server has been installed with Windowsauthentication, what happens if the XYZ domain fails. Will it bepossible for all clients to access the database present on SQL Serverin the Win 2K box. I think I have made myself clear upto some extent.Please throw light on how to accomplish the connectivity between SQLclients and server in case of domain failure.Regards,Vinodi
I would like to install SQL server 2005 cluster on Windows 2003 cluster. Is domain controller (AD and DNS) necessary for the SQL server 2005 cluster? If yes, may I install it on one of the SQL server 2005 cluster nodes? Thanks in advance
I am trying to apply MS SQL Server 2005 SP1 onto a 2 node cluster running Windows Server 2003, but it fails for SQL and the Analysis Services components of SQL Server, the error I am getting is MSP returned 1603 for both components. I have tried rebooting the machines but still get the same issue, the only additional dependency for SQL that I have added is for a 2nd physical disk. log details are below.
Many thanks in advance for any help you can provide on this problem.
01/15/2007 12:26:26.937 ================================================================================ 01/15/2007 12:26:26.953 Hotfix package launched 01/15/2007 12:26:27.703 Product discovery successfully completed during the install process for MSSQLSERVER 01/15/2007 12:26:27.703 SP Level check successfully completed during the install process for MSSQLSERVER 01/15/2007 12:26:27.734 Product language check successfully completed during the install process for MSSQLSERVER 01/15/2007 12:26:27.750 Product version check successfully completed during the install process for MSSQLSERVER 01/15/2007 12:26:27.765 Command-line instance name check completed during the install process 01/15/2007 12:26:27.781 Baseline build check completed during the install process 01/15/2007 12:29:31.734 Attempting to install instance: MSSQLSERVER 01/15/2007 12:29:31.750 Enumerating passive cluster nodes 01/15/2007 12:29:31.765 Patching available passive node: GBCONV1A002N03 01/15/2007 12:29:31.781 Attempting to patch running passive node: GBCONV1A002N03 01/15/2007 12:29:31.796 Waiting for first successfully completed passive node 01/15/2007 12:29:31.812 Successfully created remote folder for product instance target \GBCONV1A002N03 01/15/2007 12:29:45.859 Successfully transferred payload to remote product instance target \GBCONV1A002N03 01/15/2007 12:29:45.921 Successfully transferred payload to remote product instance target \GBCONV1A002N03 01/15/2007 12:29:45.953 Successfully created new scheduled task for product instance target \GBCONV1A002N03 01/15/2007 12:29:46.562 Successfully saved new scheduled task for product instance target \GBCONV1A002N03 01/15/2007 12:29:46.625 Successfully created scheduled task for product instance target \GBCONV1A002N03 01/15/2007 12:29:46.640 Successfully started scheduled task for product instance target \GBCONV1A002N03 01/15/2007 12:29:46.656 Successfully started scheduled task for product instance target \GBCONV1A002N03 01/15/2007 12:30:28.671 Scheduled task for product instance target has completed 01/15/2007 12:30:28.687 Waiting for exit code from scheduled task for product instance target \GBCONV1A002N03 01/15/2007 12:30:33.718 Received exit code 0 from scheduled task for product instance target \GBCONV1A002N03 01/15/2007 12:30:33.734 Result code for scheduled task for product instance target has been received 01/15/2007 12:30:33.734 Removed scheduled task for product instance target \GBCONV1A002N03 01/15/2007 12:30:33.921 Successfully removed remote folder for product instance target \GBCONV1A002N03 01/15/2007 12:30:33.953 Remote process completed for product instance target 01/15/2007 12:30:33.968 Exit code for passive node: GBCONV1A002N03 = 0 01/15/2007 12:30:36.812 First successful passive node has been completed 01/15/2007 12:30:36.828 Attempting to install target: GBCONV1A002N01 01/15/2007 12:30:36.843 Attempting to check for locked files: sqlrun_as.msp 01/15/2007 12:30:36.890 Attempting to check for locked files: \GBCONV1A002N01d$bf7e520a98fb7a70c268b90HotFixASFilessqlrun_as.msp 01/15/2007 12:30:36.906 Creating MSP locked file check log at: C:WINDOWSHotfixOLAP9LogsOLAP9_Hotfix_KB913090_sqlrun_as.msp.out 01/15/2007 12:30:41.015 MSP returned 1603: A fatal error occurred during installation. 01/15/2007 12:30:41.140 Unable to check MSP file: \GBCONV1A002N01d$bf7e520a98fb7a70c268b90HotFixASFilessqlrun_as.msp 01/15/2007 12:30:41.156 The following exception occurred: Unable to install Windows Installer MSP file Date: 01/15/2007 12:30:41.156 File: depotsqlvaultsetupmainsetupsqlsesqlsedllcopyengine.cpp Line: 689 01/15/2007 12:30:41.187 Attempting to finalize cluster instance: MSSQLSERVER 01/15/2007 12:30:41.203 Waiting for all running passive nodes to complete their patch 01/15/2007 12:30:41.218 All running passive nodes have completed their patch 01/15/2007 12:30:41.234 Successfully finalized cluster instance: MSSQLSERVER 01/15/2007 12:30:41.234 Failed to install instance: MSSQLSERVER 01/15/2007 12:30:41.250 01/15/2007 12:30:41.281 Product Status Summary: 01/15/2007 12:30:41.296 Product: SQL Server Native Client (64-bit) 01/15/2007 12:30:41.312 SQL Server Native Client (64-bit) (RTM ) - Success 01/15/2007 12:30:41.312 01/15/2007 12:30:41.328 Product: Setup Support Files (64-bit) 01/15/2007 12:30:41.343 Setup Support Files (64-bit) (RTM ) - Success 01/15/2007 12:30:41.359 01/15/2007 12:30:41.375 Product: Database Services (64-bit) 01/15/2007 12:30:41.390 Database Services (64-bit) (SP1 2047 ENU GBCONV1A002V03) - Failure 01/15/2007 12:30:41.406 Analysis Services (64-bit) (RTM 1399 ENU GBCONV1A002V04) - Failure 01/15/2007 12:30:41.406 01/15/2007 12:30:41.421 Product: Integration Services (64-bit) 01/15/2007 12:30:41.437 Integration Services (64-bit) (SP1 2047 ENU) - Not Applied 01/15/2007 12:30:41.453 01/15/2007 12:30:41.468 Product: MSXML 6.0 Parser (64-bit) 01/15/2007 12:30:41.484 MSXML 6.0 Parser (64-bit) (RTM ) - Not Applied 01/15/2007 12:30:41.484 01/15/2007 12:30:41.515 Product: Backward Compatibility (64-bit) 01/15/2007 12:30:41.531 Backward Compatibility (64-bit) (RTM ) - Not Applied 01/15/2007 12:30:41.546 01/15/2007 12:30:41.546 Product: Microsoft SQL Server VSS Writer (64-bit) 01/15/2007 12:30:41.578 Microsoft SQL Server VSS Writer (64-bit) (RTM ) - Not Applied 01/15/2007 12:30:41.593 01/15/2007 12:48:34.562 Hotfix package closed
SQL Server 2005 Enterprise Edition X64 keeps failing during the install. Every single compnent installes EXCEPT the actual database engine. The only error message I get is that the server failed to install because of a fatal error. This happens when the installer is trying to set "internal parameters" on the database engine install phase.
I have tried uninstaling everything and even used the Windows Install Clean up tool to clean out bogus references after my 1st attempt to install the DB server, but nothing has helped. I hope someone has some ideas on how to proceed.
The server is a brand new Dell PowerEdge 1900 SC running 2 Quad Core Xeon 2.0 GHz processors, 8 GB of RAM and Windows Server 20003 RC2 X64 factory installed from Dell.
I attempted to post the verbose setup log in this post, but it was to long. I can email the text file or upload it to our web server and link it in here if some one wants to see it. It wasn't a whole lot of help to me.
I am attempting to install SQL Server express on an XP (SP2) machine with a Pentium processor. The .NET framework version is 2.0. All previous versions of SQL server and related components have been uninstalled, and all related files deleted. Also, during installation, I installed SQL Express using the local service account (vs. network service) per a suggestion in a related thread. I have installed/unistalled numerous times, and continue to receive the same error. At this point, this is becoming a critical issue related to a client ASP.NET application using a SQL express 2005 database. I was hoping by now that MS would have released a new version or patch that would solve this problem, but that does not seem to be the case, that I'm aware of.
Summary Log:
Microsoft SQL Server 2005 9.00.3042.00 ============================== OS Version : Microsoft Windows XP Professional Service Pack 2 (Build 2600) Time : Tue Aug 21 14:59:31 2007
Machine : DEBASER1 Product : Microsoft SQL Server Setup Support Files (English) Product Version : 9.00.3042.00 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_DEBASER1_SQLSupport_1.log -------------------------------------------------------------------------------- Machine : DEBASER1 Product : Microsoft SQL Server Native Client Product Version : 9.00.3042.00 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_DEBASER1_SQLNCLI_1.log -------------------------------------------------------------------------------- Machine : DEBASER1 Product : Microsoft SQL Server VSS Writer Product Version : 9.00.3042.00 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_DEBASER1_SqlWriter_1.log -------------------------------------------------------------------------------- Machine : DEBASER1 Product : MSXML 6.0 Parser (KB933579) Product Version : 6.10.1200.0 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_DEBASER1_MSXML6_1.log -------------------------------------------------------------------------------- Machine : DEBASER1 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 : DEBASER1 Product : Microsoft SQL Server 2005 Express Edition Product Version : 9.2.3042.00 Install : Failed Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_DEBASER1_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 (3) The system cannot find the path specified. Error Number : 29503 --------------------------------------------------------------------------------
SQL Server Setup failed. For more information, review the Setup log file in %ProgramFiles%Microsoft SQL Server90Setup BootstrapLOGSummary.txt.
Microsoft SQL Server 2005 Setup beginning at Tue Aug 21 14:59:31 2007 Process ID : 2960 c:Program FilesMicrosoft SQL Server90Setup Bootstrapsetup.exe Version: 2005.90.3042.0 Running: LoadResourcesAction at: 2007/7/21 14:59:31 Complete: LoadResourcesAction at: 2007/7/21 14:59:31, returned true Running: ParseBootstrapOptionsAction at: 2007/7/21 14:59:31 Loaded DLL:c:Program FilesMicrosoft SQL Server90Setup Bootstrapxmlrw.dll Version:2.0.3609.0 Complete: ParseBootstrapOptionsAction at: 2007/7/21 14:59:31, returned true Running: ValidateWinNTAction at: 2007/7/21 14:59:31 Complete: ValidateWinNTAction at: 2007/7/21 14:59:31, returned true Running: ValidateMinOSAction at: 2007/7/21 14:59:31 Complete: ValidateMinOSAction at: 2007/7/21 14:59:31, returned true Running: PerformSCCAction at: 2007/7/21 14:59:31 Complete: PerformSCCAction at: 2007/7/21 14:59:31, returned true Running: ActivateLoggingAction at: 2007/7/21 14:59:31 Complete: ActivateLoggingAction at: 2007/7/21 14:59:31, returned true Running: DetectPatchedBootstrapAction at: 2007/7/21 14:59:31 Complete: DetectPatchedBootstrapAction at: 2007/7/21 14:59:31, returned true Action "LaunchPatchedBootstrapAction" will be skipped due to the following restrictions: Condition "EventCondition: __STP_LaunchPatchedBootstrap__2960" returned false. Action "BeginBootstrapLogicStage" will be skipped due to the following restrictions: Condition "Setup is running locally." returned true. Running: PerformDotNetCheck2 at: 2007/7/21 14:59:31 Complete: PerformDotNetCheck2 at: 2007/7/21 14:59:31, returned true Running: InvokeSqlSetupDllAction at: 2007/7/21 14:59:31 Loaded DLL:c:Program FilesMicrosoft SQL Server90Setup Bootstrapsqlspars.dll Version:2005.90.3042.0 <Func Name='DwLaunchMsiExec'> Examining 'sqlspars' globals to initialize 'SetupStateScope' Opening 'MachineConfigScope' for [DEBASER1] 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 = DEBASER1, Article = WMIServiceWin32OSWorking, Result = 0 (0x0) Machine = DEBASER1, Article = WMIServiceWin32CompSystemWorking, Result = 0 (0x0) Machine = DEBASER1, Article = WMIServiceWin32ProcessorWorking, Result = 0 (0x0) Machine = DEBASER1, Article = WMIServiceReadRegWorking, Result = 0 (0x0) Machine = DEBASER1, Article = WMIServiceWin32DirectoryWorking, Result = 0 (0x0) Machine = DEBASER1, Article = WMIServiceCIMDataWorking, Result = 0 (0x0) Machine = DEBASER1, Article = XMLDomDocument, Result = 0 (0x0) Machine = DEBASER1, Article = Processor, Result = 0 (0x0) Machine = DEBASER1, Article = PhysicalMemory, Result = 0 (0x0) Machine = DEBASER1, Article = DiskFreeSpace, Result = 0 (0x0) Machine = DEBASER1, Article = OSVersion, Result = 0 (0x0) Machine = DEBASER1, Article = OSServicePack, Result = 0 (0x0) Machine = DEBASER1, Article = OSType, Result = 0 (0x0) Machine = DEBASER1, Article = AdminShare, Result = 0 (0x0) Machine = DEBASER1, Article = PendingReboot, Result = 0 (0x0) Machine = DEBASER1, Article = IEVersion, Result = 0 (0x0) Machine = DEBASER1, Article = DriveWriteAccess, Result = 0 (0x0) Machine = DEBASER1, Article = COMPlus, Result = 0 (0x0) Machine = DEBASER1, Article = ASPNETVersionRegistration, Result = 0 (0x0) Machine = DEBASER1, Article = MDAC25Version, Result = 0 (0x0) Machine = DEBASER1, Article = SKUUpgrade, Result = 0 (0x0) ******************************************* Setup Consistency Check Report for Machine: DEBASER1 ******************************************* Article: WMI Service Requirement, Result: CheckPassed Article: MSXML Requirement, Result: CheckPassed Article: Operating System Minimum Level Requirement, Result: CheckPassed Article: Operating System Service Pack Level Requirement, Result: CheckPassed Article: SQL Compatibility With Operating System, Result: CheckPassed Article: Minimum Hardware Requirement, Result: CheckPassed Article: Pending Reboot Requirement, Result: CheckPassed Article: Default Installation Path Permission Requirement, Result: CheckPassed Article: Internet Explorer Requirement, Result: CheckPassed Article: Check COM+ Catalogue, Result: CheckPassed Article: ASP.Net Registration Requirement, Result: CheckPassed Article: Minimum MDAC Version Requirement, Result: CheckPassed Article: Edition Upgrade Check, Result: CheckPassed <Func Name='PerformDetections'> 0 <EndFunc Name='PerformDetections' Return='0' GetLastError='0'> <Func Name='DisplaySCCWizard'> CSetupBootstrapWizard returned 1 <EndFunc Name='DisplaySCCWizard' Return='0' GetLastError='183'> Loaded DLL:c:Program FilesMicrosoft SQL Server90Setup Bootstrapsqlsval.dll Version:2005.90.3042.0 <EndFunc Name='DwLaunchMsiExec' Return='0' GetLastError='0'> Complete: InvokeSqlSetupDllAction at: 2007/7/21 15:0:29, returned true Running: SetPackageInstallStateAction at: 2007/7/21 15:0:29 Complete: SetPackageInstallStateAction at: 2007/7/21 15:0:29, returned true Running: DeterminePackageTransformsAction at: 2007/7/21 15:0:29 Complete: DeterminePackageTransformsAction at: 2007/7/21 15:0:30, returned true Running: ValidateSetupPropertiesAction at: 2007/7/21 15:0:30 Complete: ValidateSetupPropertiesAction at: 2007/7/21 15:0:30, returned true Running: OpenPipeAction at: 2007/7/21 15:0:30 Complete: OpenPipeAction at: 2007/7/21 15:0:30, returned false Error: Action "OpenPipeAction" failed during execution. Running: CreatePipeAction at: 2007/7/21 15:0:30 Complete: CreatePipeAction at: 2007/7/21 15:0:30, 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/7/21 15:0:30 Complete: PopulateMutatorDbAction at: 2007/7/21 15:0:30, returned true Running: GenerateRequestsAction at: 2007/7/21 15:0:30 SQL_Engine = 3 SQL_Data_Files = 3 SQL_Replication = -1 SQL_FullText = -1 SQL_SharedTools = 3 SQL_BC_DEP = -1 Analysis_Server = -1 AnalysisDataFiles = -1 AnalysisSharedTools = -1 RS_Server = -1 RS_Web_Interface = -1 RS_SharedTools = -1 Notification_Services = -1 NS_Engine = -1 NS_Client = -1 SQL_DTS = -1 Client_Components = -1 Connectivity = -1 SQL_Tools90 = -1 SQL_WarehouseDevWorkbench = -1 SDK = -1 SQLXML = -1 Tools_Legacy = -1 TOOLS_BC_DEP = -1 SQL_SSMSEE = -1 SQL_Documentation = -1 SQL_BooksOnline = -1 SQL_DatabaseSamples = -1 SQL_AdventureWorksSamples = -1 SQL_AdventureWorksDWSamples = -1 SQL_AdventureWorksASSamples = -1 SQL_Samples = -1 Complete: GenerateRequestsAction at: 2007/7/21 15:0:32, returned true Running: CreateProgressWindowAction at: 2007/7/21 15:0:32 Complete: CreateProgressWindowAction at: 2007/7/21 15:0:32, returned true Running: ScheduleActionAction at: 2007/7/21 15:0:32 Complete: ScheduleActionAction at: 2007/7/21 15:0:33, 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/7/21 15:0:33 Installing: sqlsupport on target: DEBASER1 Complete: InstallSqlAction.11 at: 2007/7/21 15:11:8, returned true Running: InstallSqlAction.12 at: 2007/7/21 15:11:8 Installing: sqlncli on target: DEBASER1 Complete: InstallSqlAction.12 at: 2007/7/21 15:11:17, returned true Skipped: InstallSqlAction.18 Skipped: Action "InstallSqlAction.18" was not run. Information reported during analysis: No install request found for package: "owc11", referred by package: "sql", install will be skipped as a result. Running: InstallSqlAction.21 at: 2007/7/21 15:11:17 Installing: sqlwriter on target: DEBASER1 Complete: InstallSqlAction.21 at: 2007/7/21 15:11:22, returned true Skipped: InstallSqlAction.22 Skipped: Action "InstallSqlAction.22" was not run. Information reported during analysis: No install request found for package: "bcRedist", referred by package: "sql", install will be skipped as a result. Running: InstallSqlAction.9 at: 2007/7/21 15:11:22 Installing: msxml6 on target: DEBASER1 Complete: InstallSqlAction.9 at: 2007/7/21 15:11:24, returned true Skipped: InstallToolsAction.11 Skipped: Action "InstallToolsAction.11" was not run. Information reported during analysis: No install request found for package: "sqlsupport", referred by package: "tools", install will be skipped as a result. Skipped: InstallToolsAction.12 Skipped: Action "InstallToolsAction.12" was not run. Information reported during analysis: No install request found for package: "sqlncli", referred by package: "tools", install will be skipped as a result. Skipped: InstallToolsAction.13 Skipped: Action "InstallToolsAction.13" was not run. Information reported during analysis: No install request found for package: "PPESku", referred by package: "tools", install will be skipped as a result. Skipped: InstallToolsAction.18 Skipped: Action "InstallToolsAction.18" was not run. Information reported during analysis: No install request found for package: "owc11", referred by package: "tools", install will be skipped as a result. Skipped: InstallToolsAction.20 Skipped: Action "InstallToolsAction.20" was not run. Information reported during analysis: No install request found for package: "BOL", referred by package: "tools", install will be skipped as a result. Skipped: InstallToolsAction.22 Skipped: Action "InstallToolsAction.22" was not run. Information reported during analysis: No install request found for package: "bcRedist", referred by package: "tools", install will be skipped as a result. Skipped: InstallToolsAction.23 Skipped: Action "InstallToolsAction.23" was not run. Information reported during analysis: No install request found for package: "ssmsee", referred by package: "tools", install will be skipped as a result. Skipped: InstallToolsAction.9 Skipped: Action "InstallToolsAction.9" was not run. Information reported during analysis: No install request found for package: "msxml6", referred by package: "tools", install will be skipped as a result. Skipped: 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/7/21 15:11:25 Installing: sql on target: DEBASER1 Failed to install package Fatal error during installation. Setting package return code to: 29503 Complete: InstallSqlAction at: 2007/7/21 15:15:29, returned false Error: Action "InstallSqlAction" failed during execution. Error information reported during run: Target collection includes the local machine. Invoking installPackage() on local machine. Skipped: InstallToolsAction.10 Skipped: Action "InstallToolsAction.10" was not run. Information reported during analysis: No install request found for package: "sqlxml4", referred by package: "tools", install will be skipped as a result. Skipped: 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: InstallToolsAction Skipped: Action "InstallToolsAction" was not run. Information reported during analysis: No install request found for package: "tools", install will be skipped as a result. Skipped: 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. Error: Action "ExposeVistaClusteredResources" failed during execution. Error information reported during run: Action: "ExposeVistaClusteredResources" will be marked as failed due to the following condition: Condition "The Clustered SQL Server instance that hosts is installed." returned false. Running: ReportChainingResults at: 2007/7/21 15:15:29 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
I'm trying to run a test from my test environment which is a non-domain Windows 2000 server to access my domain 2003 with SQL2005. I have install 2005 tools to try to access the SQL server.
- I have try following the KB265808 - no success. - Reading alot of blogs and it seems all are pointing to the same problem. "Remote access" but the settign is enabled.Error Message:
TITLE: Connect to Server ------------------------------
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=53&LinkId=20476
Question: Could Windows 2003 security be blocking access? I'm using sa account to access.
Also, sa account does not seems to work for remote access. It is ok when accessing locally.
I am having problems installing the SP2 for SQL server 2005 on a W2000 Professional. It appears that the Database Services, Analysis Services, Reporting Services and Integration Services are not being updated. I would appreciate any help with this if anyone has seen or had experience with this issue.
MSI (s) (68!20) [11:12:13:718]: Note: 1: 2262 2: Error 3: -2147287038 MSI (s) (68!20) [11:12:13:734]: Transforming table Error.
MSI (s) (68!20) [11:12:13:750]: Transforming table Error.
MSI (s) (68!20) [11:12:13:750]: Note: 1: 2262 2: Error 3: -2147287038 MSI (s) (68!20) [11:12:13:750]: Transforming table Error.
MSI (s) (68!20) [11:12:13:750]: Note: 1: 2262 2: Error 3: -2147287038 MSI (s) (68!20) [11:12:13:750]: Transforming table Error.
MSI (s) (68!20) [11:12:13:750]: Note: 1: 2262 2: Error 3: -2147287038 MSI (s) (68!20) [11:12:13:750]: Product: Microsoft SQL Server 2005 -- Error 29528. The setup has encountered an unexpected error while Installing performance counters. The error is: No se puede crear un archivo que ya existe.
Error 29528. The setup has encountered an unexpected error while Installing performance counters. The error is: No se puede crear un archivo que ya existe.
<EndFunc Name='LaunchFunction' Return='183' GetLastError='203'> MSI (s) (68:40) [11:12:13:828]: User policy value 'DisableRollback' is 0 MSI (s) (68:40) [11:12:13:828]: Machine policy value 'DisableRollback' is 0 Action ended 11:12:13: InstallFinalize. Return value 3. MSI (s) (68:40) [11:12:15:218]: Executing op: Header(Signature=1397708873,Version=301,Timestamp=898586856,LangId=1033,Platform=0,ScriptType=2,ScriptMajorVersion=21,ScriptMinorVersion=4,ScriptAttributes=1) MSI (s) (68:40) [11:12:15:218]: Executing op: DialogInfo(Type=0,Argument=1033) MSI (s) (68:40) [11:12:15:218]: Executing op: DialogInfo(Type=1,Argument=Microsoft SQL Server 2005) MSI (s) (68:40) [11:12:15:218]: Executing op: RollbackInfo(,RollbackAction=Rollback,RollbackDescription=Rolling back action:,RollbackTemplate=[1],CleanupAction=RollbackCleanup,CleanupDescription=Removing backup files,CleanupTemplate=File: [1]) MSI (s) (68:40) [11:12:15:234]: Executing op: RegisterBackupFile(File=C:Config.Msi51d0e9.rbf)
Microsoft SQL Server 2005 Setup beginning at Wed Jun 28 19:02:06 2006 Process ID : 1220 E:Serverssetup.exe Version: 2005.90.1399.0 Running: LoadResourcesAction at: 2006/5/28 19:2:5 Complete: LoadResourcesAction at: 2006/5/28 19:2:5, returned true Running: ParseBootstrapOptionsAction at: 2006/5/28 19:2:5 Loaded DLL:E:Serversxmlrw.dll Version:2.0.3604.0 Complete: ParseBootstrapOptionsAction at: 2006/5/28 19:2:6, returned false Error: Action "ParseBootstrapOptionsAction" failed during execution. Error information reported during run: Could not parse command line due to datastore exception. Source File Name: utillibpersisthelpers.cpp Compiler Timestamp: Fri Jul 29 01:13:55 2005 Function Name: writeEncryptedString Source Line Number: 124 ---------------------------------------------------------- writeEncryptedString() failed Source File Name: utillibpersisthelpers.cpp Compiler Timestamp: Fri Jul 29 01:13:55 2005 Function Name: writeEncryptedString Source Line Number: 123 ---------------------------------------------------------- Error Code: 0x80070002 (2) Windows Error Text: The system cannot find the file specified.
Source File Name: cryptohelpercryptsameusersamemachine.cpp Compiler Timestamp: Mon Jun 13 14:30:00 2005 Function Name: sqls::CryptSameUserSameMachine::ProtectData Source Line Number: 50
2 Could not skip Component update due to datastore exception. Source File Name: datastorecachedpropertycollection.cpp Compiler Timestamp: Fri Jul 29 01:13:49 2005 Function Name: CachedPropertyCollection::findProperty Source Line Number: 130 ---------------------------------------------------------- Failed to find property "InstallMediaPath" {"SetupBootstrapOptionsScope", "", "1220"} in cache Source File Name: datastorepropertycollection.cpp Compiler Timestamp: Fri Jul 29 01:13:50 2005 Function Name: SetupBootstrapOptionsScope.InstallMediaPath Source Line Number: 44 ---------------------------------------------------------- No collector registered for scope: "SetupBootstrapOptionsScope" Running: ValidateWinNTAction at: 2006/5/28 19:2:6 Complete: ValidateWinNTAction at: 2006/5/28 19:2:6, returned true Running: ValidateMinOSAction at: 2006/5/28 19:2:6 Complete: ValidateMinOSAction at: 2006/5/28 19:2:6, returned true Running: PerformSCCAction at: 2006/5/28 19:2:6 Complete: PerformSCCAction at: 2006/5/28 19:2:6, returned true Running: ActivateLoggingAction at: 2006/5/28 19:2:6 Error: Action "ActivateLoggingAction" threw an exception during execution. Error information reported during run: Datastore exception while trying to write logging properties. Source File Name: datastorecachedpropertycollection.cpp Compiler Timestamp: Fri Jul 29 01:13:49 2005 Function Name: CachedPropertyCollection::findProperty Source Line Number: 130 ---------------------------------------------------------- Failed to find property "primaryLogFiles" {"SetupStateScope", "", ""} in cache Source File Name: datastorepropertycollection.cpp Compiler Timestamp: Fri Jul 29 01:13:50 2005 Function Name: SetupStateScope.primaryLogFiles Source Line Number: 44 ---------------------------------------------------------- No collector registered for scope: "SetupStateScope" 00D9CFC4Unable to proceed with setup, there was a command line parsing error. : 2 Error Code: 0x80070002 (2) Windows Error Text: The system cannot find the file specified.
Source File Name: datastorepropertycollection.cpp Compiler Timestamp: Fri Jul 29 01:13:50 2005 Function Name: SetupBootstrapOptionsScope.InstallMediaPath Source Line Number: 44
Class not registered. Failed to create CAB file due to datastore exception Source File Name: datastorecachedpropertycollection.cpp Compiler Timestamp: Fri Jul 29 01:13:49 2005 Function Name: CachedPropertyCollection::findProperty Source Line Number: 130 ---------------------------------------------------------- Failed to find property "HostSetup" {"SetupBootstrapOptionsScope", "", "1220"} in cache Source File Name: datastorepropertycollection.cpp Compiler Timestamp: Fri Jul 29 01:13:50 2005 Function Name: SetupBootstrapOptionsScope.HostSetup Source Line Number: 44 ---------------------------------------------------------- No collector registered for scope: "SetupBootstrapOptionsScope" Message pump returning: 2
I have never installed sql server before and I didnt know if I just take the sql server 2005 standard edition media and boot off it and do a fresh install that way or do I have to install Windows server
SQL Server 2005 x64 Developer Edition Log output from the SP2 installation... ------------------------------------------------------------------------------------------------ Product : Database Services (MSSQLSERVER) Product Version (Previous): 2221 Product Version (Final) : Status : Failure Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQL9_Hotfix_KB921896_sqlrun_sql.msp.log Error Number : 11032 Error Description : Unable to install Windows Installer MSP file ------------------------------------------------------------------------------------------------
The C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQL9_Hotfix_KB921896_sqlrun_sql.msp.log file is a 5mb file that I can't make much sense out of...here are the first many lines of the file. I'll be glad to provide more information - just let me know what you need to know... Thanks, Dave
=== Verbose logging started: 8/15/2007 20:32:13 Build type: SHIP UNICODE 3.01.4000.4042 Calling process: e:47b31966cf7dcaa4e0fe0fa356ab34dahotfix.exe === MSI (c) (D4:9C) [20:32:13:508]: Resetting cached policy values MSI (c) (D4:9C) [20:32:13:508]: Machine policy value 'Debug' is 0 MSI (c) (D4:9C) [20:32:13:508]: ******* RunEngine: ******* Product: {F14F2E25-99AF-42A9-977C-F6D0352DC59F} ******* Action: ******* CommandLine: ********** MSI (c) (D4:9C) [20:32:13:508]: Client-side and UI is none or basic: Running entire install on the server. MSI (c) (D4:9C) [20:32:13:508]: Grabbed execution mutex. MSI (c) (D4:9C) [20:32:13:508]: Cloaking enabled. MSI (c) (D4:9C) [20:32:13:508]: Attempting to enable all disabled priveleges before calling Install on Server MSI (c) (D4:9C) [20:32:13:508]: Incrementing counter to disable shutdown. Counter after increment: 0 MSI (s) (9C:BC) [20:32:13:539]: Grabbed execution mutex. MSI (s) (9C:FC) [20:32:13:539]: Resetting cached policy values MSI (s) (9C:FC) [20:32:13:539]: Machine policy value 'Debug' is 0 MSI (s) (9C:FC) [20:32:13:539]: ******* RunEngine: ******* Product: {F14F2E25-99AF-42A9-977C-F6D0352DC59F} ******* Action: ******* CommandLine: ********** MSI (s) (9C:FC) [20:32:13:539]: Machine policy value 'DisableUserInstalls' is 0 MSI (s) (9C:FC) [20:32:13:539]: Adding MSIINSTANCEGUID to command line. MSI (s) (9C:FC) [20:32:13:539]: End dialog not enabled MSI (s) (9C:FC) [20:32:13:539]: Original package ==> C:WINDOWSInstaller1f00a5.msi MSI (s) (9C:FC) [20:32:13:539]: Package we're running from ==> C:WINDOWSInstaller1f00a5.msi MSI (s) (9C:FC) [20:32:13:586]: APPCOMPAT: looking for appcompat database entry with ProductCode '{F14F2E25-99AF-42A9-977C-F6D0352DC59F}'. MSI (s) (9C:FC) [20:32:13:586]: APPCOMPAT: no matching ProductCode found in database. MSI (s) (9C:FC) [20:32:13:586]: Detected that this product uses a multiple instance transform. MSI (s) (9C:FC) [20:32:13:586]: MSCOREE not loaded loading copy from system32 MSI (s) (9C:FC) [20:32:13:586]: Applying multiple instance transform 'qlRun01.mst'... MSI (s) (9C:FC) [20:32:13:586]: Looking for storage transform: SqlRun01.mst MSI (s) (9C:FC) [20:32:13:586]: Validating transform 'SqlRun01.mst' with validation bits 0x809 MSI (s) (9C:FC) [20:32:13:586]: Transform 'SqlRun01.mst' is valid. MSI (s) (9C:FC) [20:32:13:586]: Note: 1: 2205 2: 3: Patch MSI (s) (9C:FC) [20:32:13:586]: Note: 1: 2205 2: 3: PatchPackage MSI (s) (9C:FC) [20:32:13:586]: Note: 1: 2262 2: _Tables 3: -2147287038 MSI (s) (9C:FC) [20:32:13:586]: Note: 1: 2262 2: _Columns 3: -2147287038 MSI (s) (9C:FC) [20:32:13:586]: Note: 1: 2262 2: Media 3: -2147287038 MSI (s) (9C:FC) [20:32:13:586]: Note: 1: 2262 2: File 3: -2147287038 MSI (s) (9C:FC) [20:32:13:586]: TRANSFORM: 'PatchPackage' table is missing or empty. No pre-transform fixup necessary. MSI (s) (9C:FC) [20:32:13:586]: TRANSFORM: Applying regular transform to database. MSI (s) (9C:FC) [20:32:13:586]: Note: 1: 2262 2: _Tables 3: -2147287038 MSI (s) (9C:FC) [20:32:13:586]: Note: 1: 2262 2: _Columns 3: -2147287038 MSI (s) (9C:FC) [20:32:13:586]: Note: 1: 2262 2: _Validation 3: -2147287038 MSI (s) (9C:FC) [20:32:13:586]: Note: 1: 2262 2: File 3: -2147287038 MSI (s) (9C:FC) [20:32:13:586]: Note: 1: 2262 2: MsiFileHash 3: -2147287038 MSI (s) (9C:FC) [20:32:13:586]: Note: 1: 2262 2: Signature 3: -2147287038 MSI (s) (9C:FC) [20:32:13:586]: Note: 1: 2262 2: RegLocator 3: -2147287038 MSI (s) (9C:FC) [20:32:13:586]: Note: 1: 2262 2: AppSearch 3: -2147287038 MSI (s) (9C:FC) [20:32:13:586]: Note: 1: 2262 2: CompLocator 3: -2147287038 MSI (s) (9C:FC) [20:32:13:586]: Note: 1: 2262 2: DrLocator 3: -2147287038 MSI (s) (9C:FC) [20:32:13:586]: Note: 1: 2262 2: Binary 3: -2147287038 MSI (s) (9C:FC) [20:32:13:586]: Note: 1: 2262 2: CustomAction 3: -2147287038 MSI (s) (9C:FC) [20:32:13:586]: Note: 1: 2262 2: Directory 3: -2147287038 MSI (s) (9C:FC) [20:32:13:586]: Note: 1: 2262 2: Registry 3: -2147287038 MSI (s) (9C:FC) [20:32:13:586]: Note: 1: 2262 2: Condition 3: -2147287038 MSI (s) (9C:FC) [20:32:13:586]: Note: 1: 2262 2: CreateFolder 3: -2147287038 MSI (s) (9C:FC) [20:32:13:586]: Note: 1: 2262 2: _sqlObjectSecurity 3: -2147287038 MSI (s) (9C:FC) [20:32:13:586]: Note: 1: 2262 2: Icon 3: -2147287038 MSI (s) (9C:FC) [20:32:13:586]: Note: 1: 2262 2: InstallExecuteSequence 3: -2147287038 ...
Hope this helps someone. My experience is that an interrupted install of SP2 screws things royally, despite signifying success.
My initial attempt at installing SQL Server 2005 SP2 (64-bit) on our dev server resulted in massive corruption of at least one SSIS solution. Without the option to uninstall the SP2, the prospect of a complete reinstall/recovery totally ruined my day.
When I loaded the SSIS solution, all packages returned the following connection based errors "connection manager will not acquire a connection because the package OffLineMode property is TRUE". OffLineMode property was in fact set to the default "False" for all packages. Individual tasks were broken also. I did not search all packages, but FTP and File System tasks were all corrupted. Nor could I successfully create these tasks in a new packages, even within a new solution.
During the install I recived the following error: Error Log: Product : Database Services (MSSQLSERVER) Product Version (Previous): 2153 Product Version (Final) : Status : Failure Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQL9_Hotfix_KB921896_sqlrun_sql.msp.log Error Number : 29506 Error Description : MSP Error: 29506 SQL Server Setup failed to modify security permissions on file D:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLData for user xxxxx. To proceed, verify that the account and domain running SQL Server Setup exist, that the account running SQL Server Setup has administrator privileges, and that exists on the destination drive.
The SP2 install continued and with the exception of database Services, all other components were installed successfully.
A very helpful person had posted this solution:
The problem is that there exists a file in this Data directory that the user running SP1 does not have permissions to modify. The workaround is to figure out which file this is (typically a user created DB or some backup program files) and to temporarily assign permission to that file(s). You can revert back to the intended permissions after running SP1.
Sure enough, there was a data and a log file with permission restricted to a single user. Granting permission to the account doing the install worked.
I ran the SP2 again and the database Services component "succeeded". In fact, as outlined, my SSIS packages were unusable.
I re-ran the SP2 install. No components were selected for update, so I manually rechecked each component and executed. This time the install completed successfully for all components, and much to my relief, SSIS functionality was restored.
Pretty scrappy install package IMHO. There are obviously dependencies between the different components being updated, but if these dependencies, and therefore integrity of the update, are broken, the installer nevertheless reports success.
Can anyone help me with a problem I have with SSRS 2005? How do I configure SQL Server 2005 Reporting Services to deliver subscription e-mails to addresses external to my windows domain?
I've been having trouble configuring the Report Server e-mail delivery component to send subscription e-mails to addresses outside the domain on which the report server is hosted.
For e.g. since my local windows domain is named "smartsystems.com", I have found that the Report Manager does not have any problems sending subscription mails to "eawagu@smartsystems.com" but throws up an error whenever I include "eawagu@yahoo.com" in the recipients' list.
I am trying to install SQL 2005 in a 2-node virtual Windows 2003 cluster. I set the cluster up through Virtual Server 2005 with 2 virtual nodes and one virtual domain. The nodes can connect to each other as well as the physical machine. When I try to install a fresh copy of SQL 2005 on my cluster, I get an error every time. The error stops the installation while checking system configuration after installing prerequisites. The log file entry is as follows:
******************************************* Setup Consistency Check Report for Machine: --SERVERNAME-- ******************************************* 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: Warning Description: IIS is not installed, therefore Report Server feature will be disabled Action: Install IIS in order for Report Server feature to be enabled 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'> 1 Loaded DLL:C:Program FilesMicrosoft SQL Server90Setup Bootstrapsqlsval.dll Version:2005.90.1399.0 Error: Action "InvokeSqlSetupDllAction" threw an exception during execution. Error information reported during run: Source File Name: datastorecachedpropertycollection.cpp Compiler Timestamp: Fri Jul 29 01:13:49 2005 Function Name: CachedPropertyCollection::findProperty Source Line Number: 130 ---------------------------------------------------------- Failed to find property "ComputerList" {"SqlComputers", "", ""} in cache Source File Name: datastoreclusterinfocollector.cpp Compiler Timestamp: Fri Sep 16 13:20:12 2005 Function Name: ClusterInfoCollector::collectClusterVSInfo Source Line Number: 883 ---------------------------------------------------------- Failed to detect VS info due to datastore exception. Source File Name: datastoreclustergroupsproperties.cpp Compiler Timestamp: Fri Jul 29 01:13:49 2005 Function Name: ClusterGroupScope.SharedDisks Source Line Number: 56 ---------------------------------------------------------- Failed to find a cluster group that owned shared disk: J: WinException : 2 Error Code: 0x80070002 (2) Windows Error Text: The system cannot find the file specified. Source File Name: datastoreclustergroupsproperties.cpp Compiler Timestamp: Fri Jul 29 01:13:49 2005 Function Name: ClusterGroupScope.SharedDisks Source Line Number: 56
I am trying to install sql server 2005 express on 64 bit windows but i get a error message saying SQLncli_x64.msi file is missing and asks me to download it.
How can i fix this problem to install the SQL server on my Windows XP x64 Edition?
I'm unable to successfully install SQL 2005 on Windows Server 2003. Everything installs correctly except 'SQLXML4', and after installation, there's no Management Studio, unless I then install SQL Express Management Studio.
Installation details: Successfully installs 'Native Client' and the 'Support Files'. The 'System Configuration Check' passes everything. Installed 'Database Services', 'Integration Services', 'Client Components' (except for the 2 development tools), and 'Books Online'. Created the default instance (there were no other instances). Set it to run as 'Local System'. Set only the 'SQL Server' service to start after setup. Specified 'Mixed Mode'.
Then the installation proceeds, and everything looks good until SQLXML4 fails. Soon after, a window pops up saying "Setup is preparing to continue with the installation". Nothing happens till I click 'OK', and then 'Workstation Components' shows as having failed. Then the installation finishes normally. However there's no Management Studio, except that I then installed the SQL Express Management Studio, which appears to work fine.
I tried uninstalling, and installing again, but got the same results.
I'm currently running Windows Vista x64 and SQL server 2005 on an HP laptop with a AMD Turion 64 processor. I've install all of the Windows Vista x64 update so far with no issues. However, I'm unable to install SQL server 2005 SP2 via Windows updates.
I was able to successfully download the service pack with no issues and it is currenly on my machine ready to install. The system does take a check prior to the install process beginning to perform the install.
I continuely get and "Error Code A91" when the install process is running. As a result the install does not complete successfully. When I used the "Get Help" option I get a list of possible error conditions but none of them seem be useful. I checked each one and none of them provide any help with a solution.
I've successful installed SP2 on Vista x32 system with no problem. Is this a "Windows Update" issue?
Hello - We have been unable to successfully install Integration Services with an instance of SQL 2005 running on a Windows Small Business Server 2003. Installation proceeds with no errors, but when you attempt to connect to the Integrations Services and browse to where it apparently exists, the SQL Server Managment Studio returns the following error:
TITLE: Connect to Server ------------------------------
When I try to install SQL Server 2005 Expess SP2 with Advanced Services on a clean Windows XP system that has had Service Pack 3 applied I get the error "Setup is missing prerequisites: - MSXML6" when it starts to install SQL Server Management Studio Express. This is despite the fact that earlier in the installation is says it installed MSXML6, and my understanding is that MSXML6 is part of Windows XP Service Pack 3 anyway.
The SQL Express installation stops installing components at this point. The database server itself does seem to be operational.
Is there anything I can do to work around this? I would like our customers to be able to install and use Management Studio Express.
Here is the relevant snippet from SQLSetup0006_LUDQAVMXPEN_SSMSEE_1.log
Action start 8:03:54: AppSearch. MSI (s) (CC:98) [08:03:54:078]: PROPERTY CHANGE: Adding INSTALLSQLSHAREDDIR property. Its value is 'C:Program FilesMicrosoft SQL Server'. MSI (s) (CC:98) [08:03:54:078]: PROPERTY CHANGE: Adding UI_INSTALLSQLSHAREDDIR property. Its value is 'C:Program FilesMicrosoft SQL Server'. MSI (s) (CC:98) [08:03:54:078]: Note: 1: 1402 2: HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL ServerSSMSEECurrentVersion 3: 2 MSI (s) (CC:98) [08:03:54:078]: Note: 1: 2262 2: IniLocator 3: -2147287038 MSI (s) (CC:98) [08:03:54:078]: Note: 1: 2262 2: DrLocator 3: -2147287038 MSI (s) (CC:98) [08:03:54:078]: Note: 1: 1402 2: HKEY_LOCAL_MACHINESOFTWAREMicrosoftMSXML60Setup 3: 2 MSI (s) (CC:98) [08:03:54:078]: Note: 1: 2262 2: IniLocator 3: -2147287038 MSI (s) (CC:98) [08:03:54:078]: Note: 1: 2262 2: DrLocator 3: -2147287038 MSI (s) (CC:98) [08:03:54:078]: PROPERTY CHANGE: Adding SNACPRESENT property. Its value is '{11111111-1111-1111-1111-111111111111},{B0F9497C-52B4-4686-8E73-74D866BBDF59},{58D379F7-62BC-4748-8237-FE071ECE797C}'. MSI (s) (CC:98) [08:03:54:078]: Note: 1: 1402 2: HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL ServerASOLEDB9MSIRefCount 3: 2 MSI (s) (CC:98) [08:03:54:078]: Note: 1: 2262 2: IniLocator 3: -2147287038 MSI (s) (CC:98) [08:03:54:078]: Note: 1: 2262 2: DrLocator 3: -2147287038 MSI (s) (CC:98) [08:03:54:078]: Note: 1: 1402 2: HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL ServerADOMDMSIRefCount 3: 2 MSI (s) (CC:98) [08:03:54:078]: Note: 1: 2262 2: IniLocator 3: -2147287038 MSI (s) (CC:98) [08:03:54:078]: Note: 1: 2262 2: DrLocator 3: -2147287038 MSI (s) (CC:98) [08:03:54:078]: Note: 1: 1402 2: HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL ServerXMOMSIRefCount 3: 2 MSI (s) (CC:98) [08:03:54:078]: Note: 1: 2262 2: IniLocator 3: -2147287038 MSI (s) (CC:98) [08:03:54:078]: Note: 1: 2262 2: DrLocator 3: -2147287038 MSI (s) (CC:98) [08:03:54:078]: Note: 1: 1402 2: HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL Server90ToolsShell 3: 2 MSI (s) (CC:98) [08:03:54:078]: Note: 1: 2262 2: IniLocator 3: -2147287038 MSI (s) (CC:98) [08:03:54:078]: Note: 1: 2262 2: DrLocator 3: -2147287038 MSI (s) (CC:98) [08:03:54:093]: PROPERTY CHANGE: Adding DW20PATH_X86.8D56D6B0_25DE_4471_A64F_717FC5AB6330 property. Its value is 'C:PROGRA~1COMMON~1MICROS~1DWDW20.EXE'. MSI (s) (CC:98) [08:03:54:093]: Note: 1: 2262 2: IniLocator 3: -2147287038 MSI (s) (CC:98) [08:03:54:093]: Note: 1: 2262 2: DrLocator 3: -2147287038 MSI (s) (CC:98) [08:03:54:093]: Note: 1: 1402 2: HKEY_LOCAL_MACHINECLSID{31411198-a502-11d2-bbca-00c04f8ec294}InprocServer32 3: 2 MSI (s) (CC:98) [08:03:54:093]: Note: 1: 2262 2: IniLocator 3: -2147287038 MSI (s) (CC:98) [08:03:54:093]: Note: 1: 2262 2: DrLocator 3: -2147287038 MSI (s) (CC:98) [08:03:54:093]: Note: 1: 1402 2: HKEY_LOCAL_MACHINECLSID{31411198-a502-11d2-bbca-00c04f8ec294}InprocServer32 3: 2 MSI (s) (CC:98) [08:03:54:093]: Note: 1: 2262 2: IniLocator 3: -2147287038 MSI (s) (CC:98) [08:03:54:093]: Note: 1: 2262 2: DrLocator 3: -2147287038 MSI (s) (CC:98) [08:03:54:093]: Doing action: CA_URTVersionCmd.3643236F_FC70_11D3_A536_0090278A1BB8 Action ended 8:03:54: AppSearch. Return value 1. MSI (s) (CC:98) [08:03:54:093]: PROPERTY CHANGE: Adding URTVersion property. Its value is 'v2.0.50727'. Action start 8:03:54: CA_URTVersionCmd.3643236F_FC70_11D3_A536_0090278A1BB8. MSI (s) (CC:98) [08:03:54:093]: Skipping action: CA_SSMSAlreadyInstalled (condition is false) MSI (s) (CC:98) [08:03:54:093]: Doing action: MISSINGMSXML6.6D658EB9_E2B8_429A_92C4_84337700878E Action ended 8:03:54: CA_URTVersionCmd.3643236F_FC70_11D3_A536_0090278A1BB8. Return value 1. MSI (s) (CC:98) [08:03:54:093]: PROPERTY CHANGE: Adding MISSINGREDISTPREREQS property. Its value is ' - MSXML6'. Action start 8:03:54: MISSINGMSXML6.6D658EB9_E2B8_429A_92C4_84337700878E. MSI (s) (CC:98) [08:03:54:093]: Skipping action: MISSINGSNAC.6D658EB9_E2B8_429A_92C4_84337700878E (condition is false) MSI (s) (CC:98) [08:03:54:093]: Skipping action: MISSINGPTS9.6D658EB9_E2B8_429A_92C4_84337700878E (condition is false) MSI (s) (CC:98) [08:03:54:093]: Skipping action: MISSINGADOMD9.6D658EB9_E2B8_429A_92C4_84337700878E (condition is false) MSI (s) (CC:98) [08:03:54:093]: Skipping action: MISSINGXMO.6D658EB9_E2B8_429A_92C4_84337700878E (condition is false) MSI (s) (CC:98) [08:03:54:093]: Doing action: MISSINGPREREQERROR.6D658EB9_E2B8_429A_92C4_84337700878E Action ended 8:03:54: MISSINGMSXML6.6D658EB9_E2B8_429A_92C4_84337700878E. Return value 1. MSI (s) (CC:98) [08:03:54:109]: PROPERTY CHANGE: Adding MISSINGREDISTPREREQERROR property. Its value is 'Setup is missing prerequisites: - MSXML6 Go to http://go.microsoft.com/fwlink/?LinkId=54583'. Action start 8:03:54: MISSINGPREREQERROR.6D658EB9_E2B8_429A_92C4_84337700878E. MSI (s) (CC:98) [08:03:54:109]: Doing action: CA_ErrorMissingPreReqs Action ended 8:03:54: MISSINGPREREQERROR.6D658EB9_E2B8_429A_92C4_84337700878E. Return value 1. Action start 8:03:54: CA_ErrorMissingPreReqs. MSI (s) (CC:98) [08:23:30:937]: Product: Microsoft SQL Server Management Studio Express -- Setup is missing prerequisites: - MSXML6 Go to http://go.microsoft.com/fwlink/?LinkId=54583 Setup is missing prerequisites: - MSXML6 Go to http://go.microsoft.com/fwlink/?LinkId=54583 Action ended 8:23:30: CA_ErrorMissingPreReqs. Return value 3. Action ended 8:23:30: INSTALL. Return value 3.
Going to the mentioned link offers me a download of MSXML6, among other things....
Thanks, --- Barry Roskuski barry.roskuski@esko.com EskoArtwork Ludlow, MA
I originally posted this on the SQL Server Setup and Upgrade forum, but then I found this forum and though it might be more appropriate...
When I try to install SQL Server 2005 Expess SP2 with Advanced Services on a clean Windows XP system that has had Service Pack 3 applied I get the error "Setup is missing prerequisites: - MSXML6" when it starts to install SQL Server Management Studio Express. This is despite the fact that earlier in the installation is says it installed MSXML6, and my understanding is that MSXML6 is part of Windows XP Service Pack 3 anyway.
The SQL Express installation stops installing components at this point. The database server itself does seem to be operational.
Is there anything I can do to work around this? I would like our customers to be able to install and use Management Studio Express.
Here is the relevant snippet from SQLSetup0006_LUDQAVMXPEN_SSMSEE_1.log
Action start 8:03:54: AppSearch. MSI (s) (CC:98) [08:03:54:078]: PROPERTY CHANGE: Adding INSTALLSQLSHAREDDIR property. Its value is 'C:Program FilesMicrosoft SQL Server'. MSI (s) (CC:98) [08:03:54:078]: PROPERTY CHANGE: Adding UI_INSTALLSQLSHAREDDIR property. Its value is 'C:Program FilesMicrosoft SQL Server'. MSI (s) (CC:98) [08:03:54:078]: Note: 1: 1402 2: HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL ServerSSMSEECurrentVersion 3: 2 MSI (s) (CC:98) [08:03:54:078]: Note: 1: 2262 2: IniLocator 3: -2147287038 MSI (s) (CC:98) [08:03:54:078]: Note: 1: 2262 2: DrLocator 3: -2147287038 MSI (s) (CC:98) [08:03:54:078]: Note: 1: 1402 2: HKEY_LOCAL_MACHINESOFTWAREMicrosoftMSXML60Setup 3: 2 MSI (s) (CC:98) [08:03:54:078]: Note: 1: 2262 2: IniLocator 3: -2147287038 MSI (s) (CC:98) [08:03:54:078]: Note: 1: 2262 2: DrLocator 3: -2147287038 MSI (s) (CC:98) [08:03:54:078]: PROPERTY CHANGE: Adding SNACPRESENT property. Its value is '{11111111-1111-1111-1111-111111111111},{B0F9497C-52B4-4686-8E73-74D866BBDF59},{58D379F7-62BC-4748-8237-FE071ECE797C}'. MSI (s) (CC:98) [08:03:54:078]: Note: 1: 1402 2: HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL ServerASOLEDB9MSIRefCount 3: 2 MSI (s) (CC:98) [08:03:54:078]: Note: 1: 2262 2: IniLocator 3: -2147287038 MSI (s) (CC:98) [08:03:54:078]: Note: 1: 2262 2: DrLocator 3: -2147287038 MSI (s) (CC:98) [08:03:54:078]: Note: 1: 1402 2: HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL ServerADOMDMSIRefCount 3: 2 MSI (s) (CC:98) [08:03:54:078]: Note: 1: 2262 2: IniLocator 3: -2147287038 MSI (s) (CC:98) [08:03:54:078]: Note: 1: 2262 2: DrLocator 3: -2147287038 MSI (s) (CC:98) [08:03:54:078]: Note: 1: 1402 2: HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL ServerXMOMSIRefCount 3: 2 MSI (s) (CC:98) [08:03:54:078]: Note: 1: 2262 2: IniLocator 3: -2147287038 MSI (s) (CC:98) [08:03:54:078]: Note: 1: 2262 2: DrLocator 3: -2147287038 MSI (s) (CC:98) [08:03:54:078]: Note: 1: 1402 2: HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL Server90ToolsShell 3: 2 MSI (s) (CC:98) [08:03:54:078]: Note: 1: 2262 2: IniLocator 3: -2147287038 MSI (s) (CC:98) [08:03:54:078]: Note: 1: 2262 2: DrLocator 3: -2147287038 MSI (s) (CC:98) [08:03:54:093]: PROPERTY CHANGE: Adding DW20PATH_X86.8D56D6B0_25DE_4471_A64F_717FC5AB6330 property. Its value is 'C:PROGRA~1COMMON~1MICROS~1DWDW20.EXE'. MSI (s) (CC:98) [08:03:54:093]: Note: 1: 2262 2: IniLocator 3: -2147287038 MSI (s) (CC:98) [08:03:54:093]: Note: 1: 2262 2: DrLocator 3: -2147287038 MSI (s) (CC:98) [08:03:54:093]: Note: 1: 1402 2: HKEY_LOCAL_MACHINECLSID{31411198-a502-11d2-bbca-00c04f8ec294}InprocServer32 3: 2 MSI (s) (CC:98) [08:03:54:093]: Note: 1: 2262 2: IniLocator 3: -2147287038 MSI (s) (CC:98) [08:03:54:093]: Note: 1: 2262 2: DrLocator 3: -2147287038 MSI (s) (CC:98) [08:03:54:093]: Note: 1: 1402 2: HKEY_LOCAL_MACHINECLSID{31411198-a502-11d2-bbca-00c04f8ec294}InprocServer32 3: 2 MSI (s) (CC:98) [08:03:54:093]: Note: 1: 2262 2: IniLocator 3: -2147287038 MSI (s) (CC:98) [08:03:54:093]: Note: 1: 2262 2: DrLocator 3: -2147287038 MSI (s) (CC:98) [08:03:54:093]: Doing action: CA_URTVersionCmd.3643236F_FC70_11D3_A536_0090278A1BB8 Action ended 8:03:54: AppSearch. Return value 1. MSI (s) (CC:98) [08:03:54:093]: PROPERTY CHANGE: Adding URTVersion property. Its value is 'v2.0.50727'. Action start 8:03:54: CA_URTVersionCmd.3643236F_FC70_11D3_A536_0090278A1BB8. MSI (s) (CC:98) [08:03:54:093]: Skipping action: CA_SSMSAlreadyInstalled (condition is false) MSI (s) (CC:98) [08:03:54:093]: Doing action: MISSINGMSXML6.6D658EB9_E2B8_429A_92C4_84337700878E Action ended 8:03:54: CA_URTVersionCmd.3643236F_FC70_11D3_A536_0090278A1BB8. Return value 1. MSI (s) (CC:98) [08:03:54:093]: PROPERTY CHANGE: Adding MISSINGREDISTPREREQS property. Its value is ' - MSXML6'. Action start 8:03:54: MISSINGMSXML6.6D658EB9_E2B8_429A_92C4_84337700878E. MSI (s) (CC:98) [08:03:54:093]: Skipping action: MISSINGSNAC.6D658EB9_E2B8_429A_92C4_84337700878E (condition is false) MSI (s) (CC:98) [08:03:54:093]: Skipping action: MISSINGPTS9.6D658EB9_E2B8_429A_92C4_84337700878E (condition is false) MSI (s) (CC:98) [08:03:54:093]: Skipping action: MISSINGADOMD9.6D658EB9_E2B8_429A_92C4_84337700878E (condition is false) MSI (s) (CC:98) [08:03:54:093]: Skipping action: MISSINGXMO.6D658EB9_E2B8_429A_92C4_84337700878E (condition is false) MSI (s) (CC:98) [08:03:54:093]: Doing action: MISSINGPREREQERROR.6D658EB9_E2B8_429A_92C4_84337700878E Action ended 8:03:54: MISSINGMSXML6.6D658EB9_E2B8_429A_92C4_84337700878E. Return value 1. MSI (s) (CC:98) [08:03:54:109]: PROPERTY CHANGE: Adding MISSINGREDISTPREREQERROR property. Its value is 'Setup is missing prerequisites: - MSXML6 Go to http://go.microsoft.com/fwlink/?LinkId=54583'. Action start 8:03:54: MISSINGPREREQERROR.6D658EB9_E2B8_429A_92C4_84337700878E. MSI (s) (CC:98) [08:03:54:109]: Doing action: CA_ErrorMissingPreReqs Action ended 8:03:54: MISSINGPREREQERROR.6D658EB9_E2B8_429A_92C4_84337700878E. Return value 1. Action start 8:03:54: CA_ErrorMissingPreReqs. MSI (s) (CC:98) [08:23:30:937]: Product: Microsoft SQL Server Management Studio Express -- Setup is missing prerequisites: - MSXML6 Go to http://go.microsoft.com/fwlink/?LinkId=54583 Setup is missing prerequisites: - MSXML6 Go to http://go.microsoft.com/fwlink/?LinkId=54583 Action ended 8:23:30: CA_ErrorMissingPreReqs. Return value 3. Action ended 8:23:30: INSTALL. Return value 3.
Going to the mentioned link offers me a download of MSXML6, among other things....
Thanks, --- Barry Roskuski barry.roskuski@esko.com EskoArtwork Ludlow, MA
hi everyone, can anyone help me how to install sql 2005 server express edition on windows server 2003 x64 edition. because its my first time installing on a 64 bit OS i dont know how. When i tried installing it gives a warning on ASP.Net , when i ignore that & continue the installation. when installing now the SQLServer Management Studio Express now it says "installation of this product failed because it is not supported on this qperating system....." any idea?
I have been unable to install SQL Express 2005 Server on my Windows 2003 Server (with SP2 installed). I keep getting an error message saying that Microsoft Windows Installer 3.1 is not installed.
Click here for image
So, I downloaded Microsoft Windows Installer 3.1 v2 (WindowsInstaller-KB893803-v2-x86.exe) but whenever I try to install it I get an error message saying that "the Service Pack version of this system is newer than the update you are applying" and that there is no need to install the update and it stops there.
Click here for image
Is there a workaround to this? How can I get Microsoft Windows Installer 3.1 installed? I tried going to the Windows Update site, I already have everything installed and I even started the Windows Installer service manually. Has anyone else experienced this?
How can I get SQL Server 2005 Express installed if not how can I install SQL Server 2000 on tihs machine? The only reason I am trying to install SQL Server 2005 is because wanted to try it so I uninstalled SQL Server 2000 now I can no longer install SQL Server 2000 again because it won't let me because of the SP2 patch.
I tried to install SQL Server 2005 (x64) Standard Edition on Windows Server 2003 R2 (x64) Standard Edition. My box meet the requirement. But I got the following error when the installing progress was just about to begin:
Error 1016:Could not access network location k.3643236F_FC70_11D3_A536_0090278A1BB8]URTVersio.
(this is exactly what i saw in the system log)
what does it mean?? i am totally confused...what the hell is the k.3643236F_FC70_11D3_A536_0090278A1BB8]URTVersio????
I'm trying to install SQL Server 2005 Enterprise Edition 64-bit on a 64-bit instance of Windows 2008 running as Server Core. I read about an issue in KB article 920201, but I don't even get that far. The setup first tries to install .NET Framework 2.0, which fails with error message: Error 70243 installing .NET Framework 2.0
I tried installing .NET Framework separately, which indicates that I need to install Internet Explorer 5.01. I'm reluctant to try that, so I'd like to know if the people that actually got to the issue in KB920201 installed IE first (is that even possible?).
I have just take my system back to the factory defaults after some unsuccessful attempts to install 64 bit and 32 bit sql server on my notebook. I am looking to use either 32 or 64 bit (I have disks for both) and I would like to get a step by step guide that will help me through the process.
I tried an install of the 64 bit version, applied SP2, and it went smoothly but the report services browser didn't work. I tried to change some IIS settings but I didnt document what I changed so i was unable to undo the changes that i made when these didnt work.
I tried several combinations of things but then decided that a clean install on a clean system was the best option.
I need the SQL engine , reporting services, analysis services - and possibly integration services - i am not sure if i need notification services (dont know what it does anyway!)
I also have vs2005 - should i install that first or after sql server 2005 SP2?
I Try to install SQL Server Express in Windows 2003 Standard edition x64 and have some problems.
It say that can not instal client and say to use sqlncli_x64.msi, but I can not find this packege to install this client and I receive one alert with ASP.NET register 64.
I Check all request systems requirements many times and looks ok.
How can I solve this to install properly the SQL 2005 Express? When the setup finish say that was not possiblem to install SQL Server 2005 Express.
I'm facing a problem while installing the SQL Server 2005 Express on Windows 2000 Pro with SP4.
After finishing the downloading from Microsoft I start the installation and things seems to go ok but during Extracting Files step a message appears "SQL Server Setup unexpectedly failed. For more information, review the setup summary log file in %Program Files%Microsoft SQL Server90Setup BootstrapLOGSummary.txt" and it terminates the installation.
I located the log file and open it but can't understand the problem..I copy the text and paste it here for anyone who can understand it.Please, it is very importand for me to work with SQL Server for my project. Any advice or information or anything else???
Thank you all,
HERE IS THE LOG FILE:
"Microsoft SQL Server 2005 Setup beginning at Wed Mar 14 07:45:33 2007 Process ID : 2684 c:c7720b32114815db82783dd06c2d54b9setup.exe Version: 2005.90.3042.0 Running: LoadResourcesAction at: 2007/2/14 7:45:33 Complete: LoadResourcesAction at: 2007/2/14 7:45:33, returned true Running: ParseBootstrapOptionsAction at: 2007/2/14 7:45:33 Loaded DLL:c:c7720b32114815db82783dd06c2d54b9xmlrw.dll Version:2.0.3609.0 Complete: ParseBootstrapOptionsAction at: 2007/2/14 7:45:33, returned false Error: Action "ParseBootstrapOptionsAction" failed during execution. Error information reported during run: Could not parse command line due to datastore exception. Source File Name: utillibpersisthelpers.cpp Compiler Timestamp: Wed Jun 14 16:30:14 2006 Function Name: writeEncryptedString Source Line Number: 124 ---------------------------------------------------------- writeEncryptedString() failed Source File Name: utillibpersisthelpers.cpp Compiler Timestamp: Wed Jun 14 16:30:14 2006 Function Name: writeEncryptedString Source Line Number: 123 ---------------------------------------------------------- Error Code: 0x80070002 (2) Windows Error Text: Error: Action "ActivateLoggingAction" threw an exception during execution. Error information reported during run: Datastore exception while trying to write logging properties. Source File Name: datastorecachedpropertycollection.cpp Compiler Timestamp: Wed Jun 14 16:27:59 2006 Function Name: CachedPropertyCollection::findProperty Source Line Number: 130 ---------------------------------------------------------- Failed to find property "primaryLogFiles" {"SetupStateScope", "", ""} in cache Source File Name: datastorepropertycollection.cpp Compiler Timestamp: Wed Jun 14 16:28:01 2006 Function Name: SetupStateScope.primaryLogFiles Source Line Number: 44 ---------------------------------------------------------- No collector registered for scope: "SetupStateScope" 02B1CFC0Unable to proceed with setup, there was a command line parsing error. : 2 Error Code: 0x80070002 (2) Windows Error Text: Class not registered. Failed to create CAB file due to datastore exception Source File Name: datastorecachedpropertycollection.cpp Compiler Timestamp: Wed Jun 14 16:27:59 2006 Function Name: CachedPropertyCollection::findProperty Source Line Number: 130 ---------------------------------------------------------- Failed to find property "HostSetup" {"SetupBootstrapOptionsScope", "", "2684"} in cache Source File Name: datastorepropertycollection.cpp Compiler Timestamp: Wed Jun 14 16:28:01 2006 Function Name: SetupBootstrapOptionsScope.HostSetup Source Line Number: 44 ---------------------------------------------------------- No collector registered for scope: "SetupBootstrapOptionsScope" Message pump returning: 2"
I have attempted to install SP1 on to my SQL 2005 Server numerous times and cannot get it to be successful. It failes on database services everytime and the log and event log report that my account cannot change permissions on the Data directory. My system is running Server 2003 R2 Ent x64. I have a Cluster setup with no second node at this time (future additon). I am also using a mount point inside the Data directory for logs. I have monitored the install using FileMon and do not see any file access issues during the installation process. I have also looked at the files and directories within the Data directory and all security ACLs seem fine. I am running the install with an account that has admin permission on the box. The service account I am using to run the sql service does not have admin permission but it is in the groups that SQL sets up at install time and those groups are assigned to the Data directory and other directories that the install configures. Any and all help us greatly appriciated!!
Hi we have a two node windows 2003 x64 cluster, each running a SQL 2005 instance. I've added a new node to the cluster and am now trying to set up a new instance of SQL 2005 on the new node (node c). During the install i am getting a failure just after the stage where you choose the features to install. I'm selecting SQL database engine with Failover Cluster. When i click next i get a message which states:
"The drive specified cannot be used for program location. Program Files must be installed on a valid local disk available on all cluster nodes. The valid values are"
I've read a number of articles about possible causes for this and i've checked all the suggested causes but none of these have made a difference. The cluster disk resource is healthy and can be failed between all nodes in the cluster. No errors are generated. I am using an account which has domain admin rights and I can access all admin shares on all nodes. Some of the articles i have referenced are here:
http://support.microsoft.com/kb/907261
http://support.microsoft.com/?kbid=913815
http://blogs.technet.com/mbaher/archive/2007/03/23/clustering-sql-2005-and-administrative-shares.aspx I've tried uninstalling all components etc but still i can't get it to work. The next step is rebuilding the server completely so does anyone have any suggestions?
