Cognos Installation steps

COGNOS CONFIGURATION

* BEFORE CONFIGURATION:

1. FIRST INSTALL THE SQL SERVER IN THE MIXED MODE (NOT IN WINDOWDS AUTHENTICATION MODE) WITH THE PASWWORD SA.
2. SECOND INSTALL THE COGNOS REPORTNET SOFTWARE CRN AND FWM ONE AFTER OTHER.

NOTE: THE OPRATING SYSTEM SHOULD CONTAIN IIS (INTERNET INFORMATION SERVICE) INSTALLED BEFORE ALL…!

* REPORTNET CONFIGURATION:

1. START->PROGRAM FILES->SQL SERVER->ENTERPRISE MANAGER.
2. ON LEFT HAND SIDE PANEL SELECT MICROSOFT SQL SERVER (EXPAND)-> SERVERGROUP (EXPAND)->WINDOWS NT SERVER (EXPAND).
3. SELECT DATABASES RIGHT CLICK ON IT->NEW DATABASE->NAME IT AS ‘CRN’-> COLLATION NAME AS ‘LATIN1-GENERAL-CI-AS’->CLICK OK->CRN DATABASE IS CREATED.
4. CREATE 2 MORE DATABASES WITH NAME GOSL AND GORT (TO CREATE GOSL, GORT FOLLOW THE ABOVE STEPS WHAT WE HAVE DONE FOR ‘CRN’)->3 NEW DATABASES ARE CREATED.
5. SELECT ‘GORT’ DATABASE RIGHT CLICK ON IT->SELECT ‘ALL TASKS’->CLICK ‘RESTORE DATABASE OPTION’->ONE DIALOG BOX WILL OPENS.
6. SELECT THE BUTTON ‘FROM THE DEVICES’->CLICK ‘SELECT DEVICES’->CLICK ‘ADD’ BUTTON->SELECT THE ‘BROWSE’ BUTTON.
7. PROVIDE THE PATH (C:\PROGAMFILES\COGNOS\CRN\WEBCONTENT\SAMPLES\DATABASE\SQL SERVER\GORT)->CLICK OK-> CLICK OK-> CLICK OK.
8. SELECT THE OPTIONS TAB-> SELECT THE CHECK BOX ‘FORCE RESTORE OVER THE EXISTING DATABASE’->UNDER PHYSICAL DATA FILES WE HAVE TO PROVIDE THE FOLLOWING PATHS INSTEAD OF EXISTING PATHS:
1. C:\PROGRAM FILES\MICROSOFT SQL SERVER\MS SQL\DATA\GORT.mdf
2. C:\PROGRAMFILES\MICROSOFT SQL SERVER\MS SQL\DATA\GORT_log.ldf
9. FOLLOW THE SAME STEPS FOR GOSL DATABASE ASLO (WHAT WE HAVE DONE FOR GORT)

* CONFIGURATION OF REPORT NET SERVER:

1. START->PROGRAM FILES COGNOS REPORTNET-> CLICK ON COGNOS CONFIGURATION.
2. IN THE EXPLORER WINDOW->CLICK ON CONTENT STORE->CORRESPONDING DATABASE PROPERTIES WILL DISPLAYS->PROVIDE DATABASE NAME AS ‘CRN’.
3. CLICK ON USER ID AND PASSWORK->ENTER ‘SA’ FOR USER ID AND PASSWORK->CLICK OK.
4. IN EXPLORER WINDOW CLICK ON COGNOS REPORT NET->HERE SET’DISPATCHED MAXIMUM MEMORY FROM 128 TO 384’-> AFTER THIS SAVE CHANCES MADE-> CLICK ON SAVE BUTTON ON TOOL BAR->CLOSE.
5. IN THIS EXPLORER ONLY WE HAVE TO START REPORT NET SERVER SERVICE FOR THAT-> WE WILL FINE ONE GREEN ARROW BUTTON PRESS THAT BUTTON-> AFTER PRESSING THAT BUTTON IT WILL AUTOMATICALLY CONFIGURES THE SERVER->AFTER COMPLETION OF THAT CLOSE THE EXPLORER.


