Changing AR Server & DB Reference in SmartIT / MyIT Application

Version 9
    Share This:

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


    MyIT Digital Workplace


    SmartIT 2.0 and older / MyIT 18.02 and older (bundle) For DWP 18.05 and beyond, use KA 000169175 SmartIT 18.05 and beyond


    How to change AR server references in SmartIT / MyIT Application?
    How to Update (encrypt) the password within SmartIT /MyIT database?
    How to change SmartIT DB reference?


     1) Login onto Remedy with a MyIT/SmartIT Admin user.

                 Step1 : Application -> BMC MyIT administration -> MyIT administration console -> Persistent Data Stores -> click on the AR server that is currently being used.

                 Step2 :  Modify the host_name , Provide Port Number , Admin Password(provide remedy application service password) , DataStore type(Select AR Server)

                             Click on the application tab and do the same for rest of the three applications - BMC MyIT / MyIT-ITSM /MyIT HRCM and save the information. Make sure 'enabled' is set to Yes

    **Post 18.05 This change should be done in the SMT:Administration Console form**

    User-added image

      2) Login with the SmartIT Database.


    These steps apply for

    1. Any SmartIT -any version from 18.05 (stand alone SmartIT)  and beyond.
    3. Any SmartIT that is bundled with MyIT and prior.
    5. For DWP 18.05 and beyond, follow KA 000169175
                   Step1 : go to the Table - 'Configuration Parameter' with the Schema 'SmartIT_System' 
                             Run the following query: 
                               SELECT * FROM [SmartIT].[SmartIT_System].[CONFIGURATION_PARAMETER]

                 Step2 : Execute the Update query to update HostName: 
                                UPDATE [SmartIT].[SmartIT_System].[CONFIGURATION_PARAMETER] SET Value = 'Server_Name' Where Name='connect.arsystem.hostName'

                    Step3 : If the password has changed then password has to be encrypted. for this you have to use   SmartIT Manteinance Tool
                               <SmartIT Installdirectory>/SmartIT/SmartITMaintTool/SmartIT Maintenance Tool/

                                Execute the Update query to update password information: 
                                UPDATE [SmartIT].[SmartIT_System].[CONFIGURATION_PARAMETER] SET Value = 'encrypted password' Where Name='connect.arsystem.password'
                 Step4 : Execute the Update query to update Port information 
                                UPDATE [SmartIT].[SmartIT_System].[CONFIGURATION_PARAMETER] SET Value = '0' Where Name='connect.arsystem.port'

      User-added image

                    Step5 : Restart Application's Tomcat
    Change SmartIT DB reference:


    If you want to change smartIT DB reference then it has to be done in smartIT.xml file:


    The smartit.xml file located at <SmartIT_Tomcat_Install_Dir>\conf\Catalina\localhost contains references to the JDBC connection to the SmartIT_System and SmartIT_Business schemas.


    The following example is from a system connecting to MS SQL Server database: url=jdbc:jtds:sqlserver://mydbserver-011:1433/SmartIT 




    Article Number:


    Article Type:


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