error: cognos Content Manager failed to start because it could not load driver “com.microsoft.sqlserver.jdbc.SQLServerDriver”.

issue- In Cognos analytics(11.0.5+) when you are trying to configure content store with SQL server data base for the first time you will get the error – “cognos Content Manager failed to start because it could not load driver “com.microsoft.sqlserver.jdbc.SQLServerDriver”.”

Solution is mentioned in below website:
https://www.ibm.com/support/knowledgecenter/SSEP7J_11.0.0/com.ibm.swg.ba.cognos.inst_cr_winux.doc/t_MSdriver_SSLconfig.html

Microsoft JDBC driver are found in below  microsoft website:
https://www.microsoft.com/en-us/download/details.aspx?id=55539

Download the file – sqljdbc_6.2.2.1_enu.tar.gz from above microsoft link.
Extract the above file and find the file – “sqljdbc42.jar” and place it at cognos installation –  install_location/drivers folder.

Re-open Cognos configuration and test the Content store.

 

for data source connection to work
keep “sqljdbc_auth.dll” file at drivers, bin64 folder.

 

One thought on “error: cognos Content Manager failed to start because it could not load driver “com.microsoft.sqlserver.jdbc.SQLServerDriver”.

  1. I followed your instructions and copied sqljdbc42.jar file in drivers folder, but still getting same error message when I test SQL server content store on Cognos configuration

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s