Set up database connectivity for a Microsoft SQL Server content store

Applies to version 11.0.5 and subsequent versions unless specifically overridden

The Microsoft JDBC driver replaces the JSQLConnect driver for SQL Server. From version Applies to version 11.0.5 and subsequent versions unless specifically overridden forward you must download, from Microsoft, and put the new type 4 driver in the install_location/drivers folder.

The driver JAR file sqljdbc42.jar is the file you need to support the Java version that is shipped with IBM® Cognos® Analytics.

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