I'm trying to connect to MSSQL clsuter datasource. When one of the cluster node goes down, Cognos is unable to automatically connect to datasource on other node. I need to restart the service.
My question: is there any document that gives steps to connect MSSQL clustered datasource ?
I could be wrong but my understanding is that a cluster presents a single logical view of an instance. So if you have 2 nodes, when one node goes down, the backup node fails over to maintain service. Therefore you should only have one Cognos data source for the cluster. If this isn't working, I would investigate SQL Server itself.