Configure the Content Store

[AO]

Hello All,

I am using Cognos 8.4.1 on SQL Server 2008(Mix Mode authtication. When I tried to test the content store I keep on gettting the error "Content Manager is unable to access the content store. Verify your database connection parameters, and then contact your database administrator for assistance." can you guys assist

[tupac_rd]

Suggested settings for Microsoft SQL Server
Use the following checklist to help you set up the content store on Microsoft SQL Server.
❑ Ensure that the collation sequence is case-insensitive.
In a Custom installation, you choose a collation, which includes character sets and sort order,
during the SQL Server setup. In a Typical installation, the installation uses the locale identified
by the installation program for the collation. This setting cannot be changed later.
❑ When connecting to Microsoft SQL Server Management Studio to create the database, use SQL
server authentication.
If you connect using Windows authentication, the database that you create will also use Windows
authentication. In this situation, you must configure the database connection using a database
type of SQL Server database (Windows Authentication) in IBM Cognos Configuration.
❑ For the user account that will be used to access the database, create a new login under Security
and use the following settings:
● Select SQL Server authentication.
● Clear the Enforce password policy check box.
Tip: If you want to host more than one content store on your Microsoft SQL Server instance
and you will use both at the same time, use a different user account for each content store to
ensure that each IBM Cognos 8 instance is fully isolated from the others.
❑ For Microsoft SQL Server 2008, grant EXECUTE permission to the user account that accesses
the database.
❑ For the content store database, create a new database under Databases.
❑ Under Security for the new database, create a new schema and assign a name to it.
❑ Under Security for the new database, create a new user with the following settings:
● For Login name, specify the new login that you created for the user account.
● For Default schema, specify the new schema.
● For Owned Schemas, select the new schema.
● For Role Members, select db_datareader, db_datawriter, and db_ddladmin

[AO]

Resolved this problem after working on it today...The problem is the TCP/IP Setting configuration on SQL server 2008

[jyash]

Hello AO,
I am having the same problem configuring 8.4.1 with SQL Server 2008 Express.
I did have the TCP/IP enabled.
Did you have to do anything else.

TIA
Yash

[AO]

You need to change the IP using SQL 2008 Configuration manager. Stop and Start Cognos Configuration and test before running it again