Set up database connectivity for a Microsoft SQL Server content store

You must download, from the Microsoft website, a driver that is supported for your Cognos Analytics release and copy it to the install_location/drivers folder.

For a list of drivers that were tested with your Cognos Analytics release, see DQM testing of vendor-supported client driver versions for each Cognos Analytics 11.2.x release (https://www.ibm.com/support/pages/node/6441017).

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).