Sign in
 
HomeLibraryLearnDownloadsTroubleshootingCommunityForums
SQL Server Developer Center >
> 
> 
Upgrading SQL 2005 x64 Enterprise to 2008 R2 Enterprise

Answered Upgrading SQL 2005 x64 Enterprise to 2008 R2 Enterprise

  • Saturday, March 02, 2013 1:16 PM
     
     
    Sign In to Vote
    0

    Hi all.

    I'm having a problem running an in place upgrade of SQL Server 2005 x64 Enterprise to 2008 R2 Enterprise.

    When I run setup.exe and choose "upgrade", I am able to upgrade all components apart from the database engine. I am not given the option to select an instance prior to this. I have ensured that "x64" is selected from the bottom "options" tab on the initial setup screen. My current installed version of SQL is definitely 2005 x64 Enterprise, I have checked this with @@version and in the general properties of the Management Studio.

    The strange thing is that if I select "x86" from the bottoms tab in SQL setup I AM able to select the 2005 instance, which lists the database engine as something it will upgrade in the next screen. Obviously I have not proceeded with the upgrade as I feel something is wrong somewhere.

    Does anyone have any ideas as to how I can get the x64 install to detect the 2005 instance and upgrade the database engine?

    Thanks

     

All Replies

  • Saturday, March 02, 2013 11:24 PM
    Moderator
     
     
    Sign In to Vote
    1

    Hello,

    Please run the Discovery Report as show on the following post:

    http://blogs.msdn.com/b/petersad/archive/2009/11/13/sql-server-2008-discovery-report.aspx

    Share the results with us.

    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com

     
  • Monday, March 04, 2013 9:37 AM
     
     
    Sign In to Vote
    0

    Hi, this is what I get. My predecessor attempted an in place upgrade, I am led to believe, hence the SQL tools etc being 2008 rather than 2005

    Product Instance Instance ID Feature Language Edition Version Clustered
    Sql Server 2005 MSSQLSERVER MSSQL.1 Database Engine Services 1033 Enterprise Edition (64-bit) 9.2.3042 No
    Sql Server 2005 MSSQLSERVER MSSQL.1 SQL Server Replication 1033 Enterprise Edition (64-bit) 9.2.3042 No
    Sql Server 2005 MSSQLSERVER MSSQL.1 Full-Text Search 1033 Enterprise Edition (64-bit) 9.2.3042 No
    Sql Server 2005 MSSQLSERVER MSSQL.1 SharedTools 1033 Enterprise Edition (64-bit) 9.2.3042 No
    Sql Server 2005 Tools 1033 Enterprise Edition (64-bit) 9.2.3042 No
    Sql Server 2005 ToolsClient 1033 Enterprise Edition (64-bit) 9.2.3042 No
    Sql Server 2005 ToolsClient\Connectivity 1033 Enterprise Edition (64-bit) 9.2.3042 No
    Sql Server 2005 ToolsDocument 1033 Enterprise Edition (64-bit) 9.2.3042 No
    Sql Server 2005 ToolsDocument\BOL 1033 Enterprise Edition (64-bit) 9.2.3042 No
    Microsoft SQL Server 2008 R2 Management Tools - Basic 1033 Enterprise Edition 10.50.1600.1 No
    Microsoft SQL Server 2008 R2 Management Tools - Complete 1033 Enterprise Edition 10.50.1600.1 No
    Microsoft SQL Server 2008 R2 Client Tools Connectivity 1033 Enterprise Edition 10.50.1600.1 No
    Microsoft SQL Server 2008 R2 Client Tools Backwards Compatibility 1033 Enterprise Edition 10.50.1600.1 No
    Microsoft SQL Server 2008 R2 Client Tools SDK 1033 Enterprise Edition 10.50.1600.1 No

     
  • Monday, March 04, 2013 11:26 AM
    Moderator
     
     
    Sign In to Vote
    0

    Hello,

    Please verify the version of Windows installed is supported by SQL Server 2008 R2. Please read the following article:

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

    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com

     
  • Monday, March 04, 2013 11:33 AM
     
     
    Sign In to Vote
    0
    We're running Windows Server 2003 SP2.
     
  • Monday, March 04, 2013 12:44 PM
    Moderator
     
     
    Sign In to Vote
    0

    Hello,

    For sure the media is not 32-bit? 

    Let me think about other possibility …

    Regards,

    Alberto Morillo
    SQLCoffee.com

     
  • Monday, March 04, 2013 1:26 PM
     
     
    Sign In to Vote
    0

    The install media was downloaded from the MS site, it's 32bit and x64, selectable via "options" when installing.

    It looks like the install is erroneously detecting the SQL engine as 32bit for some reason, but I cannot for the life of me see how.

     
  • Monday, March 04, 2013 2:05 PM
    Moderator
     
     
    Sign In to Vote
    0

    Hello,

    Would you mind downloading the media again? Try to download one for 64-bit only.

    Hope this helps.

    Regards,
    Alberto Morillo
    SQLCoffee.com


     
  • Tuesday, March 05, 2013 9:48 AM
     
     
    Sign In to Vote
    0
    Hi, already tried this. And there isn't a separate x64 download for 2008 R2. You get both versions in one media set.
     
  • Wednesday, March 06, 2013 5:45 AM
    Moderator
     
     Answered
    Sign In to Vote
    0

    Do you have the latest service pack applied for SQL server 2005 (Service pack 4)

    Can you try running upgrade advisor

    FAQ
    ----
    Regards,
    Ahmed Ibrahim
    SQL Server Setup Team
    My Blog
    This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
    This can be beneficial to other community members reading the thread.
    View Ahmed Ibrahim's profile on LinkedIn

     
  • Saturday, March 09, 2013 10:23 AM
     
     
    Sign In to Vote
    0

    We were (are) on SQL SP2, so I've just tried to apply SP4. It failed on Database Services (but continued with the install). 

    Am I able to attach the summary.txt here, or just paste the contents in?

    Also, the database engine update failure references another log file - same question for that.

    Thanks for the assistance.

     
  • Sunday, March 10, 2013 6:22 AM
    Moderator
     
     
    Sign In to Vote
    0

    Can you try uploading SQL Server setup logs to file sharing and storage service like SkyDrive.com

    please upload detail.txt

    FAQ
    ----
    Regards,
    Ahmed Ibrahim
    SQL Server Setup Team
    My Blog
    This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
    This can be beneficial to other community members reading the thread.
    View Ahmed Ibrahim's profile on LinkedIn

     
  • Monday, March 11, 2013 11:57 AM
     
     
    Sign In to Vote
    0

    I think I can sort the MSP not being found issue. I'll get that resolved, apply SP4, then try the upgrade to 2008 again. I'll revist this thread once I've attempted that.

    Thanks for the assistance so far.

     
  • Thursday, March 14, 2013 1:05 AM
    Moderator
     
     
    Sign In to Vote
    0

    Hello,

    I’m writing to follow up with you on this post. Was the problem resolved after apply SP4? If you are satisfied with our solution, I’d like to mark this issue as "Answered". Please also feel free to unmark the issue, with any new findings or concerns you may have.

    Regards,

    Fanny Liu

    Fanny Liu
    TechNet Community Support

     
  • Wednesday, March 20, 2013 9:44 AM
     
     
    Sign In to Vote
    0

    Hi, sorry, no - I have not been able to apply SP4. The following error is produced:

    (from summary.txt)

    ----------------------------------------------------------------------------------
    Product                   : Database Services (MSSQLSERVER)
    Product Version (Previous): 3042
    Product Version (Final)   : 
    Status                    : Failure
    Log File                  : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB2463332_sqlrun_sql.msp.log
    Error Number              : 1635
    Error Description         : Unable to install Windows Installer MSP file
    ----------------------------------------------------------------------------------

    Looking at the log file "SQL9_Hotfix_KB2463332_sqlrun_sql.msp.log" I see the following:

    === Verbose logging started: 09/03/2013  09:49:34  Build type: SHIP UNICODE 4.05.6001.00  Calling process: r:\186a440fd64b4581b5\hotfix.exe ===
    MSI (c) (3C:40) [09:49:34:219]: Resetting cached policy values
    MSI (c) (3C:40) [09:49:34:219]: Machine policy value 'Debug' is 0
    MSI (c) (3C:40) [09:49:34:219]: ******* RunEngine:
               ******* Product: {79F1B65E-8FC0-4D03-954D-F9E71C85AEC7}
               ******* Action: 
               ******* CommandLine: **********
    MSI (c) (3C:40) [09:49:34:219]: Client-side and UI is none or basic: Running entire install on the server.
    MSI (c) (3C:40) [09:49:34:219]: Grabbed execution mutex.
    MSI (c) (3C:40) [09:49:34:235]: Cloaking enabled.
    MSI (c) (3C:40) [09:49:34:235]: Attempting to enable all disabled privileges before calling Install on Server
    MSI (c) (3C:40) [09:49:34:235]: Incrementing counter to disable shutdown. Counter after increment: 0
    MSI (s) (CC:F0) [09:49:34:250]: Running installation inside multi-package transaction {79F1B65E-8FC0-4D03-954D-F9E71C85AEC7}
    MSI (s) (CC:F0) [09:49:34:250]: Grabbed execution mutex.
    MSI (s) (CC:F0) [09:49:34:250]: Resetting cached policy values
    MSI (s) (CC:F0) [09:49:34:250]: Machine policy value 'Debug' is 0
    MSI (s) (CC:F0) [09:49:34:250]: ******* RunEngine:
               ******* Product: {79F1B65E-8FC0-4D03-954D-F9E71C85AEC7}
               ******* Action: 
               ******* CommandLine: **********
    MSI (s) (CC:F0) [09:49:34:250]: Machine policy value 'DisableUserInstalls' is 0
    MSI (s) (CC:F0) [09:49:34:250]: Adding MSIINSTANCEGUID to command line.
    MSI (s) (CC:F0) [09:49:34:250]: Warning: Local cached package 'C:\WINDOWS\Installer\1dc05e7d.msi' is missing.
    MSI (s) (CC:F0) [09:49:34:250]: User policy value 'SearchOrder' is 'nmu'
    MSI (s) (CC:F0) [09:49:34:250]: User policy value 'DisableMedia' is 0
    MSI (s) (CC:F0) [09:49:34:250]: Machine policy value 'AllowLockdownMedia' is 0
    MSI (s) (CC:F0) [09:49:34:250]: SOURCEMGMT: Media enabled only if package is safe.
    MSI (s) (CC:F0) [09:49:34:250]: SOURCEMGMT: Looking for sourcelist for product {79F1B65E-8FC0-4D03-954D-F9E71C85AEC7}
    MSI (s) (CC:F0) [09:49:34:250]: SOURCEMGMT: Adding {79F1B65E-8FC0-4D03-954D-F9E71C85AEC7}; to potential sourcelist list (pcode;disk;relpath).
    MSI (s) (CC:F0) [09:49:34:250]: SOURCEMGMT: Now checking product {79F1B65E-8FC0-4D03-954D-F9E71C85AEC7}
    MSI (s) (CC:F0) [09:49:34:250]: SOURCEMGMT: Media is enabled for product.
    MSI (s) (CC:F0) [09:49:34:250]: SOURCEMGMT: Attempting to use LastUsedSource from source list.
    MSI (s) (CC:F0) [09:49:34:250]: SOURCEMGMT: Trying source K:\SQL\SQLServer2005\Servers\Setup\.
    MSI (s) (CC:F0) [09:49:34:547]: Entering CMsiConfigurationManager::SetLastUsedSource.
    MSI (s) (CC:F0) [09:49:34:563]: Specifed source is already in a list.
    MSI (s) (CC:F0) [09:49:34:563]: User policy value 'SearchOrder' is 'nmu'
    MSI (s) (CC:F0) [09:49:34:563]: Machine policy value 'DisableBrowse' is 0
    MSI (s) (CC:F0) [09:49:34:563]: Machine policy value 'AllowLockdownBrowse' is 0
    MSI (s) (CC:F0) [09:49:34:563]: Adding new sources is allowed.
    MSI (s) (CC:F0) [09:49:34:563]: Set LastUsedSource to: K:\SQL\SQLServer2005\Servers\Setup\.
    MSI (s) (CC:F0) [09:49:34:563]: Set LastUsedType to: n.
    MSI (s) (CC:F0) [09:49:34:563]: Set LastUsedIndex to: 2.
    MSI (s) (CC:F0) [09:49:34:563]: SOURCEMGMT: Resolved source to: 'K:\SQL\SQLServer2005\Servers\Setup\'
    MSI (s) (CC:F0) [09:49:34:672]: File will have security applied from OpCode.
    MSI (s) (CC:F0) [09:49:36:594]: SOFTWARE RESTRICTION POLICY: Verifying package --> 'K:\SQL\SQLServer2005\Servers\Setup\SqlRun_SQL.msi' against software restriction policy
    MSI (s) (CC:F0) [09:49:36:594]: SOFTWARE RESTRICTION POLICY: K:\SQL\SQLServer2005\Servers\Setup\SqlRun_SQL.msi has a digital signature
    MSI (s) (CC:F0) [09:49:37:344]: SOFTWARE RESTRICTION POLICY: K:\SQL\SQLServer2005\Servers\Setup\SqlRun_SQL.msi is permitted to run at the 'unrestricted' authorization level.
    MSI (s) (CC:F0) [09:49:37:344]: End dialog not enabled
    MSI (s) (CC:F0) [09:49:37:344]: Original package ==> K:\SQL\SQLServer2005\Servers\Setup\SqlRun_SQL.msi
    MSI (s) (CC:F0) [09:49:37:344]: Package we're running from ==> C:\WINDOWS\Installer\24125279.msi
    MSI (s) (CC:F0) [09:49:37:375]: APPCOMPAT: looking for appcompat database entry with ProductCode '{79F1B65E-8FC0-4D03-954D-F9E71C85AEC7}'.
    MSI (s) (CC:F0) [09:49:37:375]: APPCOMPAT: no matching ProductCode found in database.
    MSI (s) (CC:F0) [09:49:37:375]: Detected that this product uses a multiple instance transform.
    MSI (s) (CC:F0) [09:49:37:391]: MSCOREE already loaded, using loaded copy
    MSI (s) (CC:F0) [09:49:37:391]: Applying multiple instance transform ':SqlRun01.mst'...
    MSI (s) (CC:F0) [09:49:37:391]: Looking for storage transform: SqlRun01.mst
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2205 2:  3: Patch 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2205 2:  3: PatchPackage 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: _Tables 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: _Columns 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: Media 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: File 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: TRANSFORM: 'PatchPackage' table is missing or empty.  No pre-transform fixup necessary.
    MSI (s) (CC:F0) [09:49:37:391]: TRANSFORM: Applying regular transform to database.
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: _Tables 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: _Columns 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: _Validation 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: File 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: MsiFileHash 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: Signature 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: RegLocator 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: AppSearch 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: CompLocator 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: DrLocator 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: Binary 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: CustomAction 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: Directory 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: Registry 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: Condition 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: CreateFolder 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: _sqlObjectSecurity 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: Icon 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: InstallExecuteSequence 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: InstallUISequence 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: AdminExecuteSequence 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: AdminUISequence 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: AdvtExecuteSequence 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: AdvtUISequence 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: _sqlAction 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: _sqlActionsModule 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: _sqlDriveType 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: ReserveCost 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: TypeLib 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: Feature 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: MsiAssembly 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: Class 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: Extension 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: PublishComponent 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: ServiceControl 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: ModuleDependency 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: ModuleSignature 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: ModuleExclusion 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: ModuleComponents 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: _sqlBuiltInAccounts 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: MsiAssemblyName 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: ServiceInstall 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: _sqlNativeImage 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: _sqlPropertyValues 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: _sqlUserSecurity 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: _sqlRegistry 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: _sqlServiceControl 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: _sqlHiveCopy 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: _sqlRegSecurity 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: _sqlGroup 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: _sqlGroupMember 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: _sqlConfig 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: _sqlUpgradeScript 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: _sqlHotfixScript 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: _sqlScript 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: ActionText 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: _sqlSku 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: _sqlStart 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: _sqlServiceAccount 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: _sqlDelimitProperty 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: _sqlEquivalent 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: _sqlWizardSequence 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: Dialog 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: _sqlMofcomp 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: _sqlWMISecurity 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: _sqlInstanceProperty 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: _sqlInstanceComponents 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: _sqlAssembly 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: Error 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: _sqlPerfCounters 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: _sqlCollation 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: _sqlExecutable 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: _sqlFileSR 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: _sqlUnmanagedComponent 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: _sqlUpgradeComponent 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: _sqlProducts 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: _sqlTopLevelFeatureProducts 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: _sqlFileRename 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: _sqlFollowComponents 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: _sqlLocalServers 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: _sqlVerIndependentProgID 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: _sqlServiceState 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: _sqlServiceProperty 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: _sqlServiceConfig 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: _sqlSupportFiles 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: _sqlDomainGroup 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: FeatureComponents 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: Control 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: ControlEvent 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: ControlCondition 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: ListBox 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: ListView 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: ComboBox 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: CheckBox 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: EventMapping 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: RadioButton 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: Upgrade 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: TextStyle 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: UIText 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: Media 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: Shortcut 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: SxsMsmGenComponents 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: MsiSFCBypass 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: RemoveFile 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: RemoveRegistry 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: Environment 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: _sqlUpgradeFile 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: _sqlUpgradeRegistry 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: _sqlUpgradeFolders 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2262 2: _MsiPatchTransformView 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Transforming table Component.

    MSI (s) (CC:F0) [09:49:37:391]: Opening existing patch 'C:\WINDOWS\Installer\1dc05f7a.msp'.
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2203 2: C:\WINDOWS\Installer\1dc05f7a.msp 3: -2147287038 
    MSI (s) (CC:F0) [09:49:37:391]: Couldn't find local patch 'C:\WINDOWS\Installer\1dc05f7a.msp'. Looking for it at its source.
    MSI (s) (CC:F0) [09:49:37:391]: Resolving Patch source.
    MSI (s) (CC:F0) [09:49:37:391]: User policy value 'SearchOrder' is 'nmu'
    MSI (s) (CC:F0) [09:49:37:391]: SOURCEMGMT: Media enabled only if package is safe.
    MSI (s) (CC:F0) [09:49:37:391]: SOURCEMGMT: Looking for sourcelist for product {CC67DE68-1870-481E-9054-0568556B992A}
    MSI (s) (CC:F0) [09:49:37:391]: SOURCEMGMT: Adding {CC67DE68-1870-481E-9054-0568556B992A}; to potential sourcelist list (pcode;disk;relpath).
    MSI (s) (CC:F0) [09:49:37:391]: SOURCEMGMT: Now checking product {CC67DE68-1870-481E-9054-0568556B992A}
    MSI (s) (CC:F0) [09:49:37:391]: SOURCEMGMT: Media is enabled for product.
    MSI (s) (CC:F0) [09:49:37:391]: SOURCEMGMT: Attempting to use LastUsedSource from source list.
    MSI (s) (CC:F0) [09:49:37:391]: SOURCEMGMT: Trying source e:\c292f3932dc59a2b3dc60f\HotFixSQL\Files\.
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 2203 2: e:\c292f3932dc59a2b3dc60f\HotFixSQL\Files\sqlrun_sql.msp 3: -2147287037 
    MSI (s) (CC:F0) [09:49:37:391]: SOURCEMGMT: Source is invalid due to missing/inaccessible package.
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 1706 2: -2147483647 3: sqlrun_sql.msp 
    MSI (s) (CC:F0) [09:49:37:391]: SOURCEMGMT: Processing net source list.
    MSI (s) (CC:F0) [09:49:37:391]: Note: 1: 1706 2: -2147483647 3: sqlrun_sql.msp 
    MSI (s) (CC:F0) [09:49:37:391]: SOURCEMGMT: Processing media source list.
    MSI (s) (CC:F0) [09:49:37:391]: SOURCEMGMT: Resolved source to: 'sqlrun_sql.msp'
    MSI (s) (CC:F0) [09:50:37:485]: Note: 1: 1314 2: sqlrun_sql.msp 
    MSI (s) (CC:F0) [09:50:37:485]: Unable to create a temp copy of patch 'sqlrun_sql.msp'.
    MSI (s) (CC:F0) [09:50:37:485]: Searching provided command line patches for patch code {CC67DE68-1870-481E-9054-0568556B992A}
    MSI (s) (CC:F0) [09:50:37:485]: File will have security applied from OpCode.
    MSI (s) (CC:F0) [09:50:37:907]: Original patch ==> r:\186a440fd64b4581b5\HotFixSQL\Files\sqlrun_sql.msp
    MSI (s) (CC:F0) [09:50:37:907]: Patch we're running from ==> C:\WINDOWS\Installer\2412527a.msp
    MSI (s) (CC:F0) [09:50:37:922]: Note: 1: 1708 
    MSI (s) (CC:F0) [09:50:37:922]: Product: Microsoft SQL Server 2005 (64-bit) -- Installation failed.

    MSI (s) (CC:F0) [09:50:37:922]: Windows Installer installed the product. Product Name: Microsoft SQL Server 2005 (64-bit). Product Version: 9.00.1399.06. Product Language: 1033. Installation success or error status: 1635.

    MSI (s) (CC:F0) [09:50:37:938]: Attempting to delete file C:\WINDOWS\Installer\2412527a.msp
    MSI (s) (CC:F0) [09:50:37:969]: MainEngineThread is returning 1635
    MSI (s) (CC:F0) [09:50:38:079]: No System Restore sequence number for this installation.
    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.
    K:\SQL\SQLServer2005\Servers\Setup\SqlRun_SQL.msi
    MSI (s) (CC:F0) [09:50:38:079]: User policy value 'DisableRollback' is 0
    MSI (s) (CC:F0) [09:50:38:079]: Machine policy value 'DisableRollback' is 0
    MSI (s) (CC:F0) [09:50:38:079]: Incrementing counter to disable shutdown. Counter after increment: 0
    MSI (s) (CC:F0) [09:50:38:079]: Note: 1: 1402 2: HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Installer\Rollback\Scripts 3: 2 
    MSI (s) (CC:F0) [09:50:38:079]: Note: 1: 1402 2: HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Installer\Rollback\Scripts 3: 2 
    MSI (s) (CC:F0) [09:50:38:079]: Note: 1: 1402 2: HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Installer\InProgress 3: 2 
    MSI (s) (CC:F0) [09:50:38:079]: Note: 1: 1402 2: HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Installer\InProgress 3: 2 
    MSI (s) (CC:F0) [09:50:38:079]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied.  Counter after decrement: -1
    MSI (s) (CC:F0) [09:50:38:079]: Restoring environment variables
    MSI (c) (3C:40) [09:50:38:079]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied.  Counter after decrement: -1
    MSI (c) (3C:40) [09:50:38:079]: MainEngineThread is returning 1635
    === Verbose logging stopped: 09/03/2013  09:50:38 ===

    The location "e:\c292f3932dc59a2b3dc60f\HotFixSQL\Files\sqlrun_sql.msp" does not exists (the e: drive is completely empty). I have created this folder and copied the extracted sqlrun_sql.msp (from the SP4 download) to that location. The above errors still occur.

    Any help would be appreciated.

     
  • Wednesday, April 03, 2013 3:57 PM
     
     Answered
    Sign In to Vote
    0

    Just an update to this, with a view to closing the thread:

    I couldn't figure out how to install SP4, and so could not perform an in place upgrade of SQL 2005. I went for a side by side upgrade, which worked as expected. So while I have not fixed the issue I have worked around it and will be removing the SQL 2005 instance from the server once the application tier is fully configured to use the 2008 instance.

    Thanks