Metric Database - SQL Server 2005 - connection error

[Thijxx]

Hi there,

In order to use Metric Studio I have installed Metric Server and Metric Designer. The content store is a Cognos Content Store and the Metric installation directory the same as the BI directory.

On a SQL Server 2005 I created a database and made user TEST db_owner. Now this user seems to be able to connect and use the database (testing using Excel and ODBC) but when pointing to the database in the wizard "New Metric Package"/"New Data Source" the connection returns an error (unfortunatly in dutch);



All feedback is welcome!

- Thijs

[francois]

First you must create the metric content store as a distinct one from the Cognos content store :

In the Application Tier Components location, in the c8_location/configuration/schemas/cmm/sqlserver directory, run the cmm_create_db.cmd script by typing the following command:

path_to_script cmm_create_db host_name database_name user_name password [user_to_create]

then have a look there : http://publib.boulder.ibm.com/infocenter/c8bi/v8r4m0/index.jsp?topic=/com.ibm.swg.im.cognos.qrc_mm_inst.8.4.0.doc/qrc_mm_inst_id634inst_CreatetheContentStore.html