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
Are you saying that you applied SP1 before Edition Upgrade to "full" version and its still SSMS expired?
How about SQL Engine, is that running?
Hello, i have same issues just like this, have hacked the registry value to 3, then i tried to do the "Edition Upgrade" but i couldn't finish the installation. The error's feedback is on SQL Server 2008 edition upgrade which is failed.
please help me..
Could you please send me setup logs to my official email id = blakhani (at) microsoft (dot) com ?
Same problems (message) appears on SQLSERVER2008 R2 evaluation version.
After 2 weeks, the sql server engine is down and management studio is also unavailable. Windows server is also eval version 2008 standard.... why it happens? I just want to eval product for 180 days not to write an essey about windows disability or installation problems.
Could you help?
Can anyone help me to know the meaning behind the values 0,1,2,3 of ConfigurationState in the registory hive?
thanks for info
I am lookging at the Management console's Help/About and we are on SP2 but still received this error and our cleint did not do and upgrade eval this was a full blown install. BUt I am verifying that the customer did not eval it then registered it. But the Version is @ SP2.
You can use the below registry update to fix the issue. I faced the same problem and after applying this registry able to open SSMS.
Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\100\Tools\ClientSetup]
"SQLBinRoot"="C:\\Program Files\\Microsoft SQL Server\\100\\Shared\\"
"SQLPath"="C:\\Program Files\\Microsoft SQL Server\\100\\Tools"
"SqlToolsPath"="C:\\Program Files\\Microsoft SQL Server\\100\\Tools\\Binn\\VSShell\\Common7\\IDE\\"
"Path"="C:\\Program Files\\Microsoft SQL Server\\100\\Tools\\Binn\\"
"VSToolsPath"="C:\\Program Files\\Microsoft Visual Studio 9.0\\Common7\\IDE\\PrivateAssemblies\\"
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\100\Tools\ClientSetup\CurrentVersion]
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\100\Tools\ClientSetup\SQLCEBinRoot]
"3.5"="C:\\Program Files\\Microsoft SQL Server Compact Edition\\v3.5\\Tools\\"
didn't work for me, but i resolve this problem with uninstall sql server and install again... :D hope these help