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

Audit Database not capturing Logs in SQL Server 2012

Started by fry, 29 Jun 2013 12:19:12 PM

Previous topic - Next topic

fry

Good Afternoon


I was able to create a SQL Server 2012 DB called CognosLogDB and apply sqljdbc4.jar and sqljdbc_auth.dlll in the appropriate cognos directories for JDBC. I created in Cognos Configuration, under logging the connection, which I am able to validate.

When I restarted the services, the tables were not created in the DB. I manually ran the scripts in Management Studio to create tables, but they are not being populated with any logs. I have turned on Auditing to Basic in Cognos Connection ?

Any suggestions ?

Thank You

CognosPaul

In general the database being created is a good indicator of things working. You shouldn't create it yourself.

It sounds like you're only connecting via the administration page in Cognos. What happens when you test the connection from the configuration?