cognos 8 configuraion

Posted on 2008-11-17
Last Modified: 2012-08-13

       I am new to Cognos. I need to install Cognos 8. I installed the software, typically i failed at Configuration of Cognos to SQL Server 2000. Please anybody help me in this or a support doc/link.
Question by:ravignan2001
    1 Comment
    LVL 5

    Accepted Solution

    You dd not say which component you were installing on SQL server 2000.  
    There are three databases you need to set up (Audit Database, Content Store, Metrics Store).  IF you want a quick and easy Content Store  there is a Cognos Content Database that can be installed but should only be used for a proof of concept when you dont want to create a real database.  IF you are setting up your own content store
    Here are instruction from the install manual
    Ensure that your installation of Microsoft SQL Server is configured as follows:
    Ï UTF-8 or UTF-16 encoding is used
    For more information about character sets, encoding, and collation, see the Microsoft SQL
    Ï the collation sequence is case-insensitive
    Ï the TCP/IP protocol is enabled
    1) Create the database using Microsoft SQL server Manager Studio
    2) Create a user account (You will need to add this to cognos configuation manager)
         a) Under Security right click logins and select new login
         b) Specify a Login Name (I usually use CogosAdmin)
         c) select SQL server authentication and specify the Password
         d) Clear Enforce password policy
         e) click OK
    3) Create a schema
    Ï Under Databases, expand the database (new_database) that you created in step 3.
    Ï Under new_database, expand Security.
    Ï Right-click Schemas and select New Schema.
    Ï Specify the Schema name and click OK.
    4) Configure the datbase user
    Ï Under Databases, new_database, Security, right click Users and select New User.
    Ï Specify the User name.
    Ï For Login name, browse and select the login that you created
    Ï For Default schema, browse and select the schema that you created in step 5.
    Ï In the Owned Schemas list, select the same schema as Default schema.
    Ï In the Role Members list, select db_datareader, db_datawriter, and db_ddladmin.
    Ï Click OK.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
    INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
    Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the e…
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now