Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1411
  • Last Modified:

cognos 8 configuraion

Hi,

       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.
0
ravignan2001
Asked:
ravignan2001
1 Solution
 
welchb123Commented:
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
documentation.
Ï the collation sequence is case-insensitive
Ï the TCP/IP protocol is enabled
Then
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.
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now