setting up Audit DB from Data source connection fails

[cognos05]

Hi ,

I am trying to connect to a sql server 2016 database from cognos data source .

I have the native client chosen and entered the credentials  along with jdbc checked .

I have the results as native client logon failed and
JDBC succeded .

Wjat does that mean can the cognos still write or read from the sql using jdbc 

How do I make the native client also work .

In the drivers of cognos installation i have sqljdbc42.jar . For native client to work should i install other drivers .

Thanks,

[MFGF]

Hi ,

I am trying to connect to a sql server 2016 database from cognos data source .

I have the native client chosen and entered the credentials  along with jdbc checked .

I have the results as native client logon failed and
JDBC succeded .

Wjat does that mean can the cognos still write or read from the sql using jdbc 

How do I make the native client also work .

In the drivers of cognos installation i have sqljdbc42.jar . For native client to work should i install other drivers .

Thanks,

Hi,

For the native client to work you need to install the SQL Server Native Client libraries on the server.

Cheers!

MF.

[cognos05]

Can you send me the download link on what exactly I should download .

[MFGF]

Can you send me the download link on what exactly I should download .

Hi,

It's part of the SQL Server install

https://docs.microsoft.com/en-us/sql/relational-databases/native-client/applications/installing-sql-server-native-client

MF.