Once you install evaluation edition of SQL Server 2008 and then perform in place upgrade to full version, you may get below error message when you open SQL Server Management Studio.
For better search, below is the text of the message
Microsoft SQL Server Management Studio: Evaluation period has expired. For information on how to upgrade your evaluation software please go to http://www.microsoft.com/sql/howtobuy
Have a close look at error… This is for Management Studio. This means that this is the problem with management studio only. If its not yet expired, inside of Management Studio, going to Help > About... still shows this the expiration countdown.
This is identified as a known issue where SSMS is not upgraded when you do edition upgrade for SQL Server 2008. To workaround the problem you can hack registry keys. Set CommonFiles registry value to 3 in HKLM\SOFTWARE\\Microsoft\Microsoft SQL Server\100\ConfigurationState Registry Hive. You will then need to reinstall (if the tools are not installed currently) or run edition Upgrade. Reference: connect bug
This is already fixed in SP1.
Update: 12 May 2009.
KB article published for same issue. http://support.microsoft.com/kb/971268
Thank You, this fixed a major upgrade issue I had.
Thanks, you just saved me a bunch of time.
Dopo l’applicazione dell’SP1 di SQL Server 2008, se avete un’installazione che avete inizalmente installato
BIG FAT THANKS, this worked perfectly!
Thanks Eva, great to know that it helped.
Thank you for this - My head was spinning trying to figure out why it kept giving the message!!!
Thanks - I thought I was going mad!
This is an awesome hack and work perfectly Thanks a lot
You are the Dood... good stuff.
Thanks a lot
work like a charm!
Thanks a lot. Great fix . Saved my hair.
How do I run an "Edition upgrade". I have distribution media but when I run setup.exe it does not offer an Edition upgrade.
1, Insert the SQL Server installation media. From the root folder, double-click setup.exe
2, To upgrade an existing instance of SQL Server 2008 to a different edition, from the SQL Server Installation Center click Maintenance, and then select Edition Upgrade.
Thanks guys.. It works like a charm.. struggle with for two days as I was doing it cluster and I was little sacred that it might break my cluster. However Everything went well.. It is working fine now... Thanks again..
It is July 2nd, 2010 and I am experiencing the same problem so SP1 did not fix it. I will try this work around