How to install IBM Cognos 8 on WinXP Prof

Dear All,

I have listed out the URLs in sequence to follow to install IBM Cognos 8.
On a Windows XP Prof PC,
1. Install MS SQL Server 2000: http://install-cognos.blogspot.in/2008/09/installation-procedure-of-microsoft-sql.html


2. Upgrage MS SQL Server 2000 to SP4: http://install-cognos.blogspot.com/2008/11/installation-procedure-of-microsoft-sql.html

3. Install IBM Cognos 8 BI Server: http://install-cognos.blogspot.com/2008/10/installation-procedure-of-cognos-8-bi.html

4. Install IBM Cognos 8 BI Modeling: http://install-cognos.blogspot.com/2008/11/installation-procedure-of-cognos-8-bi.html

5. Configure IBM Cognos 8 with MS SQL Server as Content Store: http://install-cognos.blogspot.com/2008/10/configure-cognos-8-bi-suite-with.html

6. Import Cognos 8 Sample DBs into MS SQL Server 2000 SP4: http://install-cognos.blogspot.com/2010/01/how-to-import-ibm-cognos-8-bi-sample.html

Hoping that this is useful.
-- Sandeep P

Installation Procedure of Microsoft SQL Server 2000 Developer Edition

Hi,

Here is how we can install MS SQL Server 2000.

In the initial screen, select SQL Server 2000 Components.



Click on Install Database Server.




The installation begins.





Click Next here.




Select Local Computer on which you want to create the SQL Server instance.



Create a new instance of SQL Server 2000.



Enter Name and Company Name.


Accept the EULA.



Select the Server and Client Tools.


Go with the Default checkbox checked.




Select the Typical installation.



Options on which account to use for the Service.

Choose the Authentication Mode.

Now the files will be copied. MDAC in installed first.

The installation starts...



Continues...



The MS SQL Server service is started.

Installation is Completed.

Start by going to Start -> Programs -> Microsoft SQL Server 2000 -> Enterprise Manager.

Email me here: Sandeep.Pamarati@gmail.com

How to import IBM Cognos 8 BI Sample Databases

Hi All,

A post after long time... ;-)

Today let's understand how to import Microsoft SQL Server sample databases provided by IBM Cognos 8 BI into Microsoft SQL Server.

Let's get moving...

First step is to create a new database in your Microsoft SQL Server 2000 Enterprise Manager so that we can restore the sample database into this new empty database.

Right click on the Databases and choose New Database from the context menu.

Give the new database a name: GOSALESDW and click OK button.

The new database is created. You can see the tables node of this new database. A standard set on system tables are created by default.

Navigate to the path as shown in the below picture.

Uncompress the .ZIP file.

Right click on the newly created Database and select 'All Tasks' and then to 'Restore Database'.

Select the 3rd radio button 'From Device' and click on 'Select Devices' button.

Click on Add button.

Choose the path where the copied sample db file is available.

Select the GOSALESDW that you extracted in earlier step.
For convenience, I have copied the extracted database dump file into the MS SQL Server's BACKUP folder in MS SQL Server path.

The path should be similar as shown in below picture.

Click on OK button and then you see the dump file path under devices list, as shown below.

You can just have a glance at the 'Options' tab.

File restore process begins...

...and finishes pretty quickly.

As you can see in these pictures below, there are 66 IBM Cognos related tables, 6 views and 31 stored procedures in this new database.

Hope you enjoyed the post...!

Sandeep Pamarati

Installation Procedure of Microsoft SQL Server 2000 SP4

Hi Guys/Gals,

Let's upgrade our Microsoft SQL Server 2000 with SP4 which is available here.

Extract the contents of the zip file (SQL2000-KB884525-SP4-x86-ENU.EXE) to a folder or just run it.

Installation begins.

Click 'Next' here.

Say 'Yes' to this agreement.

Apply the Service Pack 4 to the default instance. Just click 'Next' here.

Validating the user.

Choose 'Window Authentication' here.

Apply the SQL Server Service Pack 4.

Just a warning. Click 'OK' here.

Wait while the necessary information is gathered.

All the necessary information is available.

Installing Microsoft DAC

Installation in progess.

Upgrading the server process initiated.

Executing upgrading sqls...

Executing upgrading sqls...(cont)...

Applying the SQL scripts.

Backup the newly upgraded master databases for safety.

The installation in completed successfully.

Hope everything went fine... ;-)