Installing WordPress using Microsoft Web Platform Installer (Web PI) v2.0

Microsoft Web Platform Installer (Web PI) is a free tool that makes getting the latest components of the Microsoft Web Platform easy. This includes the latest Visual Web Developer 2010 Express, ASP.NET 4, and ASP.NET MVC2.

Web PI can also be used to download open source projects which works on PHP and MySQL. Web PI will guide you throughout the process of downloading, installing, and configuring all software that are required. Following are some screen captures, showing how easy it will be to download and install the popular publishing platform [ WordPress ] with just a few clicks!

Firstly, you will need to logon to your Windows operating system using an administrative account. This could be Windows 7, Windows Vista, Windows XP SP2+, Windows Server 2003 SP1+, Windows Server 2008, and Windows Server 2008 R2.

Then, download and execute Web PI that can be found at
Here’s how Web Platform Installer v2.0 looks like.


Choose [WordPress], and press [Install]. Web PI will proceed to detect 3rd-party applications that need to be downloaded (PHP, MySQL, WordPress), and the Microsoft products and components that need to be installed and configured (IIS).

As MySQL will need to be installed in order to support WordPress, Web PI will prompt for the root password of MySQL.

Press [Continue], and the installation starts. Web PI will download, install, and configure all of the software for you!

Web PI will then prompt for the site information for setting up an IIS web site.
(You will need to grant appropriate permission for IIS to access the folder as specified in the ‘physical path’.)
(Your should absolutely have a different Web site setting!)

And the next step is MySQL database settings.


It’s that easy! Go, and give it a try!

===== For more information =====

~ Microsoft Web Platform Installer 2.0

~ Microsoft Web Platform Installer: The Official Microsoft IIS Site

~ WordPress


Addicted to Ctrl + <comma> in Visual Studio 2010

The keystrokes [ Ctrl + <comma> ] in Visual Studio 2010 is used to navigate to your line of interest! … and, you should soon forget about what [ Ctrl + F ] is, after using [ Ctrl + <comma> ] !!

Suppose that you need to search for the string ‘ConnectToSqlDatabase’ in your solution, you can press [ Ctrl + <comma> ], and the [ Navigate To ] dialog pops up.
Typing ‘Con’ for the search terms, and…

What happened here is that the number of matching results are decreased as I type ‘Con’ character by character.
You can then click on a matching result, and jump to the line of source code that matches the search term.

Another useful feature is that [ Navigate To ] also recognize search terms in Pascal Case!
Suppose that you do not know whether the function is called [ Connect…(something)…SqlDatabase ], or is called [ Change…(something)…SqlDatabase ], but you know that they both have pascal case ‘CSD’…

And, pascal case is not just limited to Intellisense, but also for the search terms in the [ Navigate To ] feature…. ( Ctrl + <comma> )

So, may I ‘also’ forget about [ Ctrl + F ] even when I am using Microsoft Office… some day?
… Just joking, of course   🙂


Cannot insert explicit value for identity column in table ‘MyTable’ when IDENTITY_INSERT is set to OFF

When you try to insert data into a table with an IDENTITY column, the following error message may be returned.


Cannot insert explicit value for identity column in table ‘MyTable’ when IDENTITY_INSERT is set to OFF.


You will need to enable IDENTITY_INSERT, using the following statement.





(Id, Name)

VALUES (123, ‘My name is Martin’)


— Be reminded to reset IDENTITY_INSERT



=== For more information ===


SQL Server Configuration Manager – Cannot connect to WMI provider – Invalid class [0x80041010]

When I am trying to connect to my SQL Server 2008 box using SQL Server Configuration Manager today, the following error dialog pops up…

Cannot connect to WMI provider. You do not have permission or the server is unreachable. Note that you can only manage SQL Server 2005 and later servers with SQL Server Configuration Manager. Invalid class [0x80041010]

Cannot connect to WMI provider. You do not have permission or the server is unreachable. Note that you can only manage SQL Server 2005 and later servers with SQL Server Configuration Manager. Invalid class [0x80041010]


I have never seen this before!… while the following line saves me.

>> Open an elevated Command Prompt, and type the following…

mofcomp.exe "C:\Program Files (x86)\Microsoft SQL Server\100\Shared\sqlmgmproviderxpsp2up.mof"

mofcomp "C:\Program Files (x86)\Microsoft SQL Server\100\Shared\sqlmgmproviderxpsp2up.mof" 


===== For more information =====

~ SQL Server 2005 WMI Provider Error

