If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Datasource on MSSQL cluster

Started by skinger, 27 May 2011 03:34:20 AM

Previous topic - Next topic

skinger

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 ?

technomorph

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.