Reporting Services and Vista Home Premium Edition

• scott dunn-401709

  SSC Enthusiast

  Points: 111

  More actions

  May 14, 2007 at 5:54 am

  #177958

  Hi All,

  I have a bit of a dilemma. I cannot get Reporting Services to install on  my Vista Home Premium desktop. SQL installs fine, but the option for reporting services is grayed out despite following MS's recommedations in various KB's.

  Does anyone know if this is even possible? I cannot locate anything from MS that says specifically that this version of windows doeasn't support SSRS.

  Also, does anyone know if I can upgrade to the Business edition of Vista

  (from the Home edition), if that becomes necessary?

  Thanks in advance,

  Scott

  Facts:

  I am Admin on the machine.

  All SP's and updates are installed.

  All options for IIS have been installed and enabled

  IIS is running, verified with http://localhost

  Vitals:

  Vista Home premium Edition all SP's

  SQL Server 2005  DEV edition with SP 2

  IIS 7

   

   

• Ian Yates

  SSCoach

  Points: 19738

  More actions

  May 14, 2007 at 6:40 am

  #706197

  I did a quick google search: 

  "SQL Server" "reporting services" vista "home premium"

  On the page  http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1320161&SiteID=1

  there's the entry stating

  "Note that IIS7 in Vista Home Premium does not include Windows Authentication functionality so it will not work with SSRS."

  Vista Home Premium doesn't support full IIS functionality and thus report services won't work (so several things from the google search tell me).  I believe you can upgrade from Home Premium to Business. 

  Although I've also read other pages that indicate that you could just be missing certain components of IIS and installing them via Add/Remove programs will give you what you need.  I can see how Google got you confused

  Let us know if installing ALL IIS components helps...

  Cheers

• Ian Yates

  SSCoach

  Points: 19738

  More actions

  May 14, 2007 at 6:42 am

  #706198

  For more info visit http://technet2.microsoft.com/windowsserver/en/library/86026b03-18b0-4c42-9884-5af83226e2bd1033.mspx?mfr=true

  There's a command you can run at the command-line to install all IIS components. 

• scott dunn-401709

  SSC Enthusiast

  Points: 111

  More actions

  May 14, 2007 at 6:45 am

  #706200

  Ian,

  Thanks for replying. Yes, I did install all of the IIS

  components, to no avail. I think my only alternative is to

  upgrade too the Biz version of Vista. I will post back with the results of that endeavor. I was hoping to avoid it, but I'm running out of options.

  Best,

  Scott