~ April SQLExpress CTP Installation fails with error 29535 (WMI not configured properly)

Windows 7 Application Compatibility: Your Questions Answered (Part 1) – Springboard Series Virtual Roundtable

Date: Thursday, June 18th, Thursday
Time: 11:00am Pacific Time

Or, 2:00am Hong Kong Time on June 19th, Friday

Windows 7, is approaching fast and from the application standpoint is very similar to Windows Vista. We are going to examine Windows 7 application compatibility not only from the perspective of moving from Windows Vista, but also for those coming from Windows XP. Join us to discuss the most common challenges around application compatibility when coming from a legacy operating system, why changes were made along the way, compatibility technologies inside the OS and methods for getting incompatible applications to run on Windows 7. Along the way we share tips and tricks, demonstrate free tools to analyze and fix applications and answer your specific questions about application compatibility live.

In Part 2 of this Virtual Round Table discussion (planned for later this Summer/Fall), we will discuss the options and approaches for using virtualization tools In depth to address application incompatibilities, including presentation virtualization, desktop virtualization and application virtualization. We will be sending out more details and posting information to for part 2 as the dates are finalized.

Find answers to your Windows client OS deployment and management questions with resources, tools, monthly feature articles, and guidance from subject matter experts and early adopters. To learn more, visit

As part of the Virtual experience, you may submit your questions about Windows 7 Beta to the panel live during the event, or submit questions in advance to

Springboard Series: The resource for Windows desktop IT professionals

Windows Live Mail Error ID: 0x800C0148; Protocol: SMTP; Port: 0; Secure (SSL): No <— error prompts in Windows Live Mail after installation of IE8

After the installation of Internet Explorer 8 on my Windows Server 2008 (64-bit), my Windows Live Mail starts to prompt the following error, while the mail folders sometimes disappear.

===== Error =====

(Some errors occurred while processing the requested tasks. Please review the list of errors below for more details.)

An unknown error has occurred.

Windows Live Mail Error ID: 0x800C0148

Protocol: SMTP

Port: 0

Secure (SSL): No


And sometimes, the error dialog just pop up without stating specific error!


===== Solution =====

[1] The {Port: 0} error in Windows Live Mail usually relates to anti-virus application, and thus, I tried to disable the email scanning feature of my anti-virus application… but, this cannot resolve the problem.

[2] I suspect that some of the registered interfaces of the DLL files are corrupted. I used REGSVR32 to register them again, and this seems to have resolved the problem. I do not know exactly which DLL is required this time, while here comes my list of REGSVR32 *.DLL…

regsvr32 actxprxy.dll
regsvr32 oleaut32.dll
regsvr32 urlmon.dll
regsvr32 jscript.dll
regsvr32 vbscript.dll

===== For more information =====

~ [Open in New Windows] and [Open in New Tab] commands do not work in IE8

SSMS – Unable to cast COM object of type ‘System.__ComObject’ to interface type ‘Microsoft .VisualStudio .OLE .Interop .IServiceProvider’. Exception from HRESULT: 0x80004002 (E_NOINTERFACE))

I am working on Windows Server 2008 SP1 Datacenter Edition 64-bit, with SQL Server 2008 installed.

After installing Windows IE8, I got the following error upon starting SQL Server Management Studio (SSMS) 2008.

===== Error 0x80004002 =====

SSMS – Unable to cast COM object of type ‘System.__ComObject’ to interface type ‘Microsoft.VisualStudio.OLE.Interop.IServiceProvider’. This operation failed because the QueryInterface call on the COM component for the interface with IID ‘{6D5140C1-7436-11CE-8034-00AA006009FA}’ failed due to the following error: No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE)). (Microsoft.VisualStudio.OLE.Interop)


===== Solution =====

After a bit of investigation, I found that the registry is somehow corrupted, and the solution is to re-register DLL.

~ Run [ Command Prompt ] (You will need to use the **Run as administrator** option)

~ regsvr32 actxprxy.dll

===== For more information =====

~ SSMS Object Explorer/Server Explorer Error

~ Windows Internet Explorer 8

The module “actxprxy.dll” was loaded but the call to DllRegisterServer failed with error code 0x80070005

The module “actxprxy.dll” was loaded but the call to DllRegisterServer failed with error code 0x80070005.


===== Solution =====

Most probably, what you are trying to do is [ regsvr32 actxprxy.dll ].

For doing this, you will need to use a command prompt that is executed as administrator. So, grab your mouse… and

~ Right-click on the command prompt icon

~ Select [ Run as administrator ]

You may be prompted for administrator credential.