I have tried to download SQL Server 2005 Express edition about 4 times trying to find the correct version that has business intelligence studio and reporting services in it?
Every time I try to unhide the advanced configuration during install, it's never there...
Can anyone point me to the correct download?
Looking for 2005 (not 2008) because my work SQL server that I am trying to learn this for is 2005, and the training material I have is for 2005 and VS 2008 does not want to integrate with SQL2008 express.
[sorry if you saw my first answer, I misread your question as Integration Services...]
Reporting Services is available with SQL Express with Advanced Services. The Business Intelligence tools are available in the SQL Express Toolkit.
Both are available from the same location. Here is the link to the download page.