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
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.