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:
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.
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.
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.)
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.
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.
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.
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)
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)
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.