I am trying to upgrade SQL 2000 SP3 to SQL 2005 SP2 on a Windows 2003 server with all the latest patches. The SQL 2005 install went through like it was supposed to but when it was nearly finished it gave the message:
" there was an unexpected failiure during the setup wizard. You may review the setup logs and/or click the help button for more info". I'm pretty new to Microsoft SQL so I looked at help and there was no information.
I've tried running setup again and keep getting the above error message. During the install the program says everthing is installed but I've noticed the Management Center is missing.
hello, what is the general consensus on installing SQL 2005. I usually run a backup of SQL 2000 dbs and then restore on SQL 2005 and change compatibility to 9.0. Is it the right way to upgrade? I'm only asking because I also did one db in-place to SQL 2005 and thought it went well until I browsed my system dbs. All of them are missing tables that usually appear in SQL 2005 system dbs. Other than that I haven't run into too many problems.
We are performing a SQL 2005 SP1 upgrade from SQL 2000 on our Windows 2003 SP1 Standard Edition.
When we run the upgrade, we got a error "Upgrade Advisor Return -1" as a pop-up window.
When we run the Upgrade Advisor separately, we get this error :
===================================
Common Language Runtime detected an invalid program.
===================================
Common Language Runtime detected an invalid program. (System.Xml)
------------------------------ Program Location:
at System.Xml.Schema.SchemaInfo..ctor() at System.Xml.Schema.XmlSchemaSet..ctor(XmlNameTable nameTable) at System.Xml.XmlReaderSettings.get_Schemas() at Microsoft.SqlServer.UpgradeAdvisor.ReportViewer.UAReportController.LoadAndValidateDataFile() at Microsoft.SqlServer.UpgradeAdvisor.ReportViewer.UAReport.ValidateDataFile() at Microsoft.SqlServer.UpgradeAdvisor.ReportViewer.UAIssueReport.Refresh() at Microsoft.SqlServer.UpgradeAdvisor.ReportPanel.OpenReport(String reportFile)
We are in a lost for solutions. We do hope to hear from anyone asap...
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.
I am trying to upgrade from SQL Server 2000 SP4 to SQL Server 2005. But I am getting an error saying that " Your operating system does not meet service pack requirements for the SQL server release. Install the service pack from the Microsoft download center at http://go.microsoft.com/fwlink/?LinkID=50380, and then run the SQL Server Setup again. For system requirements, see hardware and software requirements, in the readme or in SQL Server Books online."
I don't know what other service pack I would need to upgrade to again when I already have SP4 installed. Could someone tell me what I need to do next.
I am trying to upgrade an existing SQL Server 2000(SP3) instance to 2005.
In the installation process it showed me an existing component SQL Server 2000. But when I select the checkbox and hit the next button to upgrade the Database Engine I get an error
"Microsft SQL Server 2005 Error 1603. The setup has encountered an unexpected error while NextUpgradeDialog."
I am logged in as Administrator and have full permission.
Any help is appreciated.
Following is the Log File
Microsoft SQL Server 2005 Setup beginning at Tue Oct 09 11:30:49 2007 Process ID : 2940 E:Serverssetup.exe Version: 2005.90.1399.0 Running: LoadResourcesAction at: 2007/9/9 11:30:48 Complete: LoadResourcesAction at: 2007/9/9 11:30:48, returned true Running: ParseBootstrapOptionsAction at: 2007/9/9 11:30:48 Loaded DLL:E:Serversxmlrw.dll Version:2.0.3604.0 Complete: ParseBootstrapOptionsAction at: 2007/9/9 11:30:49, returned true Running: ValidateWinNTAction at: 2007/9/9 11:30:49 Complete: ValidateWinNTAction at: 2007/9/9 11:30:49, returned true Running: ValidateMinOSAction at: 2007/9/9 11:30:49 Complete: ValidateMinOSAction at: 2007/9/9 11:30:49, returned true Running: PerformSCCAction at: 2007/9/9 11:30:49 Complete: PerformSCCAction at: 2007/9/9 11:30:49, returned true Running: ActivateLoggingAction at: 2007/9/9 11:30:49 Complete: ActivateLoggingAction at: 2007/9/9 11:30:49, returned true Delay load of action "DetectPatchedBootstrapAction" returned nothing. No action will occur as a result. Action "LaunchPatchedBootstrapAction" will be skipped due to the following restrictions: Condition "EventCondition: __STP_LaunchPatchedBootstrap__2940" returned false. Running: PerformSCCAction2 at: 2007/9/9 11:30:49 Loaded DLL:C:WINDOWSsystem32msi.dll Version:3.1.4000.4042 Loaded DLL:C:WINDOWSsystem32msi.dll Version:3.1.4000.4042 Complete: PerformSCCAction2 at: 2007/9/9 11:30:50, returned true Running: PerformDotNetCheck at: 2007/9/9 11:30:50 Complete: PerformDotNetCheck at: 2007/9/9 11:30:50, returned true Running: ComponentUpdateAction at: 2007/9/9 11:30:50 Complete: ComponentUpdateAction at: 2007/9/9 11:31:44, returned true Running: DetectLocalBootstrapAction at: 2007/9/9 11:31:44 Complete: DetectLocalBootstrapAction at: 2007/9/9 11:31:44, returned true Running: LaunchLocalBootstrapAction at: 2007/9/9 11:31:44 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 Message pump returning: 1603
I'm getting a Windows Installer error when attempting to run the Upgrade Advisor setup package (SQLUASetup.exe). The error message reads:
"This installation package cannot be installed by the Windows Installer service. You must install a Windows service pack that contains a newer version of the Windows Installer service."
The machine is running Windows 2000 sp4. Both the .net framework v2 and Windows Installer 3.0 have been installed.
I got the following error using either NT or SQL Login ('sa') that are sysadmin in my SQL 2005 instance:
Your Account information could not be verified for one or more instances. Ensure that you can connect to all the selected instances using the account information provided. To process further deselect the instances to which connectivity cannot be established.
However, I would login to SQL 2005 named instance, either NT or SQL login 'sa' without any problems to do anything I want because both are sysadmin.
<PS> Note that my default SQL instance in my local server is SQL 2000 and SQL 2005 named instance.
Unable to connect to server. Reason: 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: TCP Provider, error: 0 - No connection could be made because the target machine actively refused it.)
SQL 2000 to SQL 2005 Upgrade Error - Database Down - Help Appreciated
I am upgrading a SQL 2000 standard database server to SQL 2005 standard on a windows 2003 server
I am logged in as domain admin and started the upgrade as 'sa'
The upgrade stops with the error:
Service MSSQLSERVICE can not be started. Verify you have sufficient privilages to start system services. The error code is (17185)
The error log shows:
2007-01-04 15:59:38.77 Server Authentication mode is MIXED.
2007-01-04 15:59:38.79 Server Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)
Oct 14 2005 00:33:37
Copyright (c) 1988-2005 Microsoft Corporation
Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
2007-01-04 15:59:38.79 Server (c) 2005 Microsoft Corporation.
2007-01-04 15:59:38.79 Server All rights reserved.
2007-01-04 15:59:38.79 Server Server process ID is 4188.
2007-01-04 15:59:38.79 Server Logging SQL Server messages in file 'F:SQLDataMSSQLlogERRORLOG'.
2007-01-04 15:59:38.79 Server This instance of SQL Server last reported using a process ID of 2980 at 1/4/2007 3:56:58 PM (local) 1/4/2007 2:56:58 AM (UTC). This is an informational message only; no user action is required.
2007-01-04 15:59:38.79 Server Registry startup parameters:
2007-01-04 15:59:38.79 Server -d F:SQLDataMSSQLdatamaster.mdf
2007-01-04 15:59:38.79 Server -e F:SQLDataMSSQLlogERRORLOG
2007-01-04 15:59:38.79 Server -l F:SQLDataMSSQLdatamastlog.ldf
2007-01-04 15:59:38.79 Server Command Line Startup Parameters:
2007-01-04 15:59:38.79 Server -s MSSQLSERVER
2007-01-04 15:59:38.79 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2007-01-04 15:59:38.79 Server Detected 4 CPUs. This is an informational message; no user action is required.
2007-01-04 15:59:38.83 Server Set AWE Enabled to 1 in the configuration parameters to allow use of more memory.
2007-01-04 15:59:39.02 Server Using the static lock allocation specified in the locks configuration option. Allocated 20000 Lock blocks and 20000 Lock Owner blocks per node. This is an informational message only. No user action is required.
2007-01-04 15:59:39.02 Server Multinode configuration: node 0: CPU mask: 0x0000000a Active CPU mask: 0x0000000a. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
2007-01-04 15:59:39.04 Server Multinode configuration: node 1: CPU mask: 0x00000005 Active CPU mask: 0x00000005. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
2007-01-04 15:59:39.04 Server Attempting to initialize Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
2007-01-04 15:59:41.04 Server Attempting to recover in-doubt distributed transactions involving Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
2007-01-04 15:59:41.04 Server Database Mirroring Transport is disabled in the endpoint configuration.
2007-01-04 15:59:41.04 spid7s Starting up database 'master'.
2007-01-04 15:59:41.05 spid7s 1 transactions rolled forward in database 'master' (1). This is an informational message only. No user action is required.
2007-01-04 15:59:41.07 spid7s 0 transactions rolled back in database 'master' (1). This is an informational message only. No user action is required.
2007-01-04 15:59:41.07 spid7s Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
2007-01-04 15:59:41.08 spid7s SQL Trace ID 1 was started by login "sa".
2007-01-04 15:59:41.08 spid7s Starting up database 'mssqlsystemresource'.
2007-01-04 15:59:41.11 spid7s Using 'dbghelp.dll' version '4.0.5'
2007-01-04 15:59:41.11 spid7s ***Stack Dump being sent to F:SQLDataMSSQLLOGSQLDump0035.txt
2007-01-04 15:59:41.11 spid7s SqlDumpExceptionHandler: Process 7 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
2007-01-04 15:59:41.27 spid7s Unable to update password policy.
2007-01-04 15:59:41.27 spid7s SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.
Hi all,Not sure where to post this but hopefully here...I am trying to install SQL Server 2005 on my laptop - It installed fine on a desktop PC but on the laptop I get"The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine JBXEL Error:2147749896 (0x80041008). For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=70342(No answers on this link!)"I Have spent the last week Googling this and have tried everything to fix it bar re-install Windows (XPPro SP2)I have run bat scripts, re-reged dlls and .exe files and much more but to no avail.One poster mentioned that in his case it was something to do with the windows firewall.I notice that under the advanced tab in my wirewall dialogue it says that the local connection is corrupt (or something similar)Could this be part of the problem?All help gratefully received.Cheers,j
I'm getting the below error after installing SQL server with new instant name in exsiting SQL server 2000. Could you provide me workaround if you have faced same kind of issue?. Erorr: Application popup: DTSRun.exe - Unable To Locate Component : This application has failed to start because SqlResourceLoader.dll was not found. Re-installing the application may fix this problem.
Hi, I am trying to install the sql 2005, the install goes through like it supposed to, when i click "Finish" it goes off with a message box : " there was an unexpected failiure during the setup wizard. You may review the setup logs and/or click the help button for more info". the info is: LinkID: 20476 Product Name: MS SQL Server Product ver: 9.00.1399.06 message source: setup.rll message ID: 50000 EvtType: setupsqlsetupactions.cpp@InvokeSqlSetupDllAction@sqls::InvokeSqlSetupDllAction:erform@0x2
the yes button opens a link: http://www.microsoft.com/products/ee/transform.aspx?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=50000&EvtType=setup%5csqlsetupactions.cpp%40InvokeSqlSetupDllAction%40sqls%3a%3aInvokeSqlSetupDllAction%3a%3aperform%400x2 and it says " were sorry there is no additional info about this error"
I am running on Win XP pro sp2. COULD ANYONE PLEASE HELP ME??? must install sql server!! THANX!! Uri.
I'm getting an error when the SQL install program checks the system - "The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine DI-ERP2 Error:2148007941 (0x80080005).
I've tried a bunch of stuff as suggested by some of the other threads, but nothing is working so far...
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.
Edition check:
Your upgrade is blocked because of edition upgrade rules. For more information about edition upgrades, see the Version and Edition Upgrades topic in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.
The following version and editions have been verified.
1. .NET 2.0 installed
2. Windows XP SP2
3. MSDE 8.00.2039(SP4)
4. all MSDE databases are owned by sa
5. Instance and SQLAgent running under user that is member of Administrators
What are the possible reasons this error is occurring?
I'm receiving an error when i'm trying to setup a maintenance plan. I'm getting weird errors (and cannot continue) and i'm thinking it's related to a 32 bit error i received during installation on a 64 bit edition.
Background We have a sql server behind hosted on a dedicated 64 bit box out of SanFran. The hosting company installed the 32 bit version of SqlServer 2005 standard on the box and I requested them to remove it and put the 64 bit edition on. They removed the 32 bit edition and installed the 64 bit edition. So far so good. I installed sp1 and that was fine. I then tried to start a MAINTENCE PLAN and was denied -> the component was not installed. I've asked them to install the component and they did, but they recorded an error during the install. The error screen shot is here: http://img525.imageshack.us/img525/5089/errormessagehs4.png
Now i cannot drop any tasks onto the maintenence plan ... so i'm assuming it's related to the above error. Is there any way i can determine what the 32 bit component is, remove it and re-install the correct component? Is there an error log somewhere where i can check things?
This is stopping me from setting up any backup plans :(
I'm trying to install SQL 2005 Server onto a Windows XP Professional SP2 workstation. Whenever the splash.hta program is run an error with a header of "Internet Explorer Script Error" comes up where the error is "Dynamic link library (DLL) initialization routine failed". It asks if I want to continue running scrips on this page and no matter what I click, it will open up the menu screen. I then click on server components to install and get the same error just on a different file and it will not continue past that. These script errors do not occur on another workstation.
I downloaded the SQL Server 2005 Evaluation setup .exe. When I wen to install it by clicking "SQLEVAL.EXE", I received an eror stating "There is not enough space on Drive C: to extract this package.
I have over 50 gig of available spac eon my C drive. What gives?
When I downloaded the .exe, I had the Norton AntiVirus Auto-Protect enabled. Could that have caused it? Also, 2 days ago, I installed MS-Accounting 2007. Could that have caused a problem?
I have seen this error posted on the SS2005 forums and the standard response is to look at the installation logs. I have no logs. The extraction never completed.
I have installed Feb 2006 CTP Vista Build 5308,but when i install SQL Server 2005,it crashed.
Error Message:
sql server setup could not connect to the database service for server confiurgration.The error was[Microsoft][SQL Native Client]Shared Memory Provider:No process is on the other end of pipe.
And the start menu/All Programe didn't not appear "Microsoft SQL Server".
We have a server instance on SQL Server 2005 SP2 build 3042. We have a 32 bit x86 server. We attempted to upgrade to SP2 build 3054 KB934458. And we got the following error as stated in the Summary.txt file.
Code Snippet ********************************************************************************** Product Installation Status Product : SQL Server Database Services 2005 (MSSQLSERVER) Product Version (Previous): 3042 Product Version (Final) : Status : Failure Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQL9_Hotfix_KB934458_sqlrun_sql.msp.log Error Number : 29538 Error Description : MSP Error: 29538 SQL Server Setup did not have the administrator permissions required to rename a file: e:SQLDatamssqlsystemresource1.ldf. To continue, verify that the file exists, and either grant administrator permissions to the account currently running Setup or log in with an administrator account. Then run SQL Server Setup again. ----------------------------------------------------------------------------------
The client tools and workstation components were successfully installed. The server is still reporting build 3042.
Here is the portions of the HotFix.log file.
Code Snippet 05/12/2008 09:19:09.041 Copy Engine: Creating MSP install log file at: C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQL9_Hotfix_KB934458_sqlrun_sql.msp.log 05/12/2008 09:19:09.072 Registry: Opened registry key "SoftwarePoliciesMicrosoftWindowsInstaller" 05/12/2008 09:19:09.103 Registry: Cannot read registry key value "Debug" 05/12/2008 09:21:29.382 MSP Error: 29538 SQL Server Setup did not have the administrator permissions required to rename a file: e:SQLDatamssqlsystemresource1.ldf. To continue, verify that the file exists, and either grant administrator permissions to the account currently running Setup or log in with an administrator account. Then run SQL Server Setup again. 05/12/2008 09:22:33.678 MSP returned 1603: A fatal error occurred during installation. 05/12/2008 09:22:33.724 Registry: Opened registry key "SoftwarePoliciesMicrosoftWindowsInstaller"
I'm trying to install Microsoft SQL Server 2005 Express Edition (x86) on my laptop when a setup failure message would show up at the end. When I clicked for more details it has the followings:
Product Version 9.00.3042.00 Message Source setup.rll Message ID 50000 EvtType sharedsetupsharedsetupactions.cpp
And later when I tried to uninstall it from Add/Remove Program the screen would simply flash when I click but nothing happens.
Please let me know what do I need to install the piece correctly, thanks!
I successfully installed SQL Server 2005 SP1 on one PC. When I attempt to install it on a second PC, however, I get the following obscure error:
Unexpected Error Occurred The following unexpected error occurred:
That's right, there's nothing else listed, other an OK button. D'oh! When I press the OK button, the following error report dialog box appears:
Hotfix.exe A recently applied update, NULL, failed to install.
There are no pending updates that I'm aware of, as I just booted the PC. I sent the error report.
I notice on this particular PC that the SP1 install EXE is expanding/writing to an external SCSI drive; would that make a difference? I don't see a way to specify a different (i.e., internal ATA drive).
I am trying to install SQl Server 2005 SP2 but it was throwing an unexpected error when trying to install "setup support files".
O/s: Windows Server 2003 SP1
Product: SQL Server 2005 Standard Edition
Log file shows:
+++++++++++++++++++
=== Verbose logging started: 2/20/2007 16:05:42 Build type: SHIP UNICODE 3.01.4000.2435 Calling process: F:SQL2005sp2hotfix.exe === MSI (c) (74:68) [16:05:42:635]: Resetting cached policy values MSI (c) (74:68) [16:05:42:635]: Machine policy value 'Debug' is 0 MSI (c) (74:68) [16:05:42:635]: ******* RunEngine: ******* Product: C:Program FilesMicrosoft SQL Server90Setup BootstrapCacheSQLSupportx861033SqlSupport.msi ******* Action: ******* CommandLine: ********** MSI (c) (74:68) [16:05:42:635]: Client-side and UI is none or basic: Running entire install on the server. MSI (c) (74:68) [16:05:42:635]: Grabbed execution mutex. MSI (c) (74:68) [16:05:42:729]: Cloaking enabled. MSI (c) (74:68) [16:05:42:729]: Attempting to enable all disabled priveleges before calling Install on Server MSI (c) (74:68) [16:05:42:745]: Incrementing counter to disable shutdown. Counter after increment: 0 MSI (s) (20:70) [16:05:42:792]: Grabbed execution mutex. MSI (s) (20:68) [16:05:42:792]: Resetting cached policy values MSI (s) (20:68) [16:05:42:792]: Machine policy value 'Debug' is 0 MSI (s) (20:68) [16:05:42:792]: ******* RunEngine: ******* Product: C:Program FilesMicrosoft SQL Server90Setup BootstrapCacheSQLSupportx861033SqlSupport.msi ******* Action: ******* CommandLine: ********** MSI (s) (20:68) [16:05:42:792]: Machine policy value 'DisableUserInstalls' is 0 MSI (s) (20:68) [16:05:42:823]: File will have security applied from OpCode. MSI (s) (20:68) [16:05:42:901]: SOFTWARE RESTRICTION POLICY: Verifying package --> 'C:Program FilesMicrosoft SQL Server90Setup BootstrapCacheSQLSupportx861033SqlSupport.msi' against software restriction policy MSI (s) (20:68) [16:05:42:901]: SOFTWARE RESTRICTION POLICY: C:Program FilesMicrosoft SQL Server90Setup BootstrapCacheSQLSupportx861033SqlSupport.msi has a digital signature MSI (s) (20:68) [16:05:43:151]: SOFTWARE RESTRICTION POLICY: C:Program FilesMicrosoft SQL Server90Setup BootstrapCacheSQLSupportx861033SqlSupport.msi is permitted to run at the 'unrestricted' authorization level. MSI (s) (20:68) [16:05:43:151]: End dialog not enabled MSI (s) (20:68) [16:05:43:151]: Original package ==> C:Program FilesMicrosoft SQL Server90Setup BootstrapCacheSQLSupportx861033SqlSupport.msi MSI (s) (20:68) [16:05:43:151]: Package we're running from ==> C:WINDOWSInstaller1348fe1.msi MSI (s) (20:68) [16:05:43:151]: APPCOMPAT: looking for appcompat database entry with ProductCode '{53F5C3EE-05ED-4830-994B-50B2F0D50FCE}'. MSI (s) (20:68) [16:05:43:151]: APPCOMPAT: no matching ProductCode found in database. MSI (s) (20:68) [16:05:43:167]: MSCOREE not loaded loading copy from system32 MSI (s) (20:68) [16:05:43:182]: Opening existing patch 'C:WINDOWSInstaller1553df86.msp'. MSI (s) (20:68) [16:05:43:182]: Note: 1: 2203 2: C:WINDOWSInstaller1553df86.msp 3: -2147287038 MSI (s) (20:68) [16:05:43:182]: Couldn't find local patch 'C:WINDOWSInstaller1553df86.msp'. Looking for it at its source. MSI (s) (20:68) [16:05:43:182]: Resolving Patch source. MSI (s) (20:68) [16:05:43:182]: User policy value 'SearchOrder' is 'nmu' MSI (s) (20:68) [16:05:43:182]: User policy value 'DisableMedia' is 0 MSI (s) (20:68) [16:05:43:182]: Machine policy value 'AllowLockdownMedia' is 0 MSI (s) (20:68) [16:05:43:182]: SOURCEMGMT: Media enabled only if package is safe. MSI (s) (20:68) [16:05:43:182]: SOURCEMGMT: Looking for sourcelist for product {EE92F683-5F5C-4970-BB0B-9AC591B60268} MSI (s) (20:68) [16:05:43:182]: SOURCEMGMT: Adding {EE92F683-5F5C-4970-BB0B-9AC591B60268}; to potential sourcelist list (pcode;disk;relpath). MSI (s) (20:68) [16:05:43:182]: SOURCEMGMT: Now checking product {EE92F683-5F5C-4970-BB0B-9AC591B60268} MSI (s) (20:68) [16:05:43:182]: SOURCEMGMT: Media is enabled for product. MSI (s) (20:68) [16:05:43:182]: SOURCEMGMT: Attempting to use LastUsedSource from source list. MSI (s) (20:68) [16:05:43:182]: SOURCEMGMT: Trying source \TESTf$cff417a74df5a718124f2a95bdecdc32HotFixSqlSupportFiles. MSI (s) (20:68) [16:05:43:213]: Note: 1: 2203 2: \TESTf$cff417a74df5a718124f2a95bdecdc32HotFixSqlSupportFilesSqlSupport.msp 3: -2147287037 MSI (s) (20:68) [16:05:43:213]: SOURCEMGMT: Source is invalid due to missing/inaccessible package. MSI (s) (20:68) [16:05:43:213]: Note: 1: 1706 2: -2147483647 3: SqlSupport.msp MSI (s) (20:68) [16:05:43:213]: SOURCEMGMT: Processing net source list. MSI (s) (20:68) [16:05:43:213]: SOURCEMGMT: Trying source \TESTf$a81c0730a34f964148HotFixSqlSupportFiles. MSI (s) (20:68) [16:05:43:213]: Note: 1: 2203 2: \TESTf$a81c0730a34f964148HotFixSqlSupportFilesSqlSupport.msp 3: -2147287037 MSI (s) (20:68) [16:05:43:213]: SOURCEMGMT: Source is invalid due to missing/inaccessible package. MSI (s) (20:68) [16:05:43:213]: Note: 1: 1706 2: -2147483647 3: SqlSupport.msp MSI (s) (20:68) [16:05:43:213]: SOURCEMGMT: Processing media source list. MSI (s) (20:68) [16:05:44:245]: SOURCEMGMT: Resolved source to: 'SqlSupport.msp' MSI (s) (20:68) [16:06:14:619]: Note: 1: 1314 2: SqlSupport.msp MSI (s) (20:68) [16:06:14:619]: Unable to create a temp copy of patch 'SqlSupport.msp'. MSI (s) (20:68) [16:06:14:619]: Note: 1: 1708 MSI (s) (20:68) [16:06:14:619]: Note: 1: 2729 MSI (s) (20:68) [16:06:14:619]: Note: 1: 2729 MSI (s) (20:68) [16:06:14:619]: Product: Microsoft SQL Server Setup Support Files (English) -- Installation failed.
MSI (s) (20:68) [16:06:14:619]: MainEngineThread is returning 1635 This patch package could not be opened. Verify that the patch package exists and that you can access it, or contact the application vendor to verify that this is a valid Windows Installer patch package. C:Program FilesMicrosoft SQL Server90Setup BootstrapCacheSQLSupportx861033SqlSupport.msi MSI (c) (74:68) [16:06:14:729]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1 MSI (c) (74:68) [16:06:14:729]: MainEngineThread is returning 1635 === Verbose logging stopped: 2/20/2007 16:06:14 ===
I am running a named instance of SQL Server 2005 Enterprise Edition, side by side with named instance of SQL Server 2000 in Windows Server 2003. When I start the installation. I am unable to proceed from authentication stage.
The error description for Database Services and Reporting Services under both sa and windows authentication mode is: Encryption not supported on client Sqlcmd error: Microsoft SQL Native client: Client Unable to establish connection
In Service Manager, all SQL Server 2005 services are running with Logon as Administrator, and I am also able to connect to SSAS, SSRS, SSIS via Management studio both via Windows authentication and sa account information.
Would you please inform if I have to change any security settings before SP2 installation here.
How to add myself a Sql Server Administrator. The link in Surface Area Configuration to Add new Administrator doesn't work.
Hi, I've just tried to install SQL Server 2005 Standard and I'm getting an error that I can't find any information on. In the log, I find Error 29503. A message after it indicates that it couldn't start the server.
I can't install SQL 2005 Delveloper edition and show error with MSXML component
It shows these massage:
=== Verbose logging started: 6/11/2007 17:17:36 Build type: SHIP UNICODE 3.01.4000.4003 Calling process: C:Program FilesMicrosoft SQL Server90Setup Bootstrapsetup.exe === MSI (c) (A8:90) [17:17:36:545]: Resetting cached policy values MSI (c) (A8:90) [17:17:36:545]: Machine policy value 'Debug' is 0 MSI (c) (A8:90) [17:17:36:545]: ******* RunEngine: ******* Product: \inwa202746-1GSQL Server x86ServersSetupmsxml6.msi ******* Action: ******* CommandLine: ********** MSI (c) (A8:90) [17:17:36:545]: Client-side and UI is none or basic: Running entire install on the server. MSI (c) (A8:90) [17:17:36:545]: Grabbed execution mutex. MSI (c) (A8:90) [17:17:36:555]: Cloaking enabled. MSI (c) (A8:90) [17:17:36:555]: Attempting to enable all disabled priveleges before calling Install on Server MSI (c) (A8:90) [17:17:36:555]: Incrementing counter to disable shutdown. Counter after increment: 0 MSI (s) (30:AC) [17:17:36:575]: Grabbed execution mutex. MSI (s) (30:40) [17:17:36:575]: Resetting cached policy values MSI (s) (30:40) [17:17:36:575]: Machine policy value 'Debug' is 0 MSI (s) (30:40) [17:17:36:575]: ******* RunEngine: ******* Product: \inwa202746-1GSQL Server x86ServersSetupmsxml6.msi ******* Action: ******* CommandLine: ********** MSI (s) (30:40) [17:17:36:675]: Incrementing counter to disable shutdown. Counter after increment: 0 MSI (s) (30:40) [17:17:36:906]: Machine policy value 'DisableUserInstalls' is 0 MSI (s) (30:40) [17:17:37:176]: File will have security applied from OpCode. MSI (s) (30:40) [17:17:39:119]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1 MSI (s) (30:40) [17:17:39:269]: SOFTWARE RESTRICTION POLICY: Verifying package --> '\inwa202746-1GSQL Server x86ServersSetupmsxml6.msi' against software restriction policy MSI (s) (30:40) [17:17:39:269]: SOFTWARE RESTRICTION POLICY: \inwa202746-1GSQL Server x86ServersSetupmsxml6.msi has a digital signature MSI (s) (30:40) [17:17:41:702]: SOFTWARE RESTRICTION POLICY: \inwa202746-1GSQL Server x86ServersSetupmsxml6.msi is permitted to run at the 'unrestricted' authorization level. MSI (s) (30:40) [17:17:41:702]: End dialog not enabled MSI (s) (30:40) [17:17:41:702]: Original package ==> \inwa202746-1GSQL Server x86ServersSetupmsxml6.msi MSI (s) (30:40) [17:17:41:702]: Package we're running from ==> C:WINDOWSInstaller3afbb9.msi MSI (s) (30:40) [17:17:41:722]: APPCOMPAT: looking for appcompat database entry with ProductCode '{AEB9948B-4FF2-47C9-990E-47014492A0FE}'. MSI (s) (30:40) [17:17:41:722]: APPCOMPAT: no matching ProductCode found in database. MSI (s) (30:40) [17:17:41:722]: MSCOREE already loaded, using loaded copy MSI (s) (30:40) [17:17:41:732]: Machine policy value 'TransformsSecure' is 0 MSI (s) (30:40) [17:17:41:732]: User policy value 'TransformsAtSource' is 0 MSI (s) (30:40) [17:17:41:732]: Note: 1: 2262 2: MsiFileHash 3: -2147287038 MSI (s) (30:40) [17:17:41:732]: Machine policy value 'DisablePatch' is 0 MSI (s) (30:40) [17:17:41:732]: Machine policy value 'AllowLockdownPatch' is 0 MSI (s) (30:40) [17:17:41:732]: Machine policy value 'DisableLUAPatching' is 0 MSI (s) (30:40) [17:17:41:732]: Machine policy value 'DisableFlyWeightPatching' is 0 MSI (s) (30:40) [17:17:41:732]: APPCOMPAT: looking for appcompat database entry with ProductCode '{AEB9948B-4FF2-47C9-990E-47014492A0FE}'. MSI (s) (30:40) [17:17:41:732]: APPCOMPAT: no matching ProductCode found in database. MSI (s) (30:40) [17:17:41:732]: Transforms are not secure. MSI (s) (30:40) [17:17:41:732]: Command Line: STPSETUPTHREADID=3708 STPSETUPPROCESSID=424 EXTERNALCONTROL=1 ADDLOCAL=ALL SKIPPENDINGREBOOTCHECK=1 APPGUID={982DB00A-9C4E-436B-8707-18E113BAA44C} REBOOT=ReallySuppress CURRENTDIRECTORY=C:Program FilesMicrosoft SQL Server90Setup Bootstrap CLIENTUILEVEL=3 CLIENTPROCESSID=424 MSI (s) (30:40) [17:17:41:732]: PROPERTY CHANGE: Adding PackageCode property. Its value is '{A60D52F8-FAAB-4544-AF65-EAC1A22E5435}'. MSI (s) (30:40) [17:17:41:732]: Product Code passed to Engine.Initialize: '' MSI (s) (30:40) [17:17:41:732]: Product Code from property table before transforms: '{AEB9948B-4FF2-47C9-990E-47014492A0FE}' MSI (s) (30:40) [17:17:41:732]: Product Code from property table after transforms: '{AEB9948B-4FF2-47C9-990E-47014492A0FE}' MSI (s) (30:40) [17:17:41:732]: Product not registered: beginning first-time install MSI (s) (30:40) [17:17:41:732]: PROPERTY CHANGE: Adding ProductState property. Its value is '-1'. MSI (s) (30:40) [17:17:41:732]: Entering CMsiConfigurationManager:etLastUsedSource. MSI (s) (30:40) [17:17:41:763]: User policy value 'SearchOrder' is 'nmu' MSI (s) (30:40) [17:17:41:763]: Adding new sources is allowed. MSI (s) (30:40) [17:17:41:763]: PROPERTY CHANGE: Adding PackagecodeChanging property. Its value is '1'. MSI (s) (30:40) [17:17:41:763]: Package name extracted from package path: 'msxml6.msi' MSI (s) (30:40) [17:17:41:763]: Package to be registered: 'msxml6.msi' MSI (s) (30:40) [17:17:41:763]: Note: 1: 2262 2: AdminProperties 3: -2147287038 MSI (s) (30:40) [17:17:41:763]: Machine policy value 'DisableMsi' is 0 MSI (s) (30:40) [17:17:41:763]: Machine policy value 'AlwaysInstallElevated' is 0 MSI (s) (30:40) [17:17:41:763]: User policy value 'AlwaysInstallElevated' is 0 MSI (s) (30:40) [17:17:41:763]: Product installation will be elevated because user is admin and product is being installed per-machine. MSI (s) (30:40) [17:17:41:763]: Running product '{AEB9948B-4FF2-47C9-990E-47014492A0FE}' with elevated privileges: Product is assigned. MSI (s) (30:40) [17:17:41:763]: PROPERTY CHANGE: Adding STPSETUPTHREADID property. Its value is '3708'. MSI (s) (30:40) [17:17:41:763]: PROPERTY CHANGE: Adding STPSETUPPROCESSID property. Its value is '424'. MSI (s) (30:40) [17:17:41:763]: PROPERTY CHANGE: Adding EXTERNALCONTROL property. Its value is '1'. MSI (s) (30:40) [17:17:41:763]: PROPERTY CHANGE: Adding ADDLOCAL property. Its value is 'ALL'. MSI (s) (30:40) [17:17:41:763]: PROPERTY CHANGE: Adding SKIPPENDINGREBOOTCHECK property. Its value is '1'. MSI (s) (30:40) [17:17:41:763]: PROPERTY CHANGE: Adding APPGUID property. Its value is '{982DB00A-9C4E-436B-8707-18E113BAA44C}'. MSI (s) (30:40) [17:17:41:763]: PROPERTY CHANGE: Adding REBOOT property. Its value is 'ReallySuppress'. MSI (s) (30:40) [17:17:41:763]: PROPERTY CHANGE: Adding CURRENTDIRECTORY property. Its value is 'C:Program FilesMicrosoft SQL Server90Setup Bootstrap'. MSI (s) (30:40) [17:17:41:763]: PROPERTY CHANGE: Adding CLIENTUILEVEL property. Its value is '3'. MSI (s) (30:40) [17:17:41:763]: PROPERTY CHANGE: Adding CLIENTPROCESSID property. Its value is '424'. MSI (s) (30:40) [17:17:41:763]: TRANSFORMS property is now: MSI (s) (30:40) [17:17:41:763]: PROPERTY CHANGE: Adding VersionDatabase property. Its value is '300'. MSI (s) (30:40) [17:17:41:773]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAdminApplication Data MSI (s) (30:40) [17:17:41:773]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAdminFavorites MSI (s) (30:40) [17:17:41:773]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAdminNetHood MSI (s) (30:40) [17:17:41:773]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAdminMy Documents MSI (s) (30:40) [17:17:41:773]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAdminPrintHood MSI (s) (30:40) [17:17:41:773]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAdminRecent MSI (s) (30:40) [17:17:41:783]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAdminSendTo MSI (s) (30:40) [17:17:41:783]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAdminTemplates MSI (s) (30:40) [17:17:41:783]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAll UsersApplication Data MSI (s) (30:40) [17:17:41:783]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAdminLocal SettingsApplication Data MSI (s) (30:40) [17:17:41:783]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAdminMy DocumentsMy Pictures MSI (s) (30:40) [17:17:41:783]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAll UsersStart MenuProgramsAdministrative Tools MSI (s) (30:40) [17:17:41:783]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAll UsersStart MenuProgramsStartup MSI (s) (30:40) [17:17:41:793]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAll UsersStart MenuPrograms MSI (s) (30:40) [17:17:41:793]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAll UsersStart Menu MSI (s) (30:40) [17:17:41:793]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAll UsersDesktop MSI (s) (30:40) [17:17:41:793]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAdminStart MenuProgramsAdministrative Tools MSI (s) (30:40) [17:17:41:793]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAdminStart MenuProgramsStartup MSI (s) (30:40) [17:17:41:793]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAdminStart MenuPrograms MSI (s) (30:40) [17:17:41:803]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAdminStart Menu MSI (s) (30:40) [17:17:41:803]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAdminDesktop MSI (s) (30:40) [17:17:41:803]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAll UsersTemplates MSI (s) (30:40) [17:17:41:803]: SHELL32:HGetFolderPath returned: C:WINDOWSFonts MSI (s) (30:40) [17:17:41:803]: Note: 1: 2898 2: MS Sans Serif 3: MS Sans Serif 4: 0 5: 16 MSI (s) (30:40) [17:17:41:803]: PROPERTY CHANGE: Adding Privileged property. Its value is '1'. MSI (s) (30:40) [17:17:41:803]: Note: 1: 1402 2: HKEY_CURRENT_USERSoftwareMicrosoftMS Setup (ACME)User Info 3: 2 MSI (s) (30:40) [17:17:41:803]: PROPERTY CHANGE: Adding USERNAME property. Its value is 'Exact'. MSI (s) (30:40) [17:17:41:803]: Note: 1: 1402 2: HKEY_CURRENT_USERSoftwareMicrosoftMS Setup (ACME)User Info 3: 2 MSI (s) (30:40) [17:17:41:803]: PROPERTY CHANGE: Adding COMPANYNAME property. Its value is 'Exact Software'. MSI (s) (30:40) [17:17:41:803]: PROPERTY CHANGE: Adding DATABASE property. Its value is 'C:WINDOWSInstaller3afbb9.msi'. MSI (s) (30:40) [17:17:41:803]: PROPERTY CHANGE: Adding OriginalDatabase property. Its value is '\inwa202746-1GSQL Server x86ServersSetupmsxml6.msi'. MSI (s) (30:40) [17:17:41:803]: Note: 1: 2205 2: 3: PatchPackage MSI (s) (30:40) [17:17:41:803]: Machine policy value 'DisableRollback' is 0 MSI (s) (30:40) [17:17:41:803]: User policy value 'DisableRollback' is 0 MSI (s) (30:40) [17:17:41:803]: PROPERTY CHANGE: Adding UILevel property. Its value is '2'. === Logging started: 6/11/2007 17:17:41 === MSI (s) (30:40) [17:17:41:803]: PROPERTY CHANGE: Adding Preselected property. Its value is '1'. MSI (s) (30:40) [17:17:41:803]: PROPERTY CHANGE: Adding ACTION property. Its value is 'INSTALL'. MSI (s) (30:40) [17:17:41:803]: Doing action: INSTALL MSI (s) (30:40) [17:17:41:803]: Running ExecuteSequence MSI (s) (30:40) [17:17:41:803]: Skipping action: SkipInstallCA (condition is false) MSI (s) (30:40) [17:17:41:803]: Doing action: LaunchConditions Action start 17:17:41: INSTALL. Action start 17:17:41: LaunchConditions. MSI (s) (30:40) [17:17:41:803]: Doing action: FindRelatedProducts Action ended 17:17:41: LaunchConditions. Return value 1. Action start 17:17:41: FindRelatedProducts. MSI (s) (30:40) [17:17:41:813]: PROPERTY CHANGE: Adding NEWERFOUND.72DE5BCD_5CB0_4335_B118_AB4C4DA70AE1 property. Its value is '{A43BF6A5-D5F0-4AAA-BF41-65995063EC44}'. MSI (s) (30:40) [17:17:41:813]: Skipping action: CA_SetRefCountUpgradeFlag (condition is false) MSI (s) (30:40) [17:17:41:813]: Doing action: CA_SetRefCountNewerFoundFlag Action ended 17:17:41: FindRelatedProducts. Return value 1. MSI (s) (30:40) [17:17:41:813]: PROPERTY CHANGE: Adding NEWERFOUND999893F976BBB4A4DAD8F62CFA4D7C55 property. Its value is '1'. Action start 17:17:41: CA_SetRefCountNewerFoundFlag. MSI (s) (30:40) [17:17:41:813]: Doing action: IsPendingRebootKey Action ended 17:17:41: CA_SetRefCountNewerFoundFlag. Return value 1. MSI (s) (30:F8) [17:17:41:813]: Invoking remote custom action. DLL: C:WINDOWSInstallerMSI68.tmp, Entrypoint: IsPendingReboot MSI (s) (30:1C) [17:17:41:813]: Generating random cookie. MSI (s) (30:1C) [17:17:41:823]: Created Custom Action Server with PID 1832 (0x728). MSI (s) (304) [17:17:41:873]: Running as a service. MSI (s) (304) [17:17:41:873]: Hello, I'm your 32bit Impersonated custom action server. Action start 17:17:41: IsPendingRebootKey. No PendingFileRenameOperations MSI (s) (30:40) [17:17:41:973]: Skipping action: CA_ErrorDifferentLang (condition is false) MSI (s) (30:40) [17:17:41:973]: Skipping action: SetWOW (condition is false) MSI (s) (30:40) [17:17:41:973]: Skipping action: SetWOWAppendCustomPath (condition is false) MSI (s) (30:40) [17:17:41:973]: Skipping action: SetWOWINSTALLSQLSHAREDDIR_CUSTOMPATH (condition is false) MSI (s) (30:40) [17:17:41:973]: Skipping action: SetWOWINSTALLSQLSHAREDDIR_CUSTOMPATH_ADD (condition is false) MSI (s) (30:40) [17:17:41:973]: Doing action: Sqlmsirc_ValidateAppGuid_NewerFound.8AC30717_CC63_4611_9BB6_8CBCA668674D Action ended 17:17:41: IsPendingRebootKey. Return value 1. MSI (s) (30:50) [17:17:41:983]: Invoking remote custom action. DLL: C:WINDOWSInstallerMSI69.tmp, Entrypoint: Sqlmsirc_ValidateAppGuid Action start 17:17:41: Sqlmsirc_ValidateAppGuid_NewerFound.8AC30717_CC63_4611_9BB6_8CBCA668674D. <Func Name='Sqlmsirc_ValidateAppGuid'> <EndFunc Name='Sqlmsirc_ValidateAppGuid' Return='0' GetLastError='0'> MSI (s) (30:40) [17:17:42:003]: Doing action: Sqlmsirc_RefCountAppGuid_NewerFound.8AC30717_CC63_4611_9BB6_8CBCA668674D Action ended 17:17:42: Sqlmsirc_ValidateAppGuid_NewerFound.8AC30717_CC63_4611_9BB6_8CBCA668674D. Return value 1. MSI (s) (30:EC) [17:17:42:013]: Invoking remote custom action. DLL: C:WINDOWSInstallerMSI6A.tmp, Entrypoint: Sqlmsirc_RefCountAppGuid Action start 17:17:42: Sqlmsirc_RefCountAppGuid_NewerFound.8AC30717_CC63_4611_9BB6_8CBCA668674D. <Func Name='Sqlmsirc_RefCountAppGuid'> <EndFunc Name='Sqlmsirc_RefCountAppGuid' Return='2' GetLastError='0'> Action ended 17:17:42: Sqlmsirc_RefCountAppGuid_NewerFound.8AC30717_CC63_4611_9BB6_8CBCA668674D. Return value 3. Action ended 17:17:42: INSTALL. Return value 3. Property(S): ProductCode = {AEB9948B-4FF2-47C9-990E-47014492A0FE} Property(S): Manufacturer = Microsoft Corporation Property(S): ProductVersion = 6.00.3883.8 Property(S): ProductLanguage = 1033 Property(S): UpgradeCode = {1B117BA7-5BC1-419E-820E-7D4F3F412C7B} Property(S): NEWERFOUND999893F976BBB4A4DAD8F62CFA4D7C55 = 1 Property(S): ARPPRODUCTICON = ARPIco Property(S): PIDTemplate = 53934<````=````=````=````=`````>@@@@@ Property(S): PROMPTROLLBACKCOST = P Property(S): DiskPrompt = [1] Property(S): INSTALLLEVEL = 100 Property(S): ALLUSERS = 1 Property(S): InstallMode = Typical Property(S): ErrorIcon = ErrorIco Property(S): SuccessIcon = SuccessIco Property(S): WarningIcon = WarningIco Property(S): LicenseIcon = LicenseIco Property(S): SetupIcon = SetupIco Property(S): CompleteIcon = CompleteIco Property(S): CustomIcon = CustomIco Property(S): RepairIcon = RepairIco Property(S): RemoveIcon = RemoveIco Property(S): ModifyIcon = ModifyIco Property(S): NewIcon = NewIco Property(S): UpIcon = UpIco Property(S): DialogBanner = BannerBmp Property(S): WelcomeBmp = WelcomeBmp Property(S): ApplicationUsers = AllUsers Property(S): Details = 0 Property(S): AgreeToLicense = No Property(S): _IsMaintenance = Reinstall Property(S): _IsMaintenance2 = Modify Property(S): ReinstallModeText = omus Property(S): Display_IsBitmapDlg = 1 Property(S): Interrupted = 0 Property(S): ProductID = none Property(S): ISENABLEDWUSFINISHDIALOG = 1 Property(S): SQLServerText1 = 0 Property(S): SQLServerVersionText1 = 0 Property(S): SQLServerVersionText2 = 0 Property(S): SQLServerVersionText3 = 0 Property(S): CA_ERRORCOUNT = 0 Property(S): CA_WARNINGCOUNT = 0 Property(S): CA_SUCCESSCOUNT = 0 Property(S): MINIMUMOS = true Property(S): UI_SHOWCOPYRIGHT = yes Property(S): ShowUserRegistrationDlg = 1 Property(S): ErrorDialog = ErrorDlg Property(S): DefaultUIFont = Tahoma8 Property(S): NEWERFOUND.72DE5BCD_5CB0_4335_B118_AB4C4DA70AE1 = {A43BF6A5-D5F0-4AAA-BF41-65995063EC44} Property(S): VersionNT = 501 Property(S): ARPHELPLINK = http://go.microsoft.com/fwlink/?LinkId=52156 Property(S): SecureCustomProperties = NEWERFOUND.72DE5BCD_5CB0_4335_B118_AB4C4DA70AE1;OLDERFOUND.72DE5BCD_5CB0_4335_B118_AB4C4DA70AE1;OLDERFOUND2.72DE5BCD_5CB0_4335_B118_AB4C4DA70AE1 Property(S): DesktopFolder = C:Documents and SettingsAll UsersDesktop Property(S): ButtonTextStyle = {ButtonTextStyle} Property(S): DlgTextStyle = {DlgTextStyle} Property(S): DlgTextStyleB = {DlgTextStyleB} Property(S): DlgTitleStyle = {DlgTitleStyle} Property(S): DlgTitleStyleB = {DlgTitleStyleB} Property(S): FixedStyle = {FixedStyle} Property(S): COMPANYNAME = Exact Software Property(S): USERNAME = Exact Property(S): DialogTitleSetup = Setup Property(S): DialogTitlePatch = Patch Property(S): DialogTitleUpgrade = Upgrade Property(S): Text_ArrowLeft = < Property(S): Text_ArrowRight = > Property(S): ButtonText_Next = Next Property(S): ButtonText_Next_Hot = &Next Property(S): ButtonText_Cancel = Cancel Property(S): ButtonText_Cancel_Hot = &Cancel Property(S): ButtonText_Back = Back Property(S): ButtonText_Back_Hot = &Back Property(S): ButtonText_Finish = Finish Property(S): ButtonText_Finish_Hot = &Finish Property(S): ButtonText_Update = Update > Property(S): ButtonText_Update_Hot = &Update > Property(S): ButtonText_Ok = OK Property(S): ButtonText_Ok_Hot = &OK Property(S): ButtonText_Yes = Yes Property(S): ButtonText_Yes_Hot = &Yes Property(S): ButtonText_No = No Property(S): ButtonText_No_Hot = &No Property(S): ButtonText_Abort = Abort Property(S): ButtonText_Abort_Hot = &Abort Property(S): ButtonText_Ignore = Ignore Property(S): ButtonText_Ignore_Hot = &Ignore Property(S): ButtonText_Retry = Retry Property(S): ButtonText_Retry_Hot = &Retry Property(S): ButtonText_Change = Change... Property(S): ButtonText_Change_Hot = &Change... Property(S): ButtonText_Help = Help Property(S): ButtonText_Help_Hot = &Help Property(S): ButtonText_Install = Install Property(S): ButtonText_Install_Hot = &Install Property(S): ButtonText_Exit = Exit Property(S): ButtonText_Exit_Hot = &Exit Property(S): ButtonText_Remove = Remove Property(S): ButtonText_Remove_Hot = &Remove Property(S): ButtonText_Space = Space Property(S): ButtonText_Space_Hot = &Space Property(S): ButtonText_Browse = Browse... Property(S): ButtonText_Browse_Hot = Bro&wse... Property(S): ButtonText_DiskCost = Disk Cost... Property(S): ButtonText_DiskCost_Hot = &Disk Cost... Property(S): LabelText_Status = Status Property(S): LabelText_SerialNumber = &Serial Number: Property(S): LabelText_UserName = &User Name Property(S): LabelText_PersonName = Name Property(S): LabelText_PersonOrganization = Company Property(S): LabelText_InstallTo = Install to Property(S): LabelText_Modify = &Modify Property(S): LabelText_Repair = Re&pair Property(S): LabelText_Remove = &Remove Property(S): LabelText_Complete = &Complete Property(S): LabelText_Custom = Cu&stom Property(S): LabelText_NetworkLocation = &Network location: Property(S): LabelText_LookIn = &Look in Property(S): LabelText_FolderName = &Folder name Property(S): LabelText_FeatureDescription = Feature description Property(S): LabelText_CopyFilesFrom = Copy Files from Property(S): LabelText_InstallFor = Install this application for Property(S): HeadText_AdminWelcome = Welcome to the Install Wizard for Property(S): HeadText_InstallWelcome = Welcome to the Install Wizard for Property(S): HeadText_WelcomePatch = Welcome to the Patch for Property(S): HeadText_SetupWelcome = Welcome to the Property(S): HeadText_SetupWelcome2 = Setup Property(S): HeadText_ResumeInstall = Resuming the Install Wizard for Property(S): HeadText_SetupInterrupted = Setup Interrupted Property(S): HeadText_LicenseAgreement = License Agreement Property(S): HeadText_FeatureSelection = Feature Selection Property(S): HeadText_NetworkLocation = Network Location Property(S): HeadText_ProgramMaintenance = Program Maintenance Property(S): HeadText_DiskSpaceRequirements = Disk Space Requirements Property(S): HeadText_FilesInUse = Files in Use Property(S): HeadText_DatabaseFolder = Database Folder Property(S): HeadText_RegistrationInformation = Registration Information Property(S): HeadText_CompletingSetup = Completing the Property(S): HeadText_CompletingSetup2 = Setup Property(S): HeadText_InstallingProduct = Installing Property(S): HeadText_UninstallProduct = Uninstalling Property(S): HeadText_ChangeDestinationFolder = Change Current Destination Folder Property(S): HeadText_ReadyInstall = Ready to Install the Program Property(S): HeadText_ReadyRepair = Ready to Repair the Program Property(S): HeadText_ReadyModify = Ready to Modify the Program Property(S): HeadText_RemoveProgram = Remove the Program Property(S): HeadText_OutOfDiskSpace = Out of Disk Space Property(S): DescText_FilesInUse = Some files that need to be updated are currently in use. Property(S): DescText_RegistrationInformation = The following information will personalize your installation. Property(S): DescText_ServerImage = Setup will create a server image of Property(S): DescText_ServerImage2 = at a specified network location. To continue, click Next. Property(S): DescText_InstallModifyRemove = Setup helps you install, modify or remove Property(S): DescText_InstallModifyRemove2 = . To continue, click Next. Property(S): DescText_PatchInstall = The Install Wizard will install the Patch for Property(S): DescText_PatchInstall2 = on your computer. To continue, click Update. Property(S): DescText_WizardComplete = The Install Wizard will complete the installation of Property(S): DescText_WizardComplete2 = on your computer. To continue, click Next. Property(S): DescText_CompleteSuspended = The Install Wizard will complete the suspended installation of Property(S): DescText_CompleteSuspended2 = on your computer. To continue, click Next. Property(S): DescText_SuccessfulInstallation = Setup has installed Property(S): DescText_SuccessfulInstallation2 = successfully. Click Finish to exit. Property(S): DescText_SuccessfulRemove = Setup has removed Property(S): DescText_SuccessfulRemove2 = successfully. Click Finish to exit. Property(S): DescText_SuccessfulRepair = Setup has repaired Property(S): DescText_SuccessfulRepair2 = successfully. Click Finish to exit. Property(S): DescText_SuccessfulModify = Setup has modified Property(S): DescText_SuccessfulModify2 = successfully. Click Finish to exit. Property(S): DescText_SetupInterrupted = Setup was interrupted before Property(S): DescText_SetupInterrupted2 = could be completely installed. Property(S): DescText_PreparingSetup = Setup is preparing the Install Wizard which will guide you through the program setup process. Please wait. Property(S): DescText_FeatureSelection = Select the program features you want installed. Property(S): DescText_ProgramFeaturesInstall = The program features you selected are being installed. Property(S): DescText_ProgramFeaturesUninstall = The program features you selected are being uninstalled. Property(S): DescText_ReadLicense = Please read the following license agreement carefully. Property(S): DescText_SpecifyNetworkLocation = Specify a network location for the server image of the product. Property(S): DescText_BrowseDestination = Browse to the destination folder. Property(S): DescText_ModifyRepairRemove = Repair or remove the program. Property(S): DescText_ReadyInstallation = Setup is ready to begin installation. Property(S): DescText_ChosenRemove = You have chosen to remove the program from your system. Property(S): DescText_DiskSpaceRequirements = The disk space required for the installation of the selected features. Property(S): DescText_DiskExceedsAvailable = Disk space required for the installation exceeds available disk space. Property(S): Text_ReRunSetup = Your system has not been modified. To complete installation at another time, please run setup again. Property(S): Text_FinishExit = Click Finish to exit Setup. Property(S): Text_RestoreState = You can either keep any existing installed elements on your system to continue this installation at a later time or you can restore your system to its original state prior to the installation. Property(S): Text_RestoreClick = Click Restore or Continue Later to exit Setup. Property(S): Text_InstallWait = Please wait while the Install Wizard installs Property(S): Text_InstallWait2 = . This may take several minutes. Property(S): Text_UninstallWaitText = Please wait while the Install Wizard uninstalls Property(S): Text_UninstallWaitText2 = . This may take several minutes. Property(S): Text_UninstallWait = Please wait while the Install Wizard uninstalls Property(S): Text_UninstallWait2 = . This may take several minutes. Property(S): Text_ProgressDone = Progress done Property(S): Text_Copyright = WARNING: This program is protected by copyright law and international treaties. Property(S): Text_BeginInstallation = Click Install to begin the installation. Property(S): Text_ReviewChange = If you want to review or change any of your installation settings, click Back. Click Cancel to exit Setup. Property(S): Text_AlterFeatureInstall = Click an icon in the following list to change how a feature is installed. Property(S): Text_ConfirmExit = The installation is not yet complete. Are you sure you want to exit? Property(S): Text_FeatureSelectionDescription = This feature requires 4 MB on your hard drive. Property(S): Text_EnterNetworkLocation = Enter the network location or click Change to browse to a location. Click Install to create a server image of Property(S): Text_EnterNetworkLocation2 = at the specified network location or click Cancel to exit Setup. Property(S): Text_SelectDifferentDrive = The highlighted volumes do not have enough disk space available for the currently selected features. You can remove files from the highlighted volumes, choose to install less features onto local drives, or select different destination drives. Property(S): Text_RepairInstallationErrors = Repair installation errors in the program. This option fixes missing or corrupt files, shortcuts, and registry entries. Property(S): Text_RemoveFromComputer = Remove Property(S): Text_RemoveFromComputer2 = from your computer. Property(S): Text_UsingFilesRetry = The following applications are using files that need to be updated by this setup. Close these applications and click Retry to continue. Property(S): Text_ClickRemove = Click Remove to remove Property(S): Text_ClickRemove2 = from your computer. After removal, this program will no longer be available for use. Property(S): Text_ReviewChangeBack = If you want to review or change any settings, click Back. Property(S): Text_AllUsers = &Anyone who uses this computer (all users) Property(S): Text_OnlyMe = Only for &me ([USERNAME]) Property(S): Text_NotAcceptTerms = I &do not accept the terms in the license agreement Property(S): Text_AcceptTerms = I &accept the terms in the license agreement Property(S): Text_RegInfoNameAndOrg = Enter your name and the name of your organization in the fields below. Property(S): Text_RegInfoOrg = Enter the name of your organization in the field below. Property(S): Upgrade_Confirmation = A lower version of this product has been detected on your system. Would you like to upgrade your existing installation? Property(S): AdminMessage = Setup requires user to be in the administrator group in order to continue the installation process. Setup is aborting as the current user is not in the administrator group. Property(S): SupportedOSMessage = Installation of this product failed because it is not supported on this operating system. For information on supported configurations, see the product documentation. Property(S): ShortCutText = MSXML 6.0 Property(S): DialogTitle = MSXML 6.0 Parser Setup Property(S): ProductName = MSXML 6.0 Parser Property(S): ShortName = MSXML 6.0 Parser Property(S): WrongPackage = This MSXML6.0 package is not supported on the current processor type. Property(S): DialogPatchTitle = MSXML 6.0 Parser Patch Property(S): SystemFolder = C:WINDOWSsystem32 Property(S): WdSfpCaMainModId.41646F16_4E6C_4E96_BF1B_772105414B9D = 86F857F6_A743_463D_B2FE_98CB5F727E09 Property(S): AppGuidRegKey = Wdsfpca_Uninstall_RegKey.86F857F6_A743_463D_B2FE_98CB5F727E09 Property(S): PackageCode = {A60D52F8-FAAB-4544-AF65-EAC1A22E5435} Property(S): ProductState = -1 Property(S): PackagecodeChanging = 1 Property(S): STPSETUPTHREADID = 3708 Property(S): STPSETUPPROCESSID = 424 Property(S): EXTERNALCONTROL = 1 Property(S): ADDLOCAL = ALL Property(S): SKIPPENDINGREBOOTCHECK = 1 Property(S): APPGUID = {982DB00A-9C4E-436B-8707-18E113BAA44C} Property(S): REBOOT = ReallySuppress Property(S): CURRENTDIRECTORY = C:Program FilesMicrosoft SQL Server90Setup Bootstrap Property(S): CLIENTUILEVEL = 3 Property(S): CLIENTPROCESSID = 424 Property(S): VersionDatabase = 300 Property(S): VersionMsi = 3.01 Property(S): WindowsBuild = 2600 Property(S): ServicePackLevel = 2 Property(S): ServicePackLevelMinor = 0 Property(S): MsiNTProductType = 1 Property(S): WindowsFolder = C:WINDOWS Property(S): WindowsVolume = C: Property(S): System16Folder = C:WINDOWSsystem Property(S): RemoteAdminTS = 1 Property(S): TempFolder = C:DOCUME~1AdminLOCALS~1Temp Property(S): ProgramFilesFolder = C:Program Files Property(S): CommonFilesFolder = C:Program FilesCommon Files Property(S): AppDataFolder = C:Documents and SettingsAdminApplication Data Property(S): FavoritesFolder = C:Documents and SettingsAdminFavorites Property(S): NetHoodFolder = C:Documents and SettingsAdminNetHood Property(S): PersonalFolder = C:Documents and SettingsAdminMy Documents Property(S): PrintHoodFolder = C:Documents and SettingsAdminPrintHood Property(S): RecentFolder = C:Documents and SettingsAdminRecent Property(S): SendToFolder = C:Documents and SettingsAdminSendTo Property(S): TemplateFolder = C:Documents and SettingsAll UsersTemplates Property(S): CommonAppDataFolder = C:Documents and SettingsAll UsersApplication Data Property(S): LocalAppDataFolder = C:Documents and SettingsAdminLocal SettingsApplication Data Property(S): MyPicturesFolder = C:Documents and SettingsAdminMy DocumentsMy Pictures Property(S): AdminToolsFolder = C:Documents and SettingsAll UsersStart MenuProgramsAdministrative Tools Property(S): StartupFolder = C:Documents and SettingsAll UsersStart MenuProgramsStartup Property(S): ProgramMenuFolder = C:Documents and SettingsAll UsersStart MenuPrograms Property(S): StartMenuFolder = C:Documents and SettingsAll UsersStart Menu Property(S): FontsFolder = C:WINDOWSFonts Property(S): GPTSupport = 1 Property(S): OLEAdvtSupport = 1 Property(S): ShellAdvtSupport = 1 Property(S): Intel = 6 Property(S): PhysicalMemory = 1023 Property(S): VirtualMemory = 2183 Property(S): AdminUser = 1 Property(S): LogonUser = Administrator Property(S): UserSID = S-1-5-21-842925246-1580818891-1957994488-500 Property(S): UserLanguageID = 1033 Property(S): ComputerName = CHUN107907-1 Property(S): SystemLanguageID = 1054 Property(S): ScreenX = 1024 Property(S): ScreenY = 768 Property(S): CaptionHeight = 25 Property(S): BorderTop = 1 Property(S): BorderSide = 1 Property(S): TextHeight = 16 Property(S): ColorBits = 32 Property(S): TTCSupport = 1 Property(S): Time = 17:17:42 Property(S): Date = 6/11/2007 Property(S): MsiNetAssemblySupport = 2.0.50727.42 Property(S): MsiWin32AssemblySupport = 5.1.2600.3019 Property(S): RedirectedDllSupport = 2 Property(S): Privileged = 1 Property(S): DATABASE = C:WINDOWSInstaller3afbb9.msi Property(S): OriginalDatabase = \inwa202746-1GSQL Server x86ServersSetupmsxml6.msi Property(S): UILevel = 2 Property(S): Preselected = 1 Property(S): ACTION = INSTALL MSI (s) (30:40) [17:17:42:093]: Note: 1: 1708 MSI (s) (30:40) [17:17:42:093]: Product: MSXML 6.0 Parser -- Installation failed.
MSI (s) (30:40) [17:17:42:093]: Cleaning up uninstalled install packages, if any exist MSI (s) (30:40) [17:17:42:093]: MainEngineThread is returning 1603 MSI (s) (30:AC) [17:17:42:193]: Destroying RemoteAPI object. MSI (s) (30:1C) [17:17:42:193]: Custom Action Manager thread ending. === Logging stopped: 6/11/2007 17:17:42 === MSI (c) (A8:90) [17:17:42:193]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1 MSI (c) (A8:90) [17:17:42:193]: MainEngineThread is returning 1603 === Verbose logging stopped: 6/11/2007 17:17:42 ===
When I tried to SQL Server 2005 (Standard) to two-node Windows 2003 servers, the Remote Setup task on the 2nd node hang. Here is the SQL Setup log. Please help figure out the cause of the problem. Thanks in advance.
Microsoft SQL Server 2005 Setup beginning at Tue Apr 24 16:17:14 2007 Process ID : 2864 \irv144C$SQL2005Std-x64disc1setup.exe Version: 2005.90.1399.0 Running: LoadResourcesAction at: 2007/3/24 16:17:14 Complete: LoadResourcesAction at: 2007/3/24 16:17:14, returned true Running: ParseBootstrapOptionsAction at: 2007/3/24 16:17:14 Loaded DLL:\irv144C$SQL2005Std-x64disc1xmlrw.dll Version:2.0.3604.0 Complete: ParseBootstrapOptionsAction at: 2007/3/24 16:17:14, 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:rotectData 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", "", "2864"} 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: 2007/3/24 16:17:14 Complete: ValidateWinNTAction at: 2007/3/24 16:17:14, returned true Running: ValidateMinOSAction at: 2007/3/24 16:17:14 Complete: ValidateMinOSAction at: 2007/3/24 16:17:14, returned true Running: PerformSCCAction at: 2007/3/24 16:17:14 Complete: PerformSCCAction at: 2007/3/24 16:17:14, returned true Running: ActivateLoggingAction at: 2007/3/24 16:17:14 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" 0000000000EDAF90Unable 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
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.
We are running a test upgrade form sql 2000 standard edition 32 bit to sql 2005 developer edition 32bit. Followed through all the steps and specified the account(SA priveleges and currently used by the 2000 version) and is the local admin on the box for the services and the setup seemed to move fine, except for when it got to the point of installing database services - This is the error message that I got:
MSSQLServer could not be started. Verify you have sufficient priveleges to start system services. The was no choice but to hit cancel and then the set up progressed with a final message of 'SEtup failed'.
Here is a portion of the error log: Attempting to recover in-doubt distributed transactions involving Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required. Database Mirroring Transport is disabled in the endpoint configuration. Starting up database 'master'. Converting database 'master' from version 589 to the current version 611. Database 'master' running the upgrade step from version 589 to version 590. Error: 946, Severity: 14, State: 1. Cannot open database 'master' version 589. Upgrade the database to the latest version. System Task Aggregate global counters produced an error that was not handled. Major: 9, Minor: 46, Severity:14, State:1 Error: 928, Severity: 20, State: 1. During upgrade, database raised exception 15151, severity 16, state 1, address 01C4C50B. Use the exception number to determine the cause. Error: 15151, Severity: 16, State: 1. Cannot find the endpoint 'TSQL Local Machine', because it does not exist or you do not have permission.
