Yesterday was the 180th day without problems on my DEV/DEMO environment – until my eval expired without noticeable warning ahead. The whole thing just locked down and of course my SharePoint doesn’t like that:
Great, just great.
Because Alegri is a Microsoft Partner, we do have valid SQL Server 2012 codes – so I asked for one, received one and tried to upgrade my license from EVAL to ENTERPRISE. So I started the installer of R0, clicked on the “change license” link entered the code – everthing ran green. Still Management Studio complains that my version is expired and the SQL Server Service wont start… so I tried to upgrade to SQL Server 2012 RTM – started the upgrade thing in the RTM installer. After checking a lot of stuff it complained that it can't connect to the SQL Server instance. For sure it can't because I can’ start it.
How I fixed it - or making it work again
- Backup your data folder (just to be safe)
- Uninstall R0 – just search for R0 in the Installed Software list
- Install SQL Server 2012 RTM
- Take care that you create the same instance
- Stop the new instance
- Copy back the whole data directory
- Check if everything works again
At first tried to attach all Databases back to the instance - but – I would have lost all permissions on the Master node and receive a “Can not connect to SharePoint configuration database”.
All works smoothly again – no more time bombs in my environment more. If you don't have a license, sorry, can't help you.
Upgrade even faster to the new versions or wait till RTM.