Remedy Smart Reporting - How To Change Repository Database Host Name

Version 5
    Share This:

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.


    PRODUCT:

    Remedy AR System Server


    COMPONENT:

    ITSM In-App Reporting 9.1.00


    APPLIES TO:

    BMC Remedy Smart Reporting 9.x



    PROBLEM:

     

       
    • Database host has been changed from one server to other server.
    •  
    • Changed the database host name accordingly in ar.cfg file for AR Server.
    •  
    • Needed the details about Smart Reporting server on how to change the name of database host associated with smart reporting.

     


    CAUSE:

    Database Host Name has been changed since the deployment.


    SOLUTION:

    If the Smart Reporting Repository database has been moved to a new server that has a different name than the one originally configured, the server information for Smart Reporting will need to be updated.

    1. Stop the Remedy Smart Reporting service
    2. Edit the file, Web.xml.  The default path is: C:\Program Files\BMC Software\ARSystem\SmartReporting\appserver\webapps\ROOT\WEB-INF\web.xml
    3. Search for the following parameter "JDBCUrl" in web.xml  file.
    4. Provide the new host name in the following URL :

      <param-value>jdbc:sqlserver://DBServerName:port;databaseName=SmartReporting</param-value>  where DBServerName is the hostname of your database server and port is the port on which the database is listening.
      
     
      Excerpt from web.xml
       5. Verify the Database user name : <param-name>JDBCUser</param-name>  <param-value>ARAdmin</param-value>
    6. Verify the Database password:  <param-name>JDBCPassword</param-name> <param-value>03Std5z/BjK1XsH7KXtHkg==</param-value>
    7. Restart the Remedy Smart Reporting service.


     


    Article Number:

    000116536


    Article Type:

    Solutions to a Product Problem



      Looking for additional information?    Search BMC Support  or  Browse Knowledge Articles