How to manually install the Business Intelligence (BOXI) r3 ODBC driver.

Products

• CA IT Asset Manager
• CA Software Asset Manager (CA SAM)
• ASSET PORTFOLIO MGMT- SERVER
• SUPPORT AUTOMATION- SERVER
• CA Service Desk Manager - Unified Self Service
• CA Service Desk Manager
• CA Service Management - Asset Portfolio Management
• CA Service Management - Service Desk Manager

Issue/Introduction

Description:

If you want to access a CA Business Intelligence r3 installation on a remote server, the Business Intelligence ODBC driver that is packaged with CA Service Desk r12.5 CA SDM must be installed locally.

Solution:

IMPORTANT: This article contains information about modifying the registry. Before you modify the registry, make sure to create back up of the registry and ensure that you understand how to restore the registry if a problem may occur. For more information about how to back up, restore, and edit the registry, please review the relevant Microsoft Knowledge Base articles on support.microsoft.com.

1. If you are running Windows XP or Windows 2003, then you should ensure that Microsoft patch KB925336 is installed before you install the CA Business Intelligence components.
   
   

   As documented at http://support.microsoft.com/kb/925336, Microsoft does not provide an official fix for the Windows XP platform.

   Therefore, you need to perform the following on Windows XP based machines:

   1. Click Start, click Run, type regedit, and then click OK.
      
      
   2. In Registry Editor, locate and then click the following registry key:
      
      HKEY_LOCAL_MACHINE\Software\Policies\Microsoft\Windows\Safer\CodeIdentifiers
      
      Note: Before you modify this key, we recommend that you back up this key. To do this, right-click CodeIdentifiers, and then click Export. Save the file to a location where you can find it on the computer.
      
      
   3. Change the PolicyScope registry value. To do this, double-click PolicyScope, and then change the setting from 0 to 1.
      
      
   4. Close Registry Editor.
      
      
   5. Click Start, click Run, type cmd, and then click OK to open a Command Prompt window.
      
      
   6. At the command prompt, type the following command, and then press ENTER:
      
      net stop msiserver
      
      This command stops the Windows Installer service if the service is currently running in the background.
      
      
   7. Continue with Step #2 in this technical document.
      
      
   8. After you install is complete, repeat steps a and b. Then, change the PolicyScope registry value back to 0.
   
   
   
2. Run "setup.exe" from the CA Service Desk Manager r12.5 CA SDM DVD #2
   
   
3. Select "English" as the language
   
   
4. Click on "3. Product Installs"
   
   
5. Select "CA Business Intelligence Installation"
   
   
6. Click on "Next" in the Introduction screen
   
   
7. Read the full License Agreement. You must select "I accept the terms of the License Agreement" to continue.
   
   
8. Click on "Next"
   
   At this point, if Microsoft patch KB925336 is not installed, the pop-up in Figure 1 is received. Click on "OK", exit the installation, obtain and install the required patch, re-start your system, and perform the steps in this solution again from the beginning.
   
   Figure 1.
   

   <Please see attached file for image>

   
   
   
9. Select "No" when asked "Do you want to install CA Sample Templates?" and click on "Next".
   
   
10. Specify a directory and file name for the response file and then click on "Next".
    
    
11. Click on "Install"
    
    
12. The installation wizard welcome message is displayed. Click on "Next".
    
    
13. Accept the License Agreement
    
    
14. Select "English" as the language pack that is to be installed
    
    
15. Select "Custom or Expand Install" as the Install Type. Click on "Next".
    
    
16. Click on the pull-down immediately left of "BusinessObjects Enterprise".
    
    
17. Click on "X Entire feature will be unavailable".
    
    
18. Expand the node named "Client Components".
    
    
19. Click on the pull-down immediately to the left of "Universe Designer".
    
    
20. Click on "Will be installed on local hard drive"
    
    
21. Under the "BusinessObjects Enterprise" main node, expand the node named "Database Access".
    
    
22. Click on the pull-down immediately to the left of the appropriate Database Access driver.
    
    
23. Click on "Will be installed on local hard drive"
    
    
24. Click on "Next".
    
    
25. Once the previous step completes, click on "Next".
    
    
26. Click on "Finish".
    
    
27. Follow technical document, TEC523851, to set up the Data Direct ODBC driver.

Environment

Release:
Component: ARGIS