Upgrade fails to 2008 from 2000

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SQL Server Administration (2008)

Upgrade fails to 2008 from 2000

Author

Topic

SkotCollinz
Starting Member

8 Posts

Posted - 2009-07-20 : 06:23:14

Hi All,

After running upgrade advisor and fixing 'Before upgrade' issues, the upgrade still fails. I'm primarily a developer, so the SQL logs mean very little to me. If someone could point me in the right direction that'd be fantastic. I'll post the detail of the summary.txt file, i think the details.txt is going to be too long to post. I can email if needed.

Thanks in advance

Summary.txt:

Overall summary:
Final result: SQL Server upgrade failed. To continue, investigate the reason for the failure, correct the problem, and then repair your installation.
Exit code (Decimal): -2068643839
Exit facility code: 1203
Exit error code: 1
Exit message: SQL Server upgrade failed. To continue, investigate the reason for the failure, correct the problem, and then repair your installation.
Start time: 2009-07-16 13:49:08
End time: 2009-07-16 14:07:06
Requested action: Upgrade
Log with failure: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20090716_134747\Detail.txt
Exception help link: http%3a%2f%2fgo.microsoft.com%2ffwlink%3fLinkId%3d20476%26ProdName%3dMicrosoft%2bSQL%2bServer%26EvtSrc%3dsetup.rll%26EvtID%3d50000%26ProdVer%3d10.0.1600.22%26EvtType%3d0xE53883A0%400xBE03358B%401306%4024

Machine Properties:
Machine name: SQL2008-TEST
Machine processor count: 1
OS version: Windows Server 2003
OS service pack: Service Pack 2
OS region: United Kingdom
OS language: English (United States)
OS architecture: x86
Process architecture: 32 Bit
OS clustered: No

Product features discovered:
Product Instance Instance ID Feature Language Edition Version Clustered
Sql Server 2000 MSSQLSERVER SQL Server 1033 Enterprise Edition 8.4.2039 No
Sql Server 2000 MSSQLSERVER Replication Support 1033 Enterprise Edition 8.4.2039 No
Sql Server 2000 MSSQLSERVER Debug Symbols 1033 Enterprise Edition 8.4.2039 No
Sql Server 2000 MSSQLSERVER Performance Counters 1033 Enterprise Edition 8.4.2039 No
Sql Server 2000 Enterprise Manager Tools 8.00.194 No
Sql Server 2000 Profiler Tools 8.00.194 No
Sql Server 2000 Query Analyzer Tools 8.00.194 No
Sql Server 2000 DTC Client Support Tools 8.00.194 No
Sql Server 2000 Conflict Viewer Tools 8.00.194 No
Sql Server 2000 Client Connectivity Tools 8.00.194 No
Sql Server 2000 Books Online On Disk Tools 8.00.194 No
Sql Server 2000 Debugger Interface Tools 8.00.194 No
Sql Server 2000 DTS Tools 8.00.194 No

Package properties:
Description: SQL Server Database Services 2008
SQLProductFamilyCode: {628F8F38-600E-493D-9946-F4178F20A8A9}
ProductName: SQL2008
Type: RTM
Version: 10
SPLevel: 0
Installation location: Y:\x86\setup Installation edition: ENTERPRISE

User Input Settings:
ACTION: Upgrade
AGTDOMAINGROUP: <empty>
BROWSERSVCSTARTUPTYPE: Automatic
CONFIGURATIONFILE: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20090716_134747\ConfigurationFile.ini
ERRORREPORTING: False
FAILOVERCLUSTERROLLOWNERSHIP: 2
FTSVCACCOUNT: <empty>
FTSVCPASSWORD: *****
FTUPGRADEOPTION: Import
HELP: False
INDICATEPROGRESS: False
INSTANCEID: MSSQLSERVER
INSTANCENAME: MSSQLSERVER
ISSVCACCOUNT: NT AUTHORITY\NetworkService
ISSVCPASSWORD: *****
ISSVCSTARTUPTYPE: Automatic
MEDIASOURCE: Y: PID: *****
QUIET: False
QUIETSIMPLE: False
RSCATALOGSERVERINSTANCENAME: Unknown
RSUPGRADEDATABASEACCOUNT:
RSUPGRADEPASSWORD: *****
SQLDOMAINGROUP: <empty>
SQMREPORTING: False
X86: False

Configuration file: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20090716_134747\ConfigurationFile.ini

Detailed results:
Feature: Database Engine Services
Status: Failed: see logs for details
MSI status: Passed
Configuration status: Failed: see details below
Configuration error code: 0xBE03358B@1306@24
Configuration error description: Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes.
Configuration log: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20090716_134747\Detail.txt

Feature: SQL Server Replication
Status: Failed: see logs for details
MSI status: Passed
Configuration status: Failed: see details below
Configuration error code: 0xBE03358B@1306@24
Configuration error description: Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes.
Configuration log: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20090716_134747\Detail.txt

Feature: Management Tools - Complete
Status: Passed
MSI status: Passed
Configuration status: Passed

Feature: Management Tools - Basic
Status: Passed
MSI status: Passed
Configuration status: Passed

Rules with failures:

Global rules:

Scenario specific rules:

Rules report file: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20090716_134747\SystemConfigurationCheck_Report.htm

shah429
Yak Posting Veteran

52 Posts

Posted - 2009-08-05 : 18:28:42

http://support.microsoft.com/kb/960781

Hope that helps.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources