What are steps to set up Content Manager database in SQL Server 2005 ?

[BobaGreek]

 
  I took the following steps for Planning 8.2 , but something is not working out  ???

  1. Created userid "cognos" in Active Directory"
  2. Created database "cm" in SQL Server 2005
  3. Granted 3 roles (reader, writer and ddl) to userId "cognos"
  4. In Cognos Configuration created name space "planning"
 
What am I missing?

Thanks

[praveennb]

1. I have read the planning documents, it said u will need to add new database resource under data access>cogons planning which
points to either content manager DB or to a new DB which will hold the planning store.

2. You will need to disable anonymous access and a new security provider like series 7, LDAP ....., without this the analyst planning application will not open.

try to make the cognos userid as the Owner of the database cm.

Did you try to test your configuration one by one, especially on the content manager data access.

[BobaGreek]

Thanks BI007.

1. I disable anonymous access to default cognos namespace.

2. Under Data Access>Content Manager I created new entry called "CM". It point to Cognos Content database. I tested connection and it worked fine.

3. Under Security > Authentication I set up new Namespace and pointed it to Active Directory.

When I logon to Cognos Connection or Framwork Manager everything works fine. No errors what so ever.
But when I try to open Planning - Analyst it returns error after I enter the same credentials as for Cognos Connection or FM.

[SomeClown]

If you are pointing to AD and you are getting prompted for login (with single security source), then there's something missing in the config.

Cognos 8 and Cognos 8 Planning should run under a service account that has local admin rights.  If the Analyst libs and filesys are on a UNC share,  the service account will need access to the share

In IIS, make sure that Allow Anonymous is turned off on the cognos directories.  In Cognos Configuration, make sure Anonymous is turned off for security.

Separate database resource under planning is only needed if you want to isolate the Planning Content Store items from BI Content Store items (good idea when integrating 8.2 planning into an existing BI environment)

[praveennb]

Thanks BI007.

1. I disable anonymous access to default cognos namespace.

2. Under Data Access>Content Manager I created new entry called "CM". It point to Cognos Content database. I tested connection and it worked fine.

3. Under Security > Authentication I set up new Namespace and pointed it to Active Directory.

When I logon to Cognos Connection or Framwork Manager everything works fine. No errors what so ever.
But when I try to open Planning - Analyst it returns error after I enter the same credentials as for Cognos Connection or FM.

what error message was displayed when u opened  analyst

[tish1]

Separate database resource under planning is only needed if you want to isolate the Planning Content Store items from BI Content Store items (good idea when integrating 8.2 planning into an existing BI environment)

Actually I never managed to get EP running without a seperate entry for the Planning Store - even if I used the same credentials as for the Content Store.
I also think that both connections use different DB drivers for SQL 2005, because in the Planning Store cannot be accessed unless the user's default catalogue exists, while this is no problem with the Content Store.