Category Archives: 2557

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 http://www.Microsoft.com/web/downloads/platform.aspx
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
http://www.microsoft.com/web/downloads/platform.aspx

~ Microsoft Web Platform Installer: The Official Microsoft IIS Site
http://www.iis.net/webpi


~ WordPress
http://wordpress.org


 

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

http://blogs.msdn.com/echarran/archive/2006/01/03/509061.aspx

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

http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=124587

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)

image

===== 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

http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/d5d3e5fc-d8ce-4f42-b7ea-9bbbb7756a20/

~ Windows Internet Explorer 8

http://www.microsoft.com/ie8

SSIS – Converting string / numeric (yyyymmdd and hhmmss) to datetime inside Derived Column Transformation Editor

It takes me some time to figure out how a string / numeric value can be converted to a datetime value inside the Derived Column Transformation Editor of SSIS, and so, I would like to share my $0.20 here (in order to save others’ $0.20).   :)

Here, the original TradeDate (e.g., 20090316) and TradeTime (e.g., 230533) are numeric values.

 

This one returns a datetime value with TradeDate only.

(DT_DBTIMESTAMP)(SUBSTRING((DT_WSTR,8)TradeDate,1,4) + "-" + SUBSTRING((DT_WSTR,8)TradeDate,5,2) + "-" + SUBSTRING((DT_WSTR,8)TradeDate,7,2))

 

And here’s how I obtain the datetime value including both TradeDate and TradeTime. I intentionally use the function DATEADD() to add hour, minute, and second to TradeTime.

DATEADD("ss", TradeTime – ROUND(TradeTime / 100, 0) * 100, DATEADD("mi", ROUND(TradeTime / 100, 0) – ROUND(TradeTime / 10000, 0) * 100, DATEADD("Hh", ROUND(TradeTime / 10000, 0), (DT_DBTIMESTAMP)(SUBSTRING((DT_WSTR,8)TradeDate,1,4) + "-" + SUBSTRING((DT_WSTR,8)TradeDate,5,2) + "-" + SUBSTRING((DT_WSTR,8)TradeDate,7,2)))))

 

You may also concatenate both TradeDate and TradeTime into a string that can be read by DT_DBTIMESTAMP.

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

~ SQL Server Product Samples: SSIS

http://www.codeplex.com/MSFTISProdSamples/Wiki/View.aspx?title=SS2008!Execute%20SQL%20Statements%20in%20a%20Loop%20Sample%20Package&referringTitle=Home

~ Converting Strings to Dates in the Derived Column Component

http://toddmcdermid.blogspot.com/2008/11/converting-strings-to-dates-in-derived.html

Microsoft Certification Exam – 10% discount voucher

Great news – Microsoft is offering self-paced, eLearning collections to you when you sign up for the Certification Campaign using the code HKEBA99B. You will enjoy a eLearning collection at US$35 for a 90-days use. This is a great resource for those who prefers self-paced learning option. To sign-up, go to www.learnANDcertify.com by March 31, 2009 and key in HKEBA99B (this exam voucher code is valid in Hong Kong only) to obtain a 10% discount on your next Microsoft Certification Exam plus free retake if you fail plus the US$35 offer on eLearning. You will receive an email with the exam voucher code and a eLearning Promotion Code. Both offers will be valid till June 30, 2009. Happy Certifying…

 

Offer Details:

The certification promotion code ( HKEBA99B ) can only be used in Hong Kong.

The Offer is valid for a Microsoft Certified Technical Specialist (MCTS), Microsoft Certified IT Professional (MCITP) or Microsoft Certified Professional Developer (MCPD) exams. Not valid for Academic Exams.

Refer to the following links for applicable exams :
http://www.microsoft.com/learning/mcp/mcts/default.mspx
http://www.microsoft.com/learning/mcp/mcitp/default.mspx
http://www.microsoft.com/learning/mcp/mcpd/default.mspx

Exam candidates must request an Exam Offer Voucher Code using the unique MVP Certification Promotion Code by March 31, 2009 via www.learnandcertify.com.

To receive a 10% discount on the cost of an applicable Microsoft Certification exam, exam candidates must use the Exam Offer Voucher Code provided by an MVP when they register for an exam and sit for an exam by May 31, 2009.

Limited to one (1) exam at 10% discount with a free retake (if necessary) per individual. Both exams must be taken by May 31, 2009.

