COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Cognos Administration => Topic started by: david.stachon on 22 Oct 2011 01:48:05 AM

Title: Cognos 10.1.1 a JDBC connection to SQL Server - integrated security
Post by: david.stachon on 22 Oct 2011 01:48:05 AM
Hi,

I'm trying to get the JDBC connection up and going to my SQL 2008 R2 database.

...works fine with a signon, but when trying to use integrated security I'm getting:

XQE-DS-0006 Unable to logon to the data source.

This driver is not configured for integrated authentication
sqljdbc_auth (Not found in java.library.path)


Naturally, I've tried placing the sqljdbc_auth.dll (that came with the 3.0 jdbc sql server driver) in various places but with no success.

Any ideas?
Title: Re: Cognos 10.1.1 a JDBC connection to SQL Server - integrated security
Post by: bvk.cognoise on 24 Oct 2011 09:30:40 AM
Hi ,

please check below link it may helps you

http://publib.boulder.ibm.com/infocenter/cbi/v10r1m0/index.jsp?topic=%2Fcom.ibm.swg.im.cognos.c8pp_inst.10.1.0.doc%2Fc8pp_inst_id22477sbaseqryfailure.html

thanks
vamsi