Activate VL key on evaluation edition (MS Server 2012 Standard)

I made a big mistake for using evaluation server software in production, I’m thinking that I can apply the proper license in a later stage, but I am absolutely wrong!!

Luckily I found an article from Technet that can upgrade an evaluation license to a full retail license, I tried this with my VL key and thank god it worked!!!!!!!!!

Here’s the link:

below is the key command.

From an elevated command prompt, determine the current edition name with the command DISM /online /Get-CurrentEdition. Make note of the edition ID, an abbreviated form of the edition name. Then run DISM /online /Set-Edition:<edition ID> /ProductKey:XXXXX-XXXXX-XXXXX-XXXXX-XXXXX /AcceptEula, providing the edition ID and a retail product key. The server will restart twice.

Excel not accumulating time field correct

When you need to add up hours in excel, you will find that it ignores the hours greater 24:00, one reason I found because of the “Time” format.  To workaround this, I found two ways of doing it.

1. If you change the “Total” cell format to “custom” with [h]:mm

2. If you change the “Total” cell format to “number”, and then multiply the total by 24

This is usually helpful when you need to do timesheet at work, especially the accountant usually deal with the labour hourly rate.

Slow opening office files

If you are like me, every day still have to deal with office 2003 or 2007, then you will surely come across this.  Some time the user complaints that it takes long time to open up a file, however it opens up perfectly fine with the guy sitting next to him… not happy user.

Give this a try if you care, this work for me.  The Microsoft article here

In summary, the office file validation is taking a long time to wait for validating the file, sometime it will even fail or time out.  If you are confident that the files they used are always from valid source, then just apply this registry hack to disable the validation.  Once disabled, the problematic files will open up fine.

keep the user happy.


Problem deploying software installation from Active Directory

I’m trying deploy Teamviewer client installation from Active Directory Group Policy, out of 120 computers only about 50 of them received from the new group policy.  After many researches, here’re the few things I found that would stop the software from installing.  (Hint: Always use GPMC.MSC or RSOP.MSC to review the result).

1.  firewall

2. slow link detection and network wait

3. disable Media Sensing feature in registry

Event ID 2017, Source SRV


After several days of backing up clients to a windows 7 machine acting as a BDR, the clients are no longer able to connect. Rebooting the BDR resolves the issue for a few days.

Looking in the System Event viewer the following entry will be shown.

Error 2017

“The server was unable to allocate from the system nonpaged pool because the server has reached the configured limit for nonpaged pool allocations.”


Windows 7 is not designed to handle the large traffic generated by backing up multiple clients.


The following registry keys can be adjusted to help windows 7 manage the high traffic.

Set the following registry key to ‘1? (default value is 0 – zero):

HKLM\SYSTEM\CurrentControlSet\Control\Session Manager\Memory Management\LargeSystemCache

Set the following registry entry to ‘3’ (default value is 1):


A restart is required after making the changes.

Windows 7 should not be used as a backup destination.  Windows 7 is a workstation OS and not intended by Microsoft to be used as a file server.

Reclaim space from your Virtual Hard Disk on VMware Workstation

I am running a Windows7 VM on a 120GB SSD, and I am running it for Internet and converting video files.  One day I noticed that the disk is about to fill up, but hang on the usage only show 70GB of usage, where is the 50GB gone??

Then I realised that it is similar to its brother software VMware vSphere, it needs to manually claim the spaces back, however in a much easier way.

I am running VMware Workstation 9, and here is the link to it’s official explanation

Select the virtual machine in the library.
From the menu bar, select VM > Manage > Clean Up Disks.

Workstation calculates how much space can be reclaimed, and either the Clean Up Now button becomes available or a message appears, explaining why the command is unavailable.

Click Clean Up Now to start the process.

A dialog box reports the progress of the clean-up process.

Once after the clean up, my host shows 70GB of usage, plenty of free spaces left again.


Creating System Image in Windows 8

Remember how you can create a system image in Windows 7, so it can be used to restore your entire system back to normal.  Since Windows 8 has moved things around, this tool is now kind of hidden from us.  Here’s the tip to find it.

Press “Windows+Q”, search for “system image,” no results come up. Search for “backup” and Windows 8 brings you to its new File History feature (which itself is pretty neat for saving copies of your files, “Previous Version” they use to call).

So where is the system image tool?  Search for “file recovery”, You will find the “Windows 7 File Recovery” link under Setting from the right side menu. It’s not a very intuitive name, because it sounds like you’d be recovering Windows 7 files, but that’s where the legacy backup tools are.

From there, you can set up a backup as you might have in Windows 7 and also find the “Create a system image” and “Create a system repair disc” options.

Choose “Create a system image” to clone your entire computer to another drive (or DVDs or a network location). Or, in the previous screen, choose to “Set up backup” and Windows will create both a system image and backup your data on a schedule. That’s the best of both worlds: you’ll have the option to recover individual files and folders (in case they’ve been accidentally deleted or overwritten) or restore the whole system (in case the whole thing crashes).



Error activating office 2003

I know what you are thinking after reading the title, but it is what I have to deal with, no other option.

Right.  Today, I’m having problems when trying to activate an office license.  When I tried to do this over the phone, it tells me that activation error at the end, and I will need to speak to one of the customer service operator.  That’s fine, this is not the first time anyway, so I waited for 10 mins… and someone from India pick up the phone.  I explained to him what I want to do, and given him the installation ID, so that he can try at his end.  unfortunately he gets the same problem, and this is where the problem starts.

He starts telling me this is a 10 years old product, it is out of warranty, he cannot help me unless I’m willing to pay $80 for technical support call.  Come on, if I’m willing to $80, I might as well going to get a new copy of office, and he did suggested that.  I tell him that I don’t want a new copy of office and I just need Microsoft to activate my software, I don’t want technical support.  This gentleman starts losing his temper, he starts putting me on hold or not speaking anything (I can hear background talking tho!).

Cut the long story short, deleting a file as shown below

  1. Click Start, click Run, type C:Documents and SettingsAll UsersApplication DataMicrosoftOfficeData, and then click OK.
  2. Right-click the Opa11.dat file, and then click Delete.

    Important Do not delete the opa11.bak file.

  3. Close the folder.
  4. Start an Office 2003 program to start the Office 2003 Activation Wizard.

This works for me, simply as this… doesn’t cost $80, doesn’t need to listen to their rubbish.