Need Help on Cognos 10.2.1 SQL Server 2012 as data source .
Currently cognos Env is running on oracle DB content store and data source. trying to new DB SQL Server datasource
I am getting attached pic error using SQL Server Name account
please guide how to slove the issue
Here's some suggestions to get you started.
Click on the blue failed button. Take note of the contents which pop up. Search for information using that and the qe-def error.
I'm assuming you have installed and configured the necessary sql server stuff for compatible mode.
Here's some links. There's also the install and configuration guide.
https://www.ibm.com/support/knowledgecenter/en/SSEP7J_10.2.2/com.ibm.swg.ba.cognos.inst_cr_winux.10.2.2.doc/c_rptconnsingle.html
http://www-01.ibm.com/support/docview.wss?uid=swg21980564&aid=1
The good news is that your dqm connection works. Is there any particular reason why you need both compatible and DQM?