Post reply

Reporting Services + IIS Installation on a Clustered Database Server 2003

  • July 13, 2006 at 11:08 am

    #169594

    Hi,

    I have a 4 node Cluster. I installed 4 Virtual SQL Instances. I created 4 Resources. Each resource containing 1 specific instance, disk drives and Agent and Full text search. I need to install Reporting services for 1 instance ( which can be moved to any of the Nodes ). Means i need to install Reporting services on all the 4 nodes.

    I installed IIS6.0 on windows 2003 on all the 4 nodes. I setup the following also on each Node.(Its one of the prerequisite for Reporting Services )

    C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322>aspnet_regiis -i

    Start installing ASP.NET (1.1.4322.0).

    Finished installing ASP.NET (1.1.4322.0).

    After doing this much.........I created a generic resource to use the clusweb.vbs script for the IIS -WEB and added it to the Resource on which I installed the 2 reporting databases.

    Is this is right way of going about having IIS+Reporting Services Setup+ Cluster 2003 ??

    Thanks,

    - Kunal Gandre

    Kindest Regards,

    Kunal Gandre
    >
    Snr. SQL DBA

  • July 15, 2006 at 6:32 pm

    #649423

    Got it !

    The Design is bad. Actually this kind of configuration is not possible in an Active Passive clustered environment. The correct way of doing it without having to get involved in additional licencing is :-

    Install the Report Server on the Webserver Farm AND point to the Virtual SQL Instance ( where 2 databases are created ). Then insall the same setup on Node 2 of the Webserver and add it to the Reporting SERVICES web farm. Repeat this on all the Nodes in the webserver pointing to the same Instance name.

    Thanks,

    Kunal Gandre

    Kindest Regards,

    Kunal Gandre
    >
    Snr. SQL DBA

Viewing 2 posts - 1 through 1 (of 1 total)

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