Installing Cognos Samples

[tdhsaurabh]

Hi,

I am trying to install Cognos with MS SQL Server 2000.

My problem is i am not able to RESTORE the SAMPLE database

I refereed to following link:

http://publib.boulder.ibm.com/infocenter/c8bi/v8r4m0/index.jsp?topic=/com.ibm.swg.im.cognos.qrc_inst.8.4.1.doc/qrc_inst_id2994restore_samples_database.html

According to above link for MS SQL Server 2000 there should be .BAK files but i found files (GOHR, GOMR, GORT, GOSL, GOSLD) without .BAK extension.

I copied the above files in SQL SERVER backup folder and tried to run the RESTORE FEATURE as follows

1. Right click on database

2. Select All Tasks->Restore Database

3. In Restore Database window I selected From Device radio button

4. Then i Selected above files, one by one using "Select Devices" Button

5. Then i Click OK button


But its not working...

I appreciate help on how we can Install Cognos Sample packages in MS SQL Server 2000

Thanks you

[MFGF]

Did you check the option to overwrite the existing database before you clicked OK to the restore?

MF.

[tdhsaurabh]

Yes I did tjat

Can you tell me if i recreate the whole database and then repeat the above procedure then shall it work?

[MFGF]

It hasn't failed for me yet.  Yes - try deleting and re-creating the database then try the restore again.

MF.

[vinu]

Hi,


follow the below detail steps to restore samples.

1.Open Microsoft SQL Server Enterprise Manager, right-click   Databases, and then click New Database.
2.In the Name box, type GORT, and then click OK.
3.Restore the databases.
4.Right-click the GORT database, point to All Tasks, and then clicks Restore Database.
5.In the Restore database dialog box, click the from device radio button.
6.Under Parameters, click Select Devices.
7.In the Choose Restore Devices dialog box, click Add.
8.In the Choose Restore Destination dialog box under File name, click the Ellipsis   and browse to <Cognos C8 Installation location>\c8\webcontent\samples\datasources\sqlserver\GORT, and then click OK.
9.Click OK twice more.
10.In the Restore Database dialog box, click the Options tab.
11.Click the Force restore over existing database check box to select it.
12.In the 'Restore database files as:' pane, ensure the path for both files in the Move to physical file name column points to the location of the GORT database.
13.If you chose the default location when you created the database, the path should read,
14.C:\Program Files\Microsoft SQL Server\MSSQL\Data\GORT_data.mdf for the first file
15.C:\Program Files\Microsoft SQL Server\MSSQL\Data\ GORT_log.ldf  for the second file.
16.Click OK.
17.A message appears saying the restoration was successful.
18.Click OK to close the message.

Regards,
Venu

[tdhsaurabh]

Thanks,

Thanks Venu, I will follow that. I have a question though how will COGNOS will find the new data base (GORT) we created coz during installation of Cognos we gave database name to CM.

[MFGF]

Hi,

CM is your Content Manager database - this is used by Cognos 8 to store all the report specs, user preferences, portal pages etc.

GORT is a reporting database - used as a data source by the reports stored in the CM database.  Assuming you have followed the instructions to set up the sample databases and you have imported the samples deployment file, you will then have to define the data source connections from C8 to your sample databases.

For details, see the IBM Cognos 8 Installation and Configuration Guide - chapter 9.  In my version, the relevant part covering setting up the data source connections is on page 241.

MF.

[tdhsaurabh]

Many Thanks,

Thanks for all the replies.

Essentially my assumption was wrong, that CM is data for Content Store and for samples we have to create seperate data bases in sql server.

Also, i found that in Content Administration section we have to create data sources in cognos.

After above two steps my samples are now FINALLY WORKING.