Installing sql server 2005 express in windows 7

If you started with sql server 2005 express editions in your windows vista or xp operating systems, you are sure to stumble while installing sql server 2005 express in windows 7. After having long time experience of sql server 2005 express in my windows vista, I just switched to windows 7 and tried same version of express in it. But it is not supported. You get the failure message sort of:

This software is not supported in this version of operating system.

The simple solution is to acquire SQL Server 2005 Express Service Pack 3. Choose 32 bit or 64 bit version according to your machine.

The story does not finish yet. If you are looking for sql server management studio express, you again have to look for service pack 3 of sql server 2005 management studio. Get SQL Server 2005 Management Studio Express Service Pack 3 and get installed in your machine. Still don't forget to choose right version matching to your machine (32 or 64 bit).

Happy upcoming Valentine's Day!