Hi all,

Today let’s see how we can install Cognos 8 BI Suite 8.1.

The Checklist:
1. Cognos 8 BI Server and Model software
2. MS SQL Server 2000(with SP4)
3. Internet Information Services (IIS for WinXP)

The Procedure in steps:

1. Install MS SQL Server 2000 (SP4 is available here. Download and install the file name SQL2000-KB884525-SP4-x86-ENU.EXE, 66.9 mb in size).
Go to Start -> Programs -> Microsoft SQL Server -> Enterprise Manager.
Then, go to Console Root -> Microsoft SQL Servers -> SQL Server Group -> local -> Databases.
Right-click on Databases, choose New Database.
In the Database Properties windows, under General tab, give CM for Name and click OK.This will be our Content Store.
Check if a service is running with ‘MSSQLSERVER’ name. (Go to Start -> Run. Type Services.msc and click OK.)

2. Install IIS (Internet Information Services) from WinXP Prof CD.
Go to Start -> Setting -> Control Panel -> Add or Remove Programs.
Click on Add/Remove Windows Components.In Windows Components Wizard screen, tick the checkbox against Internet Information Services (IIS).
Click Next and then on Finish.
New entries are displayed under Start -> Settings -> Control Panel -> Administrative Tools as Internet Information Services.
Check if a service is running with ‘IIS Admin’ name. (Go to Start -> Run. Type Services.msc and click OK.)
Open Internet Explorer, type ‘localhost’ and click Go.
Windows should display two IE windows. One has (http://localhost/localstart.asp) link. Another windows has (http://localhost/iishelp/iis/misc/default.asp) link. This is to check if the IIS is properly installed. Close these windows.

3. Install Cognos 8 BI Server.
Go to Start -> Programs -> Cognos 8 -> Cognos Configuration.
Go to Data Access -> Content Manager -> CM.
Right-click on Content Store and choose Delete.
Right-click on Content Manager, choose New Resource -> Database.
In the New Resource window, Give Content Store for Name and choose Microsoft SQL Server database (Windows Authentication).
Click on the Content Store on the left pane and fill the database name field with CM (this is what we created in step-1). Go to File -> Save.
Click on Local Configuration, then go to Actions -> Test.
Go to File -> Save. Go to File -> Exit.
This asks confirmation to start Cognos 8 service. Choose Yes.
Check if a service is running with ‘Cognos 8’ name. (Go to Start -> Run. Type Services.msc and click OK.)

4. Install Cognos 8 BI Model also into the same folder. It would give a warning for the same. Just ignore it and continue. No need to configure anything here.

5. Configure IIS.
Go to Start -> Setting -> Control Panel -> Adminstrative Tools -> Internet Information Services.
Then, go to Internet Information Services -> local computer -> Web Sites -> Default Web Site.
Right-click on Default Web Site, choose New -> Virtual Directory.
In Virtual Directory Creation Wizard, click Next, then type ‘cognos8’ for Alias, click Next, for Directory, give ‘C:Program Filescognosc8webcontent’. This is where you installed Cognos.
Click Next, Allow on ‘Read’ permission. Remove ‘Run Scripts(such as ASP)’. Click Next and then Finish.
This is what we use to access Welcome screen of Cognos. (http://localhost/cognos8)
Now, right-click on ‘cognos8’ (the one we created just now in the above step), choose New -> Virtual Directory.
In Virtual Directory Creation Wizard, click Next, then type ‘cgi-bin’ for Alias, click Next, for Directory, give ‘C:Program Filescognosc8cgi-bin’. This folder is also available inside Cognos8 installation folder.
Click Next, Allow on ‘Read’ and ‘Execute (such as ISAPI applications or CGI)’ permission. Remove ‘Run Scripts(such as ASP)’. Click Next and then Finish.

Try accessing http://localhost/cognos8 from internet explorer(Firefox gave me problem, though! A couple of studios went missing in Cognos Connection).

Try opening Framework Manager also.( From Start -> Programs -> Cognos -> Framework Manager.)

That’s it. 😉

Comments (36)

  1. Reply

    hi sandeep

    thanx for the detailed installation procedure of cognos8. its working fine in my system
    so when i published gosales packages from framework to cognos n when i ran the report it throws error.
    so there is no database like gosales in content store
    can u plzz give the detail procedure
    1.how to create gosales data base in sql server 2000
    2. and how should i connect that data base to framework manager n cognos 8

  2. Reply

    Hi Sandeep,

    I followed the instructions as you said.But i am getting the below error when tested the connection:

    [ ERROR ] The database connection failed.
    [ ERROR ] Content Manager is unable to access the content store. Verify your database connection parameters, and then contact your database administrator for assistance.

    Please help me in resolving this issue.

    Thanks in Advance.

  3. Reply

    This is database connectivity issue. Which DB are you using…?
    The character set of the DB should be Unicode or a variant of it, for cognos content store to work.

    This requirement is to allow cognos to report on multiple languages.

  4. Reply

    Sandeep,

    I am using Microsoft SQL Server 2000.Also i have installed service 4 for it.But no use here..

    I am not sure about this "The character set of the DB should be Unicode or a variant of it, for cognos content store to work".

    Can u tell me how can i find it out whether character set is unicode or not..

  5. Reply

    Hi Sandeep,

    I have installed correctly & it is working fine now.I was done an mistake on installing service pack 4 for SQL Server 2000.

  6. Reply

    Glad that it worked out…

    Do you think a post on various possible issues/errors while installing Cognos 8 BI would be beneficial to the community…?

  7. Reply

    Hi Sandeep,

    i had installed the Cognos8.4 with sqlserver2000 but when i test it's correct but when i start the service it's not starting and error appears saying that
    COULD NOT START THE IBM COGNOS 8 SERVICE ON LOCAL COMPUTER.
    Error 1053: THE SERVICE DID NOT RESPOND TO THE START OR CONTROL REQUEST IN A TIMELY FASHION.

    and when i am using the " http:// localhost/cognos8 " their also i am getting an error saying as below:

    THE COGNOS GATEWAY IS UNABLE TO CONNECT TO THE COGNOS BI SERVER. THE SERVER MAY BE UNAVAILABLE OR THE GATEWAY MAY NOT BE CORRECTLY CONFIGURED.

  8. Anonymous

    Reply

    Hi Sandeep,

    Thanks for your reply. But i am not able open the gateway from the IE also. Can you please tell how can i debug this issue. The gateway was working this lastweek without any problem.

    Thanks,
    Siva

  9. Reply

    I am sorry siva, due to time constraints I can not help you at the moment. Kindly leave your email id so that i can get back to you.

  10. Anonymous

    Reply

    Hi Sandeep Thanks for your help. I have found the issue the problem is with the port. It was not listening

    Thanks
    Siva

  11. Anonymous

    Reply

    Hi Sandeep,

    I have installed cognos 8.4.1 with oracle 11g and while trying to test the Content Manager. It is throwing the following error can you please help me on this

    [ ERROR ] The database connection failed.

    [ ERROR ] Content Manager failed to start because it could not load driver "oracle.jdbc.OracleDriver".

    Thanks
    Dev

  12. Reply

    Hi Sandeep,

    I have installed cognos 8.4 with oracle 10g and while trying to test the Content Manager. It is throwing the following error can you please help me on this

    [ ERROR ] The database connection failed.

    [ ERROR ] Content Manager failed to start because it could not load driver "oracle.jdbc.OracleDriver".

    plz help me sandeep

    Thanks
    subu

  13. vijay

    Reply

    UDA-SQL-0564 [Microsoft OLE DB Provider for SQL Server][DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. (SQLSTATE=08001, SQLERRORCODE=17)
    im getting this error please help me

  14. Reply

    I am getting the following error.
    "DPR-ERR-2109 The dispatcher cannot service the request at this time. The dispatcher is still initializing. Contact your administrator if this problem persists.
    Please try again or contact your administrator"
    Can someone please help me to resolve this isue?
    Thanks

  15. Reply

    Hi CognosTech,

    Your Cognos services are NOT running. Check and double-check if they are running.

    — Sandeep P

  16. Reply

    hi, this is aman
    i have installed cognos8.4 with oracle 10g with apache2.2.17. it is working properly.
    but i want to install with server 2005, please help me,

    my id is "[email protected]"…

  17. Reply

    @Aman and @maxsanthu,

    The procedure to connect Cognos to any DB is almost same.

    Let me know up to what point have you reached and where you need help..

  18. Reply

    Hello Sandeep,
    Nadeem here.. first thanks for your explanation above.. really its very much helpful.. i have installed cognos 8.4 with Sql Server 2008 R2 with the sample databases gosales and gosalesdw
    – could you pls.. guide me how to publish the packages so that i can use it in Report studio..

    Thanks in Advance.

  19. Anonymous

    Reply

    hi, we're encountering "unable to access service at URL" error in our framework.
    these are the details:
    -cognos server up and running
    -FM cognos configuration gateway settings are all in place (pointing to the cognos server)
    -copied/pasted gateway URI value on a browser to test access, everything's fine, the login page is displaying and i could log into it.
    -i can ping the cognos server

    but when i use the FM to start a new project, this error displays and couldnt continue anymore.
    we have other PCs with framework installed and everythings working.

    any idea? thanks.

  20. Reply

    Hi Sandeep,

    Can you please help me on installing the cognos 8.4.1 with oracle 10g . Please send me steps to install the cognos and IIS and access manager also
    My mail id is … [email protected]
    Regards,
    Jayavardhan

  21. Reply

    If you want to publish the sample packages given by IBM Cognos, then configure samples given by IBM. Simple.
    If you want to publish your own packages, you need to do modeling first in Framework Manager. Please see FM User guide.
    If time permits, i will write anther post explaining the same.

  22. Reply

    Hi Sandeep,

    I am trying to install the Cognos8.4 version and Oracle11g Home edition. Moreover I have installed the Cognos in C:/ drive and Oracle in E:/ drive ..when I tried to open the Cognos Configuration, It is throwing the following error message.

    IBM Cognos Configuration was unable to successfully use the cryptographic information with the current Java Runtime Environment located in C:/Program Files/Java/jdk1.6.0_32/jre.

    You may have to use the following Java Runtime Environment C:/Program Files/cognos/c8/bin/jre/1.5.0 or the appropriate JAR files must be installed in the Java Runtime Environment that you are using. For more information, see the Installation and Configuration Guide

    Details:

    [Validation] CAM-CRP-1085 An error occurred while verifying that the security provider classes were loaded. Reason: java.lang.ClassNotFoundException: org.bouncycastle134.jce.provider.BouncyCastleProvider

    I have googled it and tried it many times..still can't be able to find this solution.

    Please try to help me out..

    Thanks
    Kishore

Leave a comment

Your email address will not be published. Required fields are marked *