Creating Datasource Connections: XQE-DS-0006 Unable to logon to the data source.

[IzzyB]

I'm running Cognos BI 10.2.2, with SQL Server 2012 as my Content Manager and database.

I've restored the databases using SQL Server Manager, and (after a lot of tinkering with the users on SQL, none of which seemed very effective), I'm attempting to create a datasource connection with the GOSALES sample, following these instructions: http://www.cognossource.com/installing-ibm-cognos-samples/

I've tried changing the user I test the connection with (even switching to no authentication, which makes no difference).

I've tried this: http://www-01.ibm.com/support/docview.wss?uid=swg21584451\

I'm rather new to BI and any help would be appreciated.

[cognos810]

Hello Izzyb,
Looks like you are trying to setup a JDBC connection as well as the usual Compatible Query mode. For this to succeed you will need the JDBC drivers for SQL Server in the right places. Detailed information here:
http://www-01.ibm.com/support/docview.wss?uid=swg21584451

-Cognos810

[MFGF]

I'm running Cognos BI 10.2.2, with SQL Server 2012 as my Content Manager and database.

I've restored the databases using SQL Server Manager, and (after a lot of tinkering with the users on SQL, none of which seemed very effective), I'm attempting to create a datasource connection with the GOSALES sample, following these instructions: http://www.cognossource.com/installing-ibm-cognos-samples/

I've tried changing the user I test the connection with (even switching to no authentication, which makes no difference).

I've tried this: http://www-01.ibm.com/support/docview.wss?uid=swg21584451\

I'm rather new to BI and any help would be appreciated.

The XQE error probably means it's a problem with testing the dynamic query connection? Does the compatible query connection test ok?

As Cognos810 suggests, to be able to use Dynamic Query with SQL Server, you need to copy the sqljdbc4.jar library to your Cognos install - it goes under C:\Program Files\IBM\cognos\c10_64\webapps\p2pd\WEB-INF\lib. You then need to re-start your IBM Cognos service.

Cheers!

MF.

[IzzyB]

Thanks everyone for offering to help with this, I... am bad at SQL. I needed to create a new user under 'logins' under the server, and instead I was creating a new user under 'Users' in my DB. Just a complete misreading of the directions that I was following.

Is fixed now.