I have not done this on Windows 7, but on Windows 2003 the sequence 1) SQL 2005, 2) Visual Studio 2008 worked. Mostly.
On a newly built OS, you should not have any trouble doing these installs. At my place we found that on boxes that had a history of lots of software installed and uninstalled, the upgrade to .Net 3.5 SP1 on top of .Net 2.0 for VS 2008 failed and could not be fixed, requiring a rebuild of the box.
It may be worth installing .Net 3.5 SP1 before you install SQL 2005. The .Net install will also install .Net 2.0 and SQL 2005 works happily with this install sequence.
After you have installed SQL 2005, you should also install SQL 2005 SP3 and VS 2005 SP1 before you install VS 2008. SQL 2005 SP3 is required for any use of SQL on Windows 2008 and above, and VS 2005 SP1 is required if you want to use the SQL 2005 tools on Windows 2008 or above.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara