Cognos 8 Metrics Manager

[phani1979]

Hi
I want to create a database in metrics
AS i followed the pdf, done according to the steps..
I had run the batch file  in cmd mode.
c:\program files\cognos\c8\configuration\schemas\cmm\sqlserver\cmm_create_db  [servername]phani [database name] go_metrics [uid/pas] sa sa [authentication] sudhakar

when iam running this iam getting error
"Cognos Metrics Manager requires a case insensitive instance of SQLSERVER"
Iam using Windows 2003, sqlserver enterprise edition 2000 sp4.
I am stuck here
can u help me guys
Thank you
Sudhakar

[MFGF]

Hi,

Just go into SQL Server Enterprise Manager and create a new database in there.  Once you have done this, log in to Cognos Connection and press the 'New Metric Package' button on the toolbar.  This will take you into a wizard which guides you through the process of setting up a connection to the database and populating it with the relevant structures and calendar.

Best regards,

MF.