I've tried several attempts to install MS SQL 2005 standard on Windows 7 Ultimate 32bit but wasn't able to.
I've turn on all the IIS6 comptiable features. I'm not sure what I'm doing wrong but is it possible to install MS SQL 2005 on Windows 7? If you have done it, can you give me the step by step?
Nov 7, 2005 - Download the Express Edition of Microsoft SQL Server 2005. SQL Server Express is a powerful and reliable data management product that.
From http://blogs.msdn.com/sqlreleaseservices/archive/2009/05/14/sql-server-on-windows-7-rc-and-windows-server-2008-r2-rc.aspx :
'All editions of SQL Server 2005 SP3 and SQL Server 2008 SP1 are supported on Windows 7 and Windows Server 2008 R2.'
'For SQL Server 2005, you need to be on SP3 to be compatible on Windows 7/WS08 R2'
Unfortunatly you'll need SQL install media that already has SP3 installed, as MS didn't introduce slipstreaming into SQL install media until 2008.
You can get MS SQL 2005 SP3 from MS here. You may be able to do something with it?
Edit:
As Jack pointed out in his comment, a trick to simplify install appears to be:
You can download SQL 2005 SP3. Run it then install SQL2005 then install SP3 again. That will install SQL 2005 on Win7.
You have to install SQLEXPR first for support to SQL Server 2005. Then install SQL Server 2005 on a 32 bit operating system, like Windows 7.
I am sure that will install properly onto your system, but it is not compatible with 64 bit operating systems.
While I had tried many times (and racked my brains!) to install SP3 first, there wasn't an existing installation of SQL Server 2005 to install over it.
So, I changed the original SQL Server 2005 installation file's Compatibility settings to run as 'Windows Server 2003' and it allowed me to install it onto Windows Server 2008 R2 SP1.
Then I installed SQL Server 2005 SP3 on top of that!