Delphi Prism and SQL Server Express with Advanced Services

I found a little gotcha when installing Delphi Prism after SQL Server 2008 Express with Advanced Services (and without installing another edition of Visual Studio). Here's the story...

On my (now quattro-boot) laptop, I decided to do a fresh install of Windows Server 2008 on the 4th partition. After that, I installed the Win32 parts of RAD Studio 2010, followed by SQL Server 2008 Express with Advanced Services (although I have an MSDN subscription, I sometimes need to work with SQL Server Express to be able to experience and reproduce what some of my clients work with).

After the installation of SQL Server 2008 with Advanced Services, I went on to install Delphi Prism 2010. Since the "Advanced Services" part of SQL Server 2008 included the Visual Studio 2008 Shell (for special business project for Analysis Services, Integration Services, and Reporting Services) the Delphi Prism installed found no need to do a fresh install of the Visual Studio 2008 Shell, and Delphi Prism itself installed in no time.

All was not well, unfortunately... You see, the Visual Studio 2008 Shell that was installed for the "SQL Server 2008 Express Advanced Services" did not contain a web designer. And as a result, when I used Delphi Prism to start a new ASP.NET project or site, the .aspx designer pages would remain empty!

Fortunately, the fix was easy: just go back to the Delphi Prism 2010 installation folder, into the Shell directory, and run the vside.enu.exe again to "install" (actually modify by adding the web designer) the Visual Studio 2008 shell again. This will not harm the Analysis, Integration or Reporting Services project, but help you with the ASP.NET projects that need the web designer surface.

Note that this problem will not appear if you install Delphi Prism *before* installing SQL Server 2008 with Advanced Services.

Perhaps I missed something, but I've heard of this issue before, and was finally able to "reproduce" it myself ;-)