Share via

Edition Upgrade Error

pdsqsql 411 Reputation points
2020-09-18T22:09:02.61+00:00

Hello,
I was trying to upgrade from Standard Edition to Enterprise Edition for Sql server 2014 and Rule check result 1 failed and 1 has warning.
It's failed because of UnSupported Features in System Database Check.
It has warning shows that UnSupported Features in User Database Check.

I have this kind of error first time as i have recently upgraded for Sql 2017 without any issue.

Any help greatly appreciated!

Thank You!

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,016 questions
Accepted answer
  1. pdsqsql 411 Reputation points
    2020-09-24T21:59:09.393+00:00

    Thanks everyone, I have resolved the issue.
    It was weird issue as per my point of view becuase "Rule check result has 1 failed and 1 warning.
    It's failed because of UnSupported Features in System Database Check.
    It has warning shows that UnSupported Features in User Database Check."
    But I found that account i was using doesn't have proper permission so i assigned the permission and upgrade works fine.

    Thank you everyone for your help and suggestions.

4 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. pdsqsql 411 Reputation points
    2020-09-18T22:51:56.78+00:00

    Thanks Erland.
    When click on Failed link, it says" The current edition of Sql server cannot be upgraded because some of the specific features are not supported in the Sql server edition to which you are upgrading. Check the log file for the the list of unsupported features.

  2. Ronen Ariely 15,191 Reputation points
    2020-09-19T21:21:17.697+00:00

    Good day @pdsqsql

    Rule evaluation message: The current edition of SQL Server cannot be upgraded because some of the specified features are not supported in the SQL Server edition to which you are upgrading. Check the log file for the list of unsupported features.

    Please provide the information from the log file as the message explicitly tell you to check it. The message you provide does not include the source of the issue or any relevant information.

    In addition, here are my 2 cents

    upgrade from Standard Edition to Enterprise Edition for Sql server 2014

    Changing the edition of a SQL Server 2014 failover cluster from Standard to SQL Server Evaluation is not supported. Make sure that this is not what you are trying to do.

    Note: The documentation fro 2014 was removed from the Docs website but you can get the same information from the document of 2016. Scroll to the bottom of this page.

  3. CathyJi-MSFT 22,306 Reputation points Microsoft Vendor
    2020-09-21T06:00:49.337+00:00

    Hi @pdsqsql ,

    You can try to use the dynamic management view sys.dm_db_persisted_sku_features to check the edition specific feature that is enabled on the connected instance. Please refer to sys.dm_db_persisted_sku_features (Transact-SQL).

    Best regards,
    Cathy

    If the response is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

  4. Erland Sommarskog 112.7K Reputation points MVP
    2020-09-22T08:52:46.767+00:00

    I don't know if you missed it, but I asked you to attach the log file. Even better may be to upload the entire folder under C:\Program Files\Microsoft SQL Server\120\Setup Bootstrap\xxxxxxx
    where xxxxxx relates to your most recent install attempt.

    Only answering "I don't have a cluster", "I have already checked that DMV" does not help us to help you. You need to share more information if you want this issue resolved.

    Zip that folder, and if it is to big to attach here, upload it somewhere else and post the link.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.