none
Could you please provide some pointers regarding why databases and registry keys are not getting created after installing HIS 2013? RRS feed

  • Question

  • Hi

    We have installed Host Integtation Server 2013 in "Windows Server 2012 DC" with SQL Server 2012.
    After configuring HIS using configuration tool, databases 'MSHIS_DATA' and 'MSHIS_HIP' are not created in SQL Server.
    It is also observed that registry keys "SqlLogConnectionString" and "ConnectionString" are not found at Registry path "Software\Microsoft\Host Integration Server\Data Integration" and "Software\Microsoft\Host Integration Server\HIP" resp. However, we can observe databases and respective registry keys in HIS 2010 machine.

    Could you please provide some pointers regarding why databases and registry keys are not getting created?

    Thanks In Advance,

    ~Swetha.
     
    Tuesday, October 8, 2013 2:04 PM

Answers

  • Enterprise Single Sign-On will not be listed in the HIS 2013 Configuration Tool is you did not select "Enterprise Single Sign-On" to be installed when running the HIS 2013 Setup program. It is listed as one of the "Available components" under "Server" in the HIS 2013 Installation Wizard.

    Go back to Programs and Features under Control Panel to view the list of installed programs. Select "Microsoft Host Integration Server 2013" and then click Uninstall/Change. Make sure "Modify" is selected and then click Next. Expand the Server component and then see if Enterprise Single Sign-On is checked. If not, check this option and click Next. Complete the wizard to have Enterprise Single Sign-On installed. After this, the Enterprise Single Sign-On option should be visible in the HIS 2013 Configuration Tool.

    Thanks...


    Stephen Jackson - MSFT

    Friday, October 11, 2013 4:35 PM

All replies

  • Hi Swetha,

    Did you follow the instructions at following link:

    http://msdn.microsoft.com/en-us/library/dn148736(v=bts.80).aspx



    I hope this helps!!!!!!

    Maheshkumar S. Tiwari|BizTalk Developer Interview Questions and Answers

    http://tech-findings.blogspot.com/


    Tuesday, October 8, 2013 2:20 PM
  • The reason for this is that the Transaction Integrator feature in HIS 2013 no longer requires or uses SQL Server. In previous versions, SQL Server was required to store Host Initiated Processing (HIP) configuration information. This is no longer required. All TI configuration for both WIP (Windows Initiated Processing) and HIP is stored in App.Config files.

    The Data Integration feature that used a SQL Server database was really for scenarios where 2-Phase Commit (2PC) support was needed. However, we no longer need to use a SQL database to support 2PC (distributed transactions), so the configuration for the SQL database has been removed.

    A number of changes to TI have been made including the removal of the TI Manager MMC. You now need to use the new TI configuration tool for creating application and web configuration files for the TI configuration. In addition, the TI WIP configuration is not stored in the registry as it has been in previous versions. It will be in App.Config files.

    Take a look at the HIS 2013 Readme and Installation Guide that can be downloaded from http://www.microsoft.com/en-sa/download/details.aspx?id=39951 for more details.

    Thanks...


    Stephen Jackson - MSFT

    Tuesday, October 8, 2013 5:19 PM
  • Hi Stephan,

    Thank you for the information provided.



    • Edited by swetha0318 Thursday, October 10, 2013 8:37 AM
    Wednesday, October 9, 2013 12:19 PM
  • Hi,

    In "HIS 2013 Installation Guide", It is mentioned that

        "In the Configuration Tool, select Custom Configuration. In the left pane, select Enterprise SSO, and in the right pane, select Enable Enterprise Single Sign-On".

    And Configuration Prerequisite for Enterprise Single Sign-On is "Microsoft SQL Server 2012 or SQL Server 2008 R2 SP1"

    Yes we can see "Enterprise SSO" Configuration in BizTalk server.
    But cannot see "Enterprise SSO" configuration in Configuration Tool in HIS Server.

    I understand the reason for "Not creating MSHIS_DATA' and 'MSHIS_HIP databases in SQL Server"

    Could you please provide some pointers regarding
    1> Configure "Enterprise Single Sign-On" in HIS 2013
    2> Creating "SSO" Database in SQL Server in HIS 2013.


    Thanks in Advance,

    ~Swetha





    • Edited by swetha0318 Thursday, October 10, 2013 8:40 AM
    Thursday, October 10, 2013 6:52 AM
  • Did you select "Enterprise Single Sign-On" in the list of Components to install when you installed HIS 2013?


    Stephen Jackson - MSFT

    Thursday, October 10, 2013 1:58 PM
  • Hi Stephen,

    These are the components available during HIS 2013 Configuration.

    Network Integration
    Service for DRDA
    Transaction Integrator
    Session Integrator
    Message Integration

    "Enterprise Single Sign-On" is available during Biztalk 2013 Server configuration.

    But not in HIS 2013 Configuration.

    Just want to confirm, is that "SSO" component can be configured and used in HIS, only when HIS is installed with BizTalk?

    Thanks,

    ~swetha

    • Edited by swetha0318 Friday, October 11, 2013 6:53 AM
    Friday, October 11, 2013 6:50 AM
  • Enterprise Single Sign-On will not be listed in the HIS 2013 Configuration Tool is you did not select "Enterprise Single Sign-On" to be installed when running the HIS 2013 Setup program. It is listed as one of the "Available components" under "Server" in the HIS 2013 Installation Wizard.

    Go back to Programs and Features under Control Panel to view the list of installed programs. Select "Microsoft Host Integration Server 2013" and then click Uninstall/Change. Make sure "Modify" is selected and then click Next. Expand the Server component and then see if Enterprise Single Sign-On is checked. If not, check this option and click Next. Complete the wizard to have Enterprise Single Sign-On installed. After this, the Enterprise Single Sign-On option should be visible in the HIS 2013 Configuration Tool.

    Thanks...


    Stephen Jackson - MSFT

    Friday, October 11, 2013 4:35 PM
  • Thank you Stephen,

    It really works for me.
    prereq for SSO is ESSO server.
    I installed ESSO sever and i configured ESSO.
    SSODB database is created in SQL Server.

    Regards,

    ~Swetha

    Wednesday, October 16, 2013 6:29 AM