Since we were using Microsoft SQL Server for our backend as well as our content store database, the first thing to do is:
- Download the SQL Server driver. The file you required is sqljdbc4.jar.
After several attempts to install trying out different options, the only way I was able to make SSO work smoothly is to
- Install using custom installation and select all components. Particularly include optional gateway.
Before running Cognos Configuration,
- Copy the sqljdbc4.jar in <install folder>\webapps\p2pd\WEB-INF\lib
or any folder which is included in the java path like <install folder>\drivers. The first folder I mentioned has .jar files in it so the sqljdbc4.jar seems to be at home in that folder. Again, do this only if you will use MS SQL Server database.
** this cause BMT-IMP-0002 CAF-WRN-2082 error when importing tables in Framework Manager. Try to copy sqljdbc4.jar in <install folder>\drivers instead.
- Run Cognos Configuration.
You only need to configure your content store and authentication (we use LDAP). And while you are in authentication, might as well disable anonymous login. Start your Cognos services and test by logging in to:
http://<servername>:9300/bi/v1/disp
If you can open this page successfully and login, you are half way through.
- Download the IIS automated script here:
https://www.ibm.com/support/knowledgecenter/en/SSEP7J_11.0.0/com.ibm.swg.ba.cognos.inst_cr_winux.doc/t_gateway_iis.html
You can initially follow the instructions manually. You will appreciate the script a lot more if you do. And it is a great learning experience.
appcmd list app
appcmd delete app
No comments:
Post a Comment