July 13, 2006 at 11:08 am
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
Kunal Gandre
>
Snr. SQL DBA
July 15, 2006 at 6:32 pm
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
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