Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

How do I activate an 2012 SQL server that expired in trial mode

Posted on 2015-01-28
5
Medium Priority
?
292 Views
Last Modified: 2015-01-29
I recently shut down my server due to a pending Snow Blizzard. I turned the server back on to discover the SQL server is unable to start.

Event Viewer Log:

Event ID: 17051
SQL SErver Evaluation period expired

Event ID: 1058
Installation of the proof of purchase from the ACPI table failed. Error Code: 0xC004F057

I researched the web. It appears that all I have to do is reinsert the 2012 SQL DVD and opt for Maintenance - Edition Upgrade to enter the license code.

I am concerned of my 2 business databases. I don't won't to cause corruption or loss of data.

Is that it? Just attempt an upgrade?

Do I need to know any safety tips prior to proceeding?
0
Comment
Question by:GeeMoon
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 52

Accepted Solution

by:
Vitor Montalvão earned 2000 total points
ID: 40575465
Backup the databases before so if something goes wrong you can restore them.
For the rest, yes, is just that. A simple license upgrade and that's all.
0
 

Author Comment

by:GeeMoon
ID: 40575606
I am unable to access the SQL Server Management Studio, in order to perform a backup of the residing databases. I did do a straight backup of the database folder.

Interesting note:

I went on site, expecting that both instances of SQL were down.  To my surprise, one of the instances was up and running. It seems my first instances is the only one that is unable to execute. I am confused. I assume that if SQL was halted due to a Trial expiration, I would be unable to utilize any DB within SQL. Plus, again, I am unable to access the SQL Server Management Studio.
0
 
LVL 52

Expert Comment

by:Vitor Montalvão
ID: 40575613
If the SQL Server service is stopped then you can copy the database files. Don't forget to copy the .mdf and .ldf files.

SQL Server Management Studio should runs always since it's a free tool and you can use it to connect to any SQL Server instance in your network, not only the local instance.
0
 

Author Closing Comment

by:GeeMoon
ID: 40575729
I performed the upgrade. It stalled during the upgrade process, got me nervous. It appeared to be doing nothing, then if finally went through successfully. I executed the SQL service, for the instance, in services - successful. I was able to access all the IE pages via the web interface.

I am now, also, able to access the 'SQL Server Management Studio'. Vitor, your logic was sound on the Management piece. I agree, it should not be locked to a specific instance. It should be able to access any DB. Welcome to our world.....LOL

Thank you for all your help and speedy attention Vitor
0
 
LVL 52

Expert Comment

by:Vitor Montalvão
ID: 40576930
Glad I could help.
Cheers
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
Windows Server 2003 introduced persistent Volume Shadow Copies and made 2003 a must-do upgrade.  Since then, it's been a must-implement feature for all servers doing any kind of file sharing.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
This tutorial will walk an individual through the process of installing the necessary services and then configuring a Windows Server 2012 system as an iSCSI target. To install the necessary roles, go to Server Manager, and select Add Roles and Featu…

636 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question