Set up database connectivity for a Microsoft SQL Server logging database
You must set up the JDBC driver on all Application Tier Components computers with a connection to the logging database.
For a list of drivers that were tested with different versions of Cognos® Analytics, see DQM testing of vendor-supported client driver versions for each Cognos Analytics 12.0.x release (www.ibm.com/support/pages/node/6989513).
Important: For single sign-on (SSO) and Windows authentication, you need to put
sqljdbc_auth.dll in the bin64 directory. Windows
authentication is a single sign-on setup. The selection in Configuration Manager for the Content
Manager is called Microsoft SQL Server database (Windows
Authentication).
Procedure
- From the Microsoft website, download a driver file that is supported for your version of Cognos Analytics, and copy the file to the to the Cognos Analytics install_location\drivers directory.
- Copy the JDBC driver to the install_location\drivers directory on the Content Manager computers, unless you use same type of database for the log messages as you use for the content store.