Why you can’t install Microsoft SQL Server 2005

If you see “SQL Server Database Services” grayed out, do not proceed with the installation. There’s some good reasons why it is grayed out. I am running Windows Vista Business Edition and am trying to install Microsoft SQL Server 2005 Enterprise Edition.

Can’t install Enterprise Edition in non-server version of Windows

The first problem is due to the fact that you cannot install Enterprise Edition into a non-server Windows operating system as stated here. That means to say that Enterprise Edition can only be installed in Windows 2000, Windows 2003 and Windows 2008. If you are using any other operating system, it is likely you are looking for Microsoft SQL Server 2005 Developer Edition or Standard Edition.

Required components of IIS 7 not fully installed

The second problem that I face is SQL Server 2005 complaining that I do not have IIS installed when I already done that. This is because you require the following components installed (their folders and in brackets):

  • Static Content (Common HTTP Features)
  • Default Document (Common HTTP Features)
  • HTTP Redirection (Common HTTP Features)
  • Directory Browsing (Common HTTP Features)
  • ASP.Net (Application Development)
  • ISAPI Extension (Application Development)
  • ISAPI Filters (Application Development)
  • Windows Authentication (Security)
  • IIS Metabase (Management Tools)
  • IIS 6 WMI (Management Tools)

I highlighted the requirements in red for your convenience:

Required IIS components for Microsoft SQL Server 2005
Required IIS components for Microsoft SQL Server 2005

Further information of required components can be found here.

Now after you install Microsoft SQL Server 2005 Whatever Edition, make sure you run Windows Update or download any Service Pack that they offer. This would ensure compatibility to your operating system. I hope that helps. This problem annoyed me whole day.

How to use sendmail in XAMPP for Windows using AOL Mail

The easiest way to start developing in PHP is to get XAMPP, the whole package can even be placed in a flash drive. Using the free AOL Mail account also allows you to sign in to the SMTP server without TLS which allows XAMPP sendmail to work.

0. Objective

To get your PHP scripts to send an email out. This guide assumes you have XAMPP or XAMPP Lite. My environment is Windows Vista. (I use XAMPP Lite by the way.)

My XAMPP is placed in C:xampplite, so your configuration may be a little different. The files to be modified are sendmail.ini and php.ini. Continue reading “How to use sendmail in XAMPP for Windows using AOL Mail”

4 Gb RAM is a significant improvement

I never regret getting an additional 2 Gb for my memory, the improvement is significant and it delights me when applications launches quicker. I noticed the improved performance in applications such as Firefox and Photoshop. There’s a slight improvement in iTunes too I think, yes, that piece of crap.

The difference is less obvious in Windows 7 which already is pretty quick.

How to run XAMPP’s PHP CLI and CakePHP console

XAMPP is one of the easiest options to develop using PHP or PHP CLI. I use CakePHP for development and one of the features of CakePHP is to back the MVC. In this guide, we’ll see how to get started. This tutorial doesn’t teach you how to use CakePHP’s bake feature. This guide is specifically written for Windows Vista or Windows 7.

0. Objective

To run XAMPP’s PHP CLI, you first have to set up the environment variables for PHP CLI. Also introduce how to get started on CakePHP’s console.

1. Setting up environment variables

Continue reading “How to run XAMPP’s PHP CLI and CakePHP console”

KDE 4.2 looks like Vista just 2x ugly

KDE 4.2 is released but I still think it’s ugly. KDE supposed to resemble Windows’s GUI I think but it clone it rather uninspiringly.

KDE 4.2 looks like Vista just twice as ugly
KDE 4.2 looks like Vista just twice as ugly

Oh now it has the wobbly effect thing too:

Well you can read more on KDE 4.2’s announcement here if you’re interested.

Screenshot of Windows 7’s new calculator Programmer mode

Here’s the calculator in Windows 7. It’s got 4 modes, basic, scientific, programmer and statistics:

Windows 7 calculator different modes

(The different modes of Windows 7 calculator.)

I don’t know why there is “programmer” in the list. I thought “Programming” would probably be a better choice. Better yet:

  1. Normal human
  2. Scientist
  3. Programmer
  4. Statistician

This is how the normal human calculator looks like:

Windows 7 calculator basic

(Windows 7 calculator basic.)

Nothing new here for scientists. It just looks prettier but I add the impression that scientist don’t like pretty things.

Windows 7 calculator scientific

(Windows 7 calculator scientific.)

The new “Programmer” mode. Displays 64 bits nicely for you:

Windows 7 calculator programmer

(Windows 7 calculator programmer.)

And for the statistician, I am apparently not a statistician, I don’t know what I did to get the value. Perhaps someone can enlighten me what the orange-lit button meant:

Windows 7 calculator statistics

(Windows 7 calculator statistics.)

It makes me happy to see the Windows 7 calculator. It’s an improvement from the age old Windows calculator design.

I went to try Windows 7 Beta

I was going to totally ignore Windows 7 till it is released but I couldn’t resist anything that is marketed to be with the words “faster”, “stable” and yeah basically “faster”. I mean who could resist “faster”. Henceforth, I grant my fingers the liberty to click around and downloaded Windows 7 64-bit. And burnt. And installed. And played. Windows 7 is the yet to be released operating system from Microsoft.

I thought this is be a good time I try if the software I use would work in 64 bit. It did. Well accept a lame anti-virus software but that’s okay. Some software didn’t work on Windows 7 because it requires Windows Vista unfortunately.

I basically want to see these programs running:

  • Java (64 bit)
  • NetBeans
  • XAMPP (I couldn’t get 1.7.0 to work out of my download, perhaps my download is corrupted. But I downloaded xampplite 1.6.8 and it’s runs fine in Windows 7)
  • Microsoft Office 2007 (My guess is that it will run since it’s from Microsoft)
  • Photoshop CS4. (Yes, but I downloaded the 32-bit one. The 64-bit one probably would work too)
  • Notepad++ (I need this.)
  • Windows Live Messenger 2009 (It worked)
  • ESET Anti-virus (I downloaded the 64-bit one)
  • Dropbox (A must have)
  • Live Mesh

The great news is that all of the programs I tried to install actually worked just like that. Live Mesh did not work right and went to disable Windows Aero but a later update has that issue fixed.

But after I played with it, I’m back to using Vista. Most of my school and work stuff is all back in Windows Vista. I probably would migrate to Windows 7 when the operating system has been released. So far, I am very pleased with the new software. It also boost my confidence in 64-bit software. If not for my Windows Vista having so much of my user settings customized, I would have switched to Windows 7. I felt it was indeed, as advertised, faster. There are lots of subtle improvements to the interface too. I probably blog about it some time later next week.

How to use sendmail in XAMPP for Windows

The easiest way to start developing in PHP is to get XAMPP, the whole package can even be placed in a flash drive.

0. Objective

To get your PHP scripts to send an email out. This guide assumes you have XAMPP or XAMPP Lite. My environment is Windows Vista. (I use XAMPP Lite by the way)

My XAMPP is placed in C:xampp, so your configuration may be a little different. The files to be modified are sendmail.ini and php.ini.

1. Modify your sendmail.ini

Your sendmail.ini should be located in C:xamppsendmailsendmail.ini. You only need to be concern with 3 variables here: Continue reading “How to use sendmail in XAMPP for Windows”