The Exam Offer Voucher Code may not be combined with other vouchers or discounts and are void if altered or revised in any way.

Refer to http://learnandcertify.com/Terms.aspx for complete Terms & Conditions of Exam Voucher usage.

Upgrade and migration to SQL Server 2008 webcast

SQL Server 2008 is released, and you are invited to join this webcast that highlights the tools and procedures to make your move to SQL Server 2008 easy and troublefree.

*** For more information

~ Upgrade and migration to SQL Server 2008 webcast

http://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032384669&EventCategory=3&culture=en-US&CountryCode=US

~ SQL Server 2008 is available for download for MSDN subscribers

https://msdn.microsoft.com/en-us/subscriptions

Microsoft SQL Server 2008 { JumpStart }… your data, any time, any place

Microsoft SQL Server 2008 { JumpStart } @ http://sqlserver2008jumpstart.microsofttraining.com 


This site contains presentations, recordings, hands-on labs and demonstrations for the SQL Server 2008 JumpStart technical training event, while there are 5 tracks in this event: <!– Overview Sessions, Database Infrastructure and Scalability, Business Intelligence Part I & II, Developer & Software + Services, and Application Compatibility & Upgrade. –>Overview Sessions, Database Infrastructure and Scalability, Business Intelligence Part I & II, Developer & Software + Services, and Application Compatibility & Upgrade

Writing the first SQL Server database .NET application

Just listing a few getting-started links for developing SQL Server .NET application.

~ SQL Server 2005 Express Edition – Sample Rich Client and Web Applications
http://msdn2.microsoft.com/en-us/express/bb403187.aspx

~ SQL Server 2005 Express Edition – Samples and Starter Kits
http://msdn2.microsoft.com/en-us/express/aa718396.aspx

~ “How Do I” Videos – ASP.NET
http://msdn2.microsoft.com/en-us/asp.net/bb498194.aspx

~ “How Do I” Videos – Visual Basic
http://msdn2.microsoft.com/en-us/vbasic/bb466226.aspx

~ Hitchhiker’s Guide to Visual Studio and SQL Server: Best Practice Architectures and Examples (7th Edition)
http://www.amazon.com/Hitchhikers-Guide-Visual-Studio-Server/dp/0321243625
http://www.betav.com

~ LearnVisualStudio.NET
http://www.learnvisualstudio.net

~ Free basic training for SQL Server
http://blogs.msdn.com/buckwoody/archive/2008/07/17/free-basic-training-for-sql-server.aspx

Installing Components… Full Installation of Visual Studio 2008 Professional Edition

Just got the *full* installation of Visual Studio 2008 Professional Edition done on an Vista Ultimate box (x64), and, here is the …long… list of components that are installed!


- Runtime Pre-requisites
- Microsoft .NET Framework v3.5 (x64)
- Microsoft Visual Studio 2008 64bit Prerequisites (x64)
- Microsoft Document Explorer 2008
- Microsoft Visual Studio Web Authoring Component
- Microsoft Visual Studio 2008
- Microsoft .NET Compact Framework 2.0 SP2
- Microsoft .NET Compact Framework 3.5
- Microsoft Visual Studio Tools for the Microsoft Office system (version 3.0 Runtime)
- Microsoft Visual Studio 2005 Tools for the 2007 Microsoft Office System Runtime
- Microsoft SQL Server Compact 3.5
- Microsoft SQL Server Compact 3.5 Design Tools
- Microsoft SQL Server Compact 3.5 For Devices
- Windows Mobile 5.0 SDK R2 for Pocket PC
- Windows Mobile 5.0 SDK R2 for Smartphone
- Microsoft Device Emulator version 3.0 (x64)
- Microsoft SQL Server 2005 Express Edition
- Microsoft Visual Studio 2008 Remote Debugger (x64)
- Crystal Reports Basic for Visual Studio 2008
- Crystal Reports Basic 64-Bit Runtime for Visual Studio 2008
- Microsoft Windows SDK for Visual Studio 2008 Tools (x64)
- Microsoft Windows SDK for Visual Studio 2008 Headers and Libraries (x64)
- Microsoft Windows SDK for Visual Studio 2008 Win32 Tools (x64)
- Microsoft Windows SDK for Visual Studio 2008 .NET Framework Tools (x64)
- Microsoft Windows SDK for Visual Studio 2008 SDK Reference Assemblies and IntelliSense (x64)
- Microsoft SQL Publishing Wizard