Installing SQL 2005 on Vista or Windows 2008:

There have been some installations with sql 2005 without sql 2005 reporting services due to not adding some components in windows 2008 or vista.

Installing SQL 2005 on Vista or Windows 2008:

And any installs on Windows 2008 Server or Vista PCs won’t install reporting services 2005 unless you make sure you have added all the required internet components, not just IIS7.

You need IIS 6 compatibility, plus a lot of other components so read this article:

http://support.microsoft.com/kb/934164

You need to run the install as admin.

Install SQL server 2005 then the Sql Server 2005 sp2 and then the vista provisioning tool and Visual Studio sp1.

** All fun but easier than the alternative to uninstalling and then do the steps above and then re-attaching all databases….just because an install missed one step.