Reporting Services option greyed out in installation - sql server 2005

Question

Reporting Services option greyed out in installation - sql server 2005

rossfgalbraith

SSC Veteran

Points: 223
More actions
December 8, 2010 at 5:57 am

#228302

Hello,
I am trying to install reporting services on my computer but the option is greyed out in the installation. This is within SQL Server 2005. When running through the pre-installation checklist it is saying that IIS is not installed but I did install it and included all the extra IIS features that I could find. I am using Windows 7 home premium, not sure if this is an issue.
Any help would be appreciated.
Ross.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Arunkumar S P SSCertifiable Points: 6415 More actions · Answer 1

Hi ross,

If Reportingservices is greyed out then main reason for that is IIS. Browse your default website and check whether IIS is properly installed or not

-----------------------------------------------------------------------------------------------------------------------------------------------------------
Please feel free to let me know if you are not clear or I’ve misunderstood anything.

Thanks,
Arunkumar S P

rossfgalbraith SSC Veteran Points: 223 More actions · Answer 2

Hi Arunkumar,

The IIS Management tool is installed. I also created a basic default.htm file and placed it in the wwwroot folder, then typed the url http://localhost/ and it displayed the contents of default.htm correctly. I assume this means IIS is installed??

Kind regards,

Ross.

Gift Peddie SSC Guru Points: 73570 More actions · Answer 3

rossfgalbraith (12/8/2010)
Hello,
I am trying to install reporting services on my computer but the option is greyed out in the installation. This is within SQL Server 2005. When running through the pre-installation checklist it is saying that IIS is not installed but I did install it and included all the extra IIS features that I could find. I am using Windows 7 home premium, not sure if this is an issue.
Any help would be appreciated.
Ross.

The short answer is no, you cannot run SSRS 2005 in any home premium operating system because IIS7 in Vista and IIS7.5 in Windows 7 comes without Windows authentication which is required in SSRS 2005 installation. The long answer check the link in the thread below for a work around using SSRS 2008 with SQL Server 2005 relational engine. Post again if you still need help.

http://www.sqlservercentral.com/Forums/Topic754296-150-1.aspx

Kind regards,
Gift Peddie

rossfgalbraith SSC Veteran Points: 223 More actions · Answer 4

Hi Gift Peddie,

Thanks for your post. Good to know it isn't just me. I don't have SSRS 2008 unfortunately so will have to try another angle.

Ross.