We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

SQL 2008 License Update from Trial

Medium Priority
413 Views
Last Modified: 2012-05-11
Hello Everyone,

Quick SQL Upgrade question. Currently I have SQL 2008 running on 2 servers. They both read from the same SQL database the runs off an attached storage. Both currently are using the trial 180 day license. I have since purchased the license which is actually a download ISO and have it in both server DVD drives waiting. My question is can I upgrade the license while in production without having to stop anything? I just want to make sure I dont bring anything down while doing this as these are now in production. I just want to make sure SQL just doesnt stop working as its close to the 180 trial limit. Thanks for your answers.
Comment
Watch Question

Author

Commented:
Oh and... Is the link below the correct method on performing this update? Its not an actual upgrade correct? I really dont want to replace any files/etc. I just want the license to be valid.

http://www.sqlcoffee.com/Troubleshooting073.htm

Thanks
Rick HobbsRETIRED
CERTIFIED EXPERT
Top Expert 2006

Commented:
Yes, that is correct.  You are doing an Edition upgrade.  From the Evaluation Licensed Edition to the Permanent Licensed Edition.  Your databases will be fine but, as always, make a backup before making any changes.
Alpesh PatelSolution Architect at TCS (SAFe®Agilist, TOGAF® Foundation, PSM I®, MCP, MCSD)
CERTIFIED EXPERT

Commented:
Please go in Installation center and in Upgrade insert your product key.
Marten RuneSQL Expert/Infrastructure Architect
CERTIFIED EXPERT

Commented:

Author

Commented:
Ok just to confirm... Running this while in production wont actually stop any services or over write any files correct? Keep in mind I have 2 SQL servers that are both running from an attached SCSI host. Meaning both SQL servers are reading from the same data. I figure I still need to run this upgrade on both correct?

Thanks again.

Author

Commented:
So I am getting an error when trying to run the setup from the media. I go into the upgrade option. It runs its tests and everything says succesful. Then I hit next and it pops an error. Its a failure box that says SQL Server Setup failure.... SQL Server Setup has encountered the following error: The system cannot open the device or file specified. Then it just goes away and nothing happens. Not even anything in the event viewer. It never even gets to the point where it looks for other SQL installs.

Any ideas?
Marten RuneSQL Expert/Infrastructure Architect
CERTIFIED EXPERT

Commented:
Get another installation media. The one you use seems corrupt!

Regards Marten
Marten RuneSQL Expert/Infrastructure Architect
CERTIFIED EXPERT

Commented:
Was this issue resolved?
Please feedback

Regards Marten
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
Had to purhcase enterprise edition.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.