Installing reporting services in clustered sql server 2005 issue

  • hi,

    Iam installing Reporting services along with the database engine on clustere node.

    'In the Repor Server Installation Options' page the 2 optins are greyed out

    1.Install the default configuration

    2.Install but do not configure the server

    When I clik the Details button the messages says

    The prerequisite check failed for a default report server installation:First time install, the SQL instance is either not selected or is not a local install

    But In The System Configuration check I got no errors all prerequisites are good.

    I did not understand why both Report Srver Installation options are greyed out?

    Is this an error? or can I configure Reporting Services after the installation through Report Server Configuration manager?

    please advice me.

    Many thanks..

  • Hola,

    Maybe this help:

    "My latest project that i will be working on is to be installing and configuring SQL Reporting Services 2005 Standard Edition. I will then be making reports with already created SQL database files. It has so far taken me a week to install and configure reporting services. I originally started with trying to get reporting services to work with Sharepoint (we have Sharepoint 3.0 and MOSS 2005 installed on our 2003 Server). After deciding to try and use a database in Native mode instead of Integrated with Sharepoint I found that reporting services it self was messed up it was nothing to do with Sharepoint. Basically when i went to the reports section (http://(server-name)/reports) it would give me an error. The strange thing was that the reportserver section (http://(server-name)/reportserver) did seem to work. I uninstalled reporting services by going to “Add and Remove programs” and clicking “Change” on “SQL Server 2005.” I then picked the instance of SQL i was using and clicked “Next.” I then had the option to choose to uninstall “Reporting Services.”

    When re-installing Reporting Services the “default” install instance was grayed out with “details” as an option to see why. The details said “The prerequisite check failed for a default report server installation: First time install, the SQL instance is either not selected or is not a local install.” I continued with the install and it finished successfully. I then went to Windows Updates and found that the SQL SP2 was needing to be downloaded and installed. This seemed odd to me since I had already installed SQL SP2 a week before hand. I guess since i installed Reporting Services and it had not been patched with SQL SP2 it needed to be updated (I had thought there would be a patch I wouldn’t have thought that i needed to install the whole thing again). After installing the SQL SP2 I attempted to run SQL Reporting Service Configuration Tool since there was no report from Microsoft that i needed to reboot. I got a really nasty error. So now I am thinking the program is corrupt, AGAIN! Ok so I guess I will restart the server and see if it helps or I may just need to try again (this sucks since this is a production machine and I have to send out site wide email about rebooting before doing so). After the reboot I re-opened the config tool and ~by golly~ it worked!! Thank the Lord! "

    source: http://clarktechie.wordpress.com/category/sql-reporting-services/

    Regards

  • hi,

    could you please give me some info on this issue

  • Hi,

    could you plz any body explain me this issue...I attached the screen shot

  • You'll need to use the Reporting Services Configuration tool after the setup process is complete.

  • Thank You,

    I would like to know in which scenaro the both options will be greyed out?

    1.Install the default configuration

    2.Install but do not configure the server

    As I know that if database engine is not selected while installation,the seccond option will be availble and if we choose database engine too it will show us both options But in which case it will greyed out both options?

    could you plz explain me this

    Thanks

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

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