So, if like me, you wanted to look at SQL 2008, and thought it best to totally remove 2005, and then install 2008 (Katmai), then realising that the Katmai BI tools did not install properly, you may want to re-install 2005.
If have got to this stage you may have found and annoying installation bug, even after removing 2008. This is regarding the SQL Native Client. It fails to install and therefore most of SQL 2005 fails to install. After numerous more efforts to install this there is a simple fix.
From the SQL 2005 disc, run Sqlncli.msi
– Choose remove, repair doesn’t work!
– Once removed install SQL server 2005 as normal – easy – when you know how!