SQL Server 2008 Evaluation period expired. Can't use SSMS.

  • I think I should know this, but I am currently at a loss.

    On my desktop I have VS2k8 (w/out SQL server Installes). SQL Server 2005 Management tools and the Eval Edition of SQL Server 2008.

    We are in the process of upgrading our SQL servers to SQL Server 2008, and have several configured, up, and running (some STD edition, Some Enterprise).

    My problem is the when the Eval edition expired, I lost the use of SSMS. I can remrote into the servers and use SSMS there, but frankly,that wearing a bit thin.

    I can load SSMS from the Enterprise or STD installation media, do I need to uninstall The Eval first?

    I have moved all my prototypes to a development server, so data is not an issue.

    Thanks in advance.

  • SQL Server MVP Jonathan Kehayias has posted a workaround he has found. It'll still mean you have to run an upgrade, but you won't have uninstall/reinstall.

    SQL Server 2008 Evaluation Edition Expiration Woes

    K. Brian Kelley
    @kbriankelley

  • Thanks. I'll give it a shot.

  • My SQL 2008 installation is now fatally crippled. Luckily all my customers are on SQL 2005 and SSMS 2005 is working OK with those databases.

    I tried the Registry workaround, setting 1 to 3 in Commonfiles - but that made no difference when reinstalling SSMS 2008 (Client Tools)

    I don't remember ever installing any Evaluation Edition on this PC (having had woes with that in the past) - but SSMS 2008 (Enterprise Edition with SP1 applied) just suddently started issuing the "SQL Server 2008 Evaluation period expired" message this morning without me doing anything.

    I have just subscribed to the Action Pack for Dev and Design and so my current "workaround" is to wait for my order to be processed so I can download and upgrade to SQL 2008 R2. Does anyone know if that should work?

    It so happens my subscription to MSDN has just expired. Surely there isn't a linkage in which SSMS then stops working without any warning??

    Any and all comments welcome.

  • Perhaps I am missing something, so from the beginning...

    When the eval expired, I got the "expired" message. So I installed the licensed version but still got the message. I uninstalled the eval and licensed version, reinstalled the licensed version with the registry tweak. Still getting the expired message. I've run out of ideas.

    It's not clear to me what you mean by Edition upgrade. All I am doing is running setup off of the media I received. I do see an option that says add new features, but nothing that explicity says "Edition upgrade"

  • I have licensed media, but I have been unable to get it running on the machine that has an expired eval version on it. I'm on day 4, having made no progress over the weekend. I've run out of ideas, short of re-imaging my laptop.

  • Upgrade to SQL 2008 R2 and the problem goes away.

    It's got to be cheaper than spending 4 days??

  • OK, so I will reinstall the licensed version of SQL then poke around and find the R2 upgrade and see what happens. I may have done this over the weekend. It's getting blurry.

  • Ahhh, I see the problem. I was thinking 2008 R2 was a service pack, but I see it's another product. I don't think the company is going to leap at the chance to spend another $900. Hopefully I'll get some help here today.

  • I guess it depends if you're using it or just developing with it - which I am.

    I've got the Action Pack for Development and Design - £300 ish, which includes R2 amongst many other useful things.

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

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