Published By: Bill Chesnut
The Issue
As some of us have encountered the Azure IaaS Gallery Image for BizTalk 2013 R2 Developer was created with SQL 2014 Evaluation Edition, this expired a couple of weeks ago and when you tried to use the image you got:
Microsoft has replaced the Image in the Azure Gallery on Friday Evening Australian Eastern Standard Time, but the new image is also built with SQL 2014 Evaluation Edition.
Fixing the Expired and future Proofing your new virtual machine
To fix the image, you must have an MSDN subscriptions that contains SQL 2014 Developer Edition x64
- download SQL 2014 Developer Edition x64 ISO to your virtual machines
- double click on the ISO, this will start the SQL Installer
- Click on Maintenance in the left column
- Click on Edition Upgrade
- Click Next
- Accept the license terms and Click Next
- Click Next
- Click Upgrade, Wait for Upgrade to Complete
- Click Close
- Open SQL Server Management Studio
- Right Click on SQL Server and Select Properties
- Verify that is it no longer SQL Server Evaluation Edition
Conclusion
I wish that these steps had not been necessary, but the solution is not that difficult, I have already completed this process on 4 of my own developer virtual machines and a few client machines also.