Please accept my apologies if there is some information missing from this post, I just wanted to get something out there for the changes I have come across already to try and make sure that others can benefit, I will add to this post as I find more to keep it up to date.
Back with IBM Cognos Controller version 8.5.1 the installation process was a fairly complex affair. Armed with the Proven Practice document (01. Installing & Configuring IBM Cognos Controller 8.5.1 server – Proven Practice), all 71 pages of it, it was possible to get a fully working installation of the product.
Now, with the release of IBM Cognos 10.1 Controller, the process has some additional steps to complete.
Case Sensitive Database Provider name
Setting your SQL Server Provider is now case sensitive, this is the setting applied within IBM Cognos Controller Configuration. If you get the following error message:
Unsupported OLEDB provider sqlncli.1
It seems you may need to to ensure that the provider name is specified in upper case letters as SQLNCLI.1
A description of the problem can be found in this IBM Cognos KB article:
https://www-304.ibm.com/support/docview.wss?uid=swg21503064&wv=1
New Version of the DBCONV tool
The DBCONV tool is now a Java based application, on the first run, if you have no Java provider installed it asks to be pointed at your JRE6 location on the file system. As we already had the IBM Cognos 10.1 server components installed we could simply point at this location in order to launch the tool. The standard location is %installdir%\IBM\Cognos\c10\bin\JRE\6.0
JDBC Drivers Required
On our Microsoft SQL Server 2008 R2 based system we were unable to connect to the Controller database due to the following error:
** ERROR: java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver
We resolved this by downloading the Microsoft SQL Server 3.0 JDBC driver from the following URL:
http://www.microsoft.com/downloads/en/details.aspx?FamilyID=a737000d-68d0-4531-b65d-da0f2a735707
Once downloaded and extracted the file sqljdbc4.jar needed to be copied to the folder %installdir%\IBM\Cognos\c10 next to the DBCONV.EXE application so that this would work.
