September 2, 2009 at 1:21 pm
How did you get the upgrade to work? I choose Edition Upgrade from the Maintenance menu of the Installation Center and get all the way to the Edition Upgrade Rules when I receive a Rule Check - Rule "SQL Server 2008 Edition upgrade" failed. The selected SQL Server instance does not meet upgrade matrix requirements. I am trying to upgrade/downgrade from Enterprise Evaluation to Standard. The official Microsoft page says that this is a supported upgrade path.
September 2, 2009 at 1:49 pm
Hi Barry,
I couldn't get the upgrade to work. I took the .mdf/ldf files and attached to another server with the same version/build, then reset orphan logins then I uninstalled the evaluation version...erasing the bad experience from my memory...
September 2, 2009 at 1:50 pm
That upgrade path should work. Are you trying to go from 2005 Enterprise Eval to 2008 Standard by any chance?
September 2, 2009 at 2:55 pm
2008 Enterprise Eval to 2008 Standard is what I am trying to do. Oh well, I think I am just going to uninstall/reinstall.
September 2, 2009 at 3:18 pm
this talk of upgrading eval. edition to other editions seems to tie in to a recent editorial and the ensuing discussion:
http://www.sqlservercentral.com/Forums/Topic780419-263-3.aspx#bm780884
so people seem to have varying experiences and luck with upgrading. I wonder what the definitive answer is to upgrading eval editions and what the gotcha is that prevents an upgrade. the OS perhaps?
---------------------------------------------------------------------
September 3, 2009 at 2:08 am
As I posted above, ours worked OK, well, I say OK, so it seemed until last week while I was on holiday, the Integration Services evaluation period expired, even though the up/downgrade completed successfully, including SSIS. So just watch out for that.
September 15, 2009 at 3:31 am
please read this for your options with sql2008 editions and upgrade options:
http://msdn2.microsoft.com/en-us/library/ms143393.aspx
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
October 15, 2009 at 4:20 pm
I have SQL Server 2008 Developer Edition (Evaluation version) installed. It expires in about 2 weeks. Want to upgrade it to SQL Server 2008 Enterprise Edition. Is this possible ?
If it is, do I purchase a license key (PID key) for new edition ?
October 15, 2009 at 9:55 pm
Yes this is possible. You would need to buy the new license, then do a SKUUPGRADE install. Basically you launch the installer off of the Enterprise Edition CD/DVD using the /SKUUPGRADE switch. This will let you run through the install and do the SKUUPGRADE. After the installer has run (you'll need to reinstall all the services you currently have installed) reinstall the service pack that you had installed.
October 16, 2009 at 1:52 pm
Thanks Denny, your help is much appreciated.
The server was loaded with SQL 2008 Developer Edition (Eval version),
SSRS was installed, about 20 databases copied to the server, more than 150 SQL Reports added.
SKUUPGRADE install + reinstall all the SQL services -
does this mean that I need to attach all the databases,
add all the SQL Reports (including subscriptions) ?
October 16, 2009 at 2:01 pm
No, when SQL installs and does the SKUUPGRADE it will leave all the databases alone. After the installer is done everything should look just as it did before, just running a licensed copy of SQL Server.
October 16, 2009 at 2:30 pm
Thanks Denny, you really add value to this site, wish someday the rest of us can do the same.
November 18, 2009 at 11:04 pm
hi.,
you can re install a trial version of sql server 2008 but first you need a CC Cleaner
to do that here is the step.,
Obviously you should un-install the expired SQL Server 2008 first., then after uninstallation delete the folder of Microsoft SQL Server on your program files., Then run your CC Cleaner and go to Registry panel and click the 'Scan for issues'
it will give you all the problems in your registry and after that click the 'Fix selected Issues' then restart your PC and Install again your Trial version of SQL Server 2008 again., be sure to backup your database before un-installing., pls give me an email if i helped you and if you have question about SQL., tnks.,,
here is my email icanhelp26@yahoo.com
Hope this helps.,,,
November 19, 2009 at 2:31 am
Hello icanhelp26,
If having tried SQL Server and found that you like it, you could buy the Developer Edition, it's fairly cheap, £49 over here and contains practically all the same features. Obviously, you can't use it in production, hence the name 🙂 If you didn't need all the features, you could use the Express version instead, it's free.
November 19, 2009 at 12:25 pm
Running a registry cleanup tool against a server, especially a production server is a bad idea. I've been doing this for a decade and have never found the need to run any sort of cleanup against the registry.
When dealing with an expired trial license of SQL Server the correct solution is to replace it with a paid for version, not to attempt to extend the trial by butchering the registry. Who knows what keys the cleaner will remove and what those keys are actually used for.
Viewing 15 posts - 16 through 30 (of 36 total)
You must be logged in to reply to this topic. Login to reply