Nvivo- server projects only on Traditional Chinese Win 7 OS? SQL Server 2008 R2 error

(READ ME FIRST: Got a comment from Nvivo helpdesk to stating that they will be happy to help anyone resolve issues alike.  Please read the comment from Rahul first. Updated on Aug. 13th, 2012)

Got Nvivo 10 installed on a Windows 7 x64 machine but realized that only the server projects are available. In other words, the stand alone file type was not available.

Not too helpful since I've got no server to connect to and I need da stand alone project option.

Apparently, the experts found that it is related to the issue installing SQL Server 2008 R2.

So, like a good girl, I went and found SQL server 2008 R2 Express to have it installed on the machine.  Made sure Microsoft .Net Framework 3.5 SP1 and above is installed also on the machine and realized that SQL server 2005 and above is installed on the machine.

Except for... oopsy... this guy kept on giving me this error message of "Performance registry hive consistency" failure, which got the installation process stuck.

Apparently, you have to play with the registry to get the issue resolved... Though I don't particular fancy playing with the registry keys, I back all data up on the machine...

After hours of error, error, error... and going no where...

I think the following finally got it to work...

(BTW, apparently, other people were able to export the 009 subkey, save it as 004, and easily gets it imported as 004.  Unfortunately, didn't work for me somehow.)

Create under perflib the subkey 004 if the issue is on the traditional Chinese version of win OS HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\WindowsNT\CurrentVersion\Perflib\004

Create the following two registry entries of the "Multi-String type" (Multi-String Value)

1. Counter
2. Help

(Please be reminded that although the locale ID for Chinese - Taiwan is 0404, 004 is the value to use.  If you have OS in other languages, you would have to figure out the correct locale id to use since the 0404 listed didn't work for me.)

In the next step, you have to figure out the values of the last counter and last help by clicking on counter and help registry entries of either the 009 or current language subkey.  In case you are airhead like me... last counter means the last item listed for the counter registry entry and last help means the last item listed under the Help registry entry. 8-O lol 

Figure out the value of last counter, which seems to be 2178 (decimal)

Figure out the value of last help, which seems to be 2179 (decimal)

Check the value of last counter and last help under perflib 

Change the value of Last Counter to 2178 (decimal)

Change the value of last help to 2179 (decimal)

Voila, problem solved!  After the "Performance registry hive consistency" failure was resolved, you might have to uninstalled the copy of SQL server 2008 R2 Express that didn't get installed successfully before before having to have it installed again.

Once SQL server 2008 R2 Express got installed successfully, the installation of Nvivo should go smoothly and you will have the standalone project option as well.

Bon chance!

• http://blogs.msdn.com/b/joaol/archive/2008/12/18/sql-server-2008-performance-counters-registry-hive-consistency-fails-on-non-english-operating-systems.aspx
• http://support.microsoft.com/kb/976231