N/APosted on - 11/02/2011
Hi Experts ,
We are currently using Windows 2003 SP2 Enterprise servers and we need two more. However, due to budget constraints, we can’t afford to have another two servers to host our IIS websites and web services. Now, I need to know how I could configure the Microsoft cluster service in active/passive mode for the two SQL databases. I was thinking if it’s possible for us to configure the IIS on both nodes while a hardware load will be the one routing the public traffic to IIS. The set up should allow the IIS to access the SQL using asp, asmx, and aspx but not directly access the SQL server. Any help
Thanks in advance.
How I could configure the Microsoft cluster service?
To configure the Microsoft cluster service, go to the cluster administration and open it. In the console tree, select the groups folder, which the resource of the group in the SQL Server and then different groups than SQL server that can be in the SQL server group. After that go to the file menu ; choose new and click resource ; then the page of the new resource ; select the Generic service as the service type and do not change the value of the group, just click the next.
On the Possible owners page, add or remove the cluster in the resource and then click next . Add the dependencies on this page ; select the available resource and then click add ; next step go to the Generic service parameters page and enter MsDtsServer100 and click next.
On the Registry Replication page, add to the registry key to identify the location. In the registry key, simply type this code: SOFTWAREMicrosoftMicrosoft SQL Server100SSISServiceConfigFile.
Click ok and simply click finish.