Archive for category: SQL Server 2012

SQL Server 2012 R0 Evaluation expired

27 Jun 2012
June 27, 2012

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:

cannot-connect-to-config-db-error

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

  1. Backup your data folder (just to be safe)
  2. Uninstall  R0 – just search for R0 in the Installed Software list
  3. Install SQL Server 2012 RTM
    1. Take care that you create the same instance
  4. Stop the new instance
  5. Copy back the whole data directory
  6. 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.

Lessons learned

Upgrade even faster to the new versions or wait till RTM.

But: SQL Server 2012 is great – what you think?

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close