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.
ravignan2001Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
DB Reporting Tools

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.