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.

  • thanks very much. i think my hang up with reporting services may be due to an error I am getting when sql server install scans my computer's config and finds that I do not have IIS installed or it is not enabled. would this be something that comes with sql server anyway?? how would i enable it if i do have it? where do i find IIS in the control panel. thanks! – Justin Jan 24 '10 at 3:59
  • Yeah, that's probably your problem. Reporting services relies on IIS. IIS doesn't come with SQL. You have to install it separately, but it is available for any version of Windows (workstation or server editions). What are you running SQL Express on? You have to add it via Windows Components, which you get to differently depending on what version of Windows you have. – squillman Jan 24 '10 at 4:03
  • I am running all above on my home computer, just because I am trying to learn as much as I can about it all ASAP, since my work just made me the unpofficial DBA until they get someone. So I am enjoying this actually. Windows Vista. – Justin Jan 24 '10 at 4:06
  • know where I can find that?? thanks for your help SQUILLMAN! much appreciated! – Justin Jan 24 '10 at 4:07
  • No problem! Here's a link for a good looking tutorial on installing IIS on Vista: learn.iis.net/page.aspx/28/… – squillman Jan 24 '10 at 4:09

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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