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

Connectivity to Microsoft Sql server through JDBC

Started by rk.justread, 17 Aug 2016 04:04:47 PM

Previous topic - Next topic

rk.justread

Hi All,

I am trying to connect to Microsoft SQL server database from Cognos 10.2 through JDBC.

I followed the instructions as per below IBM support documents

http://www.ibm.com/support/knowledgecenter/SSMR4U_10.2.1/com.ibm.swg.ba.cognos.dyn_query.10.2.1.doc/t_dqm_conn_ms_sql_srv.html
http://www-01.ibm.com/support/docview.wss?uid=swg21584451

After installing the jdbc drivers, i am trying to create a new data source from cognos administration. But i am getting an error like "XQE-DS-0006. unable to logon to the data source. the TCP/IP connection to the host <Host>, Port 1433 has failed.

IBM cognos  is 64 bit and installed in linux server.

Can any one please help me out here?

rk.justread

***RESOLVED***

I had to install the sqlserver JDBC 4.0 version as i was trying to connect with sql server 2005 database.

Now I am able to connect to sql server through JDBC connection.

Thanks,
Rk