I have a client that has a recently expired SQL Server 2008 R2 Enterprise Evaluation Edition. I've been tasked to get it licensed and running SQL Server 2008 R2 Standard. How can I achieve this?
Sql-server – Evaluation edition expired
licensesql serversql-server-2008-r2
Related Solutions
You've already I assume, applied the registry fix suggested by Microsoft.
Since they are saying that this has been resolved since SP1, have you considered installing a newer version of SQL Server 2008 R2 Express?
http://www.microsoft.com/en-us/download/details.aspx?id=26729
Update 12:27
Based on what you're saying and without having your system in front of me, I'd try to find out if the evaluation edition you think you removed might actually still be there.
You can run the SQL Server features discovery report to find out what components are actually installed on your laptop.
Start -> All Programs -> SQL Server 2008 -> Configuration Tools -> SQL Server Installation Center. Then on the left you select Tools, and then click on the Installed SQL Server features discovery report.
Installation Center - Tools
Features Report
I would also go Control Panel, Uninstall Programs, and make sure there wasn't anything left over from the evaluation edition. Once you're absolutely sure that evaluation is gone, reboot the system just to make sure that the registry is reloaded correctly.
Unfortunately looking at the MS matrix you cannot do this. You were able to earlier because evaluation versions don't have that lock, but once you go full edition it's locked out
http://msdn.microsoft.com/en-us/library/ms143393%28v=sql.105%29.aspx
You could try an approach taken here but proceed with extreme caution. http://skreebydba.com/2012/11/16/downgrading-sql-server-enterprise-to-standard-with-scripts/
[edit]: This URL has the scripts to recreate logins, etc. that Aaron pointed out Just a headsup though, this doesn't script out jobs. If you restore MSDB to recreate jobs, make sure to
UPDATE MSDB..SysJobs
SET Originating_Server = 'SQLServerName'
It will also work for downgrades to web.
Related Question
- SQL Server 2014 – Upgrading Standard Edition Trial to Full Core License
- Sql-server – SQL Server 2008 Edition Upgrade Enterprise Evaluation to Standard problem
- SQL Server License Issue – Report Builder Evaluation Overwrites Standard License
- Sql-server – SQL Server 2016 Standard Version Features Evaluation
- Sql-server – “SSIS Evaluation Period Has Expired” on Dev Instance
- Sql-server – Make Edition Upgrade in a SQL cluster scenario
- SQL Server Backup Restore – Enterprise Edition 2014 to Standard Edition 2017
- SQL Server Evaluation Period Expired – How to Resolve
Best Answer
You have to install SQL Server 2008 r2 Standard edition side by side (if you want to do it on the same server) and then move the database using backup/restore method.
Below is an outline of what needs to be done (if you want to do it on the same server without installing a side by side SQL 2008R2 instance).
Also, Unless you're using Enterprise-only features, you should be able to use detach and attach method from Enterprise to Standard.
Refer to answer by Jonathan here.
Also, refer to this approach with scripts... BUT WITH EXTREME CAUTION !! ... it uses detach/attach method and if you are using any enterprise features (which wont work in Standard edition) then the attach wont work.
Also, refer to Version and Edition Upgrades Matrix.