Upgrade SQL Server Edition–SQL Server 2008 R2

There will be some incidents that you need to upgrade Existing SQL Edition to another Such as Standard to Enterprise. in my scenario I had a SharePoint Foundation Farm Installed on a SQL Express 2008 R2 and I needed to upgrade it in to Enterprise due to huge growth of Databases. finally it became crucial while giving me an error when restoring a Database of 50 GB as SQL Express 2008 R2 allowed only 10GB Max and that’s where this upgradement decided.

nothing much to do as you have got the feasibility for this on SQL installer. just take below few steps to complete you Edition upgrade.

1. Run SQL Server Installer Setup from your media.

image

2. Direct to – Maintenance –> hit on Edition Upgrade

image

3. Place License Key and click next.

Capture

4. Agree to the License Agreements here

image

5. Select the instance which you need to upgrade as below and click next.

image

6. Make sure on everything by looking at the summary and hit Next to proceed with upgrading.

image

7. Give it a moment and you will see the below result as success shortly.

image

that’s it and your instance is upgraded for selected edition and there will be no harm to Databases or any settings you have done in the instance. Enjoy !

Advertisement

Visio 2013 Custom Stencils for Specific Diagraming (Windows Server, Exchange, SharePoint, O365, Lync)

Visio is always an great product that allows you on Creating visual representations of your Microsoft Office and Office 365 architectures, including Microsoft Exchange, SharePoint, and Lync which is a helpful way to communicate your deployment.

I would say, the most beautiful product in the range. and now with 2013 version you can get more specific icons sets for specific diagraming. you can download these custom stencils which each has over 300 icons.

image

image

Exchange 2013, Lync Server 2013, and Microsoft SharePoint Server 2013 – Download

Microsoft Exchange 2013 deployments, including on-premises, hybrid, and Office 365 – Download

Change Product key in Windows 8/Server 2012

New Windows 8/Server 2012 Operating Systems doesn’t allow you to Change Product key through system properties. Only way is to change the product key is to run PowerShell CMD let.

This is how it shows at system properties. You may activate but not change the key. activating without installing a valid key wont be possible too.

clip_image001

clip_image002

So simply run PowerShell in privileged (run as admin) mode and type below lines step by step.

  1. slmgr -upk (this uninstalls the current Product Key)

clip_image003

  1. slmgr -ipk XXXX-XXXX-XXXX-XXXX (replace X’es with your Key – this installs the new Product Key) You will see below message if your key is valid with media.

clip_image004

  1. Now direct to system properties and click "Activate"

clip_image005

clip_image006

That’s it and enjoy your Genuine OS..