Tuesday, October 25, 2016

SQL Server trial license expired on your cloud boxes for AX7?

If you have made deployments before summer, you might have deployments where the SQL Server is installed with a trial license and it is set to expire november 1st. When it expires you are not able to start the SQL Server service anymore.

Here are the necessary steps to update SQL Server:

  • Obtain a valid installation media and license. 
  • Stop the "Hyper-V Time Synchronization Service" service.
  • Change the system date on the server, to a date before the trial expiry date.
  • Run SQL Server installation and choose "Upgrade from preview version"
  • Start the "Hyper-V Time Synchronization Service" service again.

The reason for changing the system date is that the upgrade won't run if it can't start the existing SQL Server service.


Deep said...

When I am trying to do an upgrade, it is creating a new instance.

Can we do without creating a new instance or what are points which need to be updated with new SQL instance(any web.config file etc)

Palle Agermark said...

My team hos done this on a few different machines and didn't get any new instances. I can't remember the entire upgrade wizard, but it might be here you need to pay attention to all the different choices you can do.

Alessandro Colombi said...

Hi Palle, I stopped HyperV service, changeed the server time but the SQL service still do not start. In this way I am not able to perform the sql upgrade.
I am in a kind of loop...
@Deep, to perform the upgrade you need to follow this section in the installation media: maintenance -> edition upgrade. no need to create a new instance. if so, then you are in the wrong menĂ¹ :)


Unknown said...

Thank you for sharing and explaning this useful steps to update SQL Server! It's exactly what I was looking for, because I'm a beginner in ms dynamics field and need to learn so much.