* CREATION OF VIRTUAL DIRECTORIES:

1. START-> SETTINGS-> CONTROLPANEL->ADMINISTRATIVE TOOLS->INTERNET SERVICE MANAGER.
2. ON LEFT HAND SIDE THE MACHINE NAME WILL APPEAR-> OPEN IT-> EXPAND THE DEFAULT WEBSITE->RIGHT CLICK ON IT->SELECT NEW-> CLICK ON VIRTUAL DIRECTORY->NEXT->IT ASKS FOR ALIAS NAME-> GIVE IT AS ‘CRN’-> NEXT-> CLICK BROWSE->ENTER THE FOLLOWING PATH: (C:\PROGRAMFILES\COGNOS\CRN\WEBCONTENT)->NEXT->BY DEFAULT TWO CHECK BOXES ARE ACTIVATED->UNCHECK THE RUN SCRIPT DIALOG BOX->NEXT FINISH.
3. SELECT ‘CRN’ AND RIGHT CLICK ON IT->SELECT NEW->CLICK ON VIRTUAL DIRECTORY->NEXT-> ALIAS NAME AS ‘CGI-BIN’-> NEXT->PROVIDE FOLLOWING PATH NOW (C:\PROGRAM FILES\COGNOS\CRN\CGI-BIN)->NEXT-> BY DEFAULT TWO CHECK BOXES ARE ACTIVATED->THIS TIME WE NEED TO SELECT THE CHECK BOX ‘EXECUTE’ ALSO -> NEXT-> FINISH.
4. SELECT ‘CRN’ AND RIGHT CLICK ON IT->SELECT NEW->CLICK ON VIRTUAL DIRECTORY->NEXT-> ALIAS NAME AS ‘HELP’-> NEXT->PROVIDE FOLLOWING PATH NOW (C:\PROGRAM FILES\COGNOS\CRN\WEBCONTENT\DOCUMENTATION) ->NEXT-> BY DEFAULT TWO CHECK BOXES ARE ACTIVATED-> UNCHECK THE ‘RUN SCRIPT’ DIALOG BOX->NEXT-> FINISH.
5. UNDER ‘CRN’-> EXPAND SAMPLES FOLDER->SELECT IMAGES FOLDER->RIGHT CLICK ON IMAGES FOLDER->CLICK ON PROPERTIES->SELECT THE CHECK BOX CALLED ‘DIRECTORY BROWSE’ -> CLICK APPLY->OK.
6. TYPE THE FOLLOWING URL IN THE INTERNER EXPLORER (BROWSER)-> http:\localhost\crn.
7. CLICK ON DIRECTORY LINK -> CLICK ON DATASOURCES LINK-> CREATE NEW DATASOURCE (WE WILL FIND ONE DATABASE ICON AT THE RIGHT SIDE TOP OF THE TOOL BAR IN THE EXPLORER) -> PROVIDE NAME AS GOSALES -> CLICK NEXT.
8. SELECT TYPE AS MICROSOFT SQL SERVER -> PROVIDE SERVERNAME AS ‘LOCAL HOST’ AND DATABASE NAME AS ‘GOSL’->SELECT THE CHECK BOX USERID AND PASSWORD THEN ENTER USER ID AND PASSWORK AS ‘SA’ -> TEST-> CLICK OK-> CLICK OK-> CLOSE-> FINISH.
9. AFTER THIS YOU WILL FIND ONE DIALOG BOX (GOSALES DATASOURCE CREATED SUCESSFULLY) THEN CLICK OK
10. SIMILARLY CREATE DATASOURCE FOR GORT (PROVIDE THE NAME AS GORETAILERS) AND FOLLOW THE SAME STEPS WHAT WE HAVE DONE ABOVE FOR GOSL.
11. GO TO HOME PAGE AND CLOSE.

THE END