I am trying to upgrade from sql 2012 (11.0.6020) to sql 2014 sp1.

  • I get an error that it cannot upgrade. These are the features that it is trying to update.

    Database engine services

    sql server replication

    full-text and semantic extractions for search

    data quality services

    Shared features

    client tools connectivity

    integration services

    client tools sdk

    Management tools - complete

    Its a development server, so I don't actually need full-text extractions or data quality services. I've included an attachment that is a screenshot of the error. Anybody else had this problem?

  • fantom (4/11/2016)


    I get an error that it cannot upgrade. These are the features that it is trying to update.

    Database engine services

    sql server replication

    full-text and semantic extractions for search

    data quality services

    Shared features

    client tools connectivity

    integration services

    client tools sdk

    Management tools - complete

    Its a development server, so I don't actually need full-text extractions or data quality services. I've included an attachment that is a screenshot of the error. Anybody else had this problem?

    What are the source and target editions? (Express, Development, Standard etc.)


  • Source and target editions are both enterprise.

  • fantom (4/11/2016)


    Source and target editions are both enterprise.

    Enterprise on a dev server?


  • Enterprise in dev aside, there are a few things to check -- 1) you cannot add features during an upgrade, you can only upgrade what's already there. Make sure you aren't trying to add features. 2) Check the versions in terms of 32/64 bit. You have to go 32-32 and 64-64. If you upgrade a 32 bit install with 64 bit binaries you will have issues. Check those out.

  • fantom (4/11/2016)


    Source and target editions are both enterprise.

    Are you certain about that? Check @@version, check the installer for what edition it is.

    The error message you posted indicates an edition change.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • Microsoft SQL Server 2012 (SP3) (KB3072779) - 11.0.6020.0 (X64)

    Oct 20 2015 15:36:27

    Copyright (c) Microsoft Corporation

    Enterprise Edition (64-bit) on Windows NT 6.2 <X64> (Build 9200: ) (Hypervisor)

  • Can you browse to the <root>\Program Files\Microsoft SQL Server\120\Setup Bootstrap\Log area of the server and look for a Detail.txt? There should be a clearer error message in there somewhere.

  • And I saw these:

    (01) 2016-04-11 13:01:22 Slp: Sco: File '\\ae-it-fileprod1\AE-InfoTech\Software\Servers\SQL Server 2014 SP1\SQL Standard 2014 x64 SP1\x64\setup\x64\sql_fulltext.msi' does not exist

    (01) 2016-04-11 13:01:22 Slp: Sco: File '\\ae-it-fileprod1\AE-InfoTech\Software\Servers\SQL Server 2014 SP1\SQL Standard 2014 x64 SP1\x64\setup\x86\sql_fulltext.msi' does not exist

    (01) 2016-04-11 13:01:22 Slp: Sco: File '\\ae-it-fileprod1\AE-InfoTech\Software\Servers\SQL Server 2014 SP1\SQL Standard 2014 x64 SP1\x64\setup\x64\sql_dq.msi' does not exist

    (01) 2016-04-11 13:01:22 Slp: Sco: File '\\ae-it-fileprod1\AE-InfoTech\Software\Servers\SQL Server 2014 SP1\SQL Standard 2014 x64 SP1\x64\setup\x86\sql_dq.msi' does not exist

    I saw some other errors and realized that my 2014 SP1 install media was standard. My SQL 2014 media was enterprise, so I installed that one.

Viewing 9 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply