Friday, March 9, 2012

IIS required for SQL Express Adv

I'm trying to install SQL Express Adv and it warns me I need IIS to support certain features for Reports. Despite hours of searching through the MS website, I can not figure out what features those are to determine if I want put in IIS. Furthermore, I can not even figure out how to get IIS on my system. I need to do this for my laptop, which is XP Pro 2002 SP2. I also need to do this for my desktop, which is XP Home 2002 SP2. Neither of them have IIS installed that I can tell (and according to the initial install check done by SQL Express Adv it is not installed).

XP Pro comes with IIS, but does not install it, you need to select it from the list of options in add/remove programs/add/remove windows components. XP Home does not support IIS at all, ever.

I would guess that unless you want to serve data over the web, you don't need IIS.

No comments:

Post a Comment