Problem
Unable to add or test a data source into a Framework Manager project when importing meta data.
Symptom
RQP-DEF-0177 An error occurred while performing operation ‘sqlUpdateAttach’ status=’-9’.
UDA-SQL-0564 [Microsoft OLE DB Provider for SQL Server]Invalid object name ‘user_session’. (SQLSTATE=42S02, QLERRORCODE=208)
Cause
Wrong setup of the data source connection, defined in Cognos Connection.
Environment
OS: Windows Server 2003 R2 SP2
Database: MS SQL Server 2005
Solution
When creating the data source, select the option to choose ‘Signons’ and provide the correct user name and password,
or,
Select the option ‘Cognos 8 service credentials’. Then you have to create a domain account which starts the Cognos 8 service and has sufficient permissions on the MS SQL database server.