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:
Microsoft JDBC driver are found in below microsoft website:
Download the file – sqljdbc_18.104.22.168_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.