Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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?

share|improve this question
    
What error are you getting? –  Jeff Shattock Jan 13 '10 at 0:11
add comment

3 Answers

up vote 2 down vote accepted

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.

share|improve this answer
    
How can you install SP3 if you can't install MS SQL 2005? –  Jack Jan 13 '10 at 6:00
    
Unfortunately, you can't. Like I said, you'll need to acquire SQL 2005 install media with SP3 already embedded in it. If you don't have MSDN access or like, then I think you're best bet is going to be to contact the "Microsoft Supplemental Parts team" to see about getting a new disk with the SP3 already installed. You can find their contact info here: support.microsoft.com/kb/326246 –  techie007 Jan 13 '10 at 15:24
2  
You can download SQL 2005 SP3. Run it then install SQL2005 then install SP3 again. That will install SQL 2005 on Win7. –  Jack Jan 19 '10 at 6:59
    
Thank you Jack for your last comment. Saved me after ages of frustration trying to install SQL 2005 on Win7. +1 –  kevinw Aug 14 '12 at 22:08
add comment

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.

share|improve this answer
add comment

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!

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.