Wednesday, October 7, 2009

Edition Change Check (Warning)

Edition Change Check (Warning)

This is the most common warning message reported on Windows Vista and Windows 7 related to SQL Server installation. There are various reasons for this message but the most common issue is to run the setup from the same DVD from which you first installed SQL Server 2005. I have faced this issue several times on different machines running Windows Vista and Windows 7 Evaluation build 7100. My findings are as follows:

Whenever you run SQL Server setup.exe on a Vista or Windows 7 machine the system configuration checker checks the system it issues this warning (Edition Change Check). No matter what Edition of SQL Server is installed on the system perviously. The prime reason behind this is that you have installed and applied service packs on SQL Server instance and its components. The installer you are running first gives you the compatibility warning and once you ignore it and run the setup, it will give you Edition change check warning. There are two approaches to this:

1. Ignore the message and continue
2. Run the SQL Server 2005 Setup from a command line and provide the upgarede option as follows:

Setup.exe SKUUPGRADE = 1

This will run the setup with upgrade option and the Edition Check warning disappears. See below:
























Hope it helps.

6 comments:

  1. I have heard about the best pdf repair app. Besides, you can visit my blogs at: http://daspeac.livejournal.com/ or http://daspeac.blogspot.com/ where I’m trying to share my experience with regard to data corruption issues.

    ReplyDelete
  2. Nice posting and nicely explained. Keep going.
    There are few errors that are not resolved manually for that you need to use sql recovery software.

    ReplyDelete
  3. Make sure you put the command in all CAPS or it will not work

    ReplyDelete
  4. Nice posting and nicely explained. Keep going.
    There are few errors that are not resolved manually for that you need to use sql recovery software.

    ReplyDelete
  5. how we can run the sql server from commandline prompt

    ReplyDelete
  6. Nice posting and nicely explained. Keep going.
    There are few errors that are not resolved manually for that you need to use sql recovery software.

    ReplyDelete

There was an error in this gadget