To perform a migration of an on board KAPA vessel server to a new computer/server, please follow the below step by step instructions :



STEP 1:   Download the  Microsoft SQL Express 2008 R2 - SP2 server


               Download Link :    https://www.microsoft.com/en-us/download/details.aspx?id=30438



STEP 2:  Install it on the new server-computer on which KAPA Server will be installed on board, following the instructions below:

    

   a) On the initial below window, click on "New installation or add features to an existing installation "

       

       Be careful not to select the second option ( Upgrade from SQL Server 2000, SQL Server 2005 or SQL Server 2008) 

       as you might accidentally upgrade an existing SQL server and cause other already installed applications not to work 


       blob1476350473406.png


          


    b) Make sure that the " New installation or add shared features" option is selected and click "Next"

 

        blob1476351634532.png



   
    c)  Select the " I accept the licence terms" checkbox and click Next


        blob1476351826429.png




    d) Do not make any changes to the Features options and just click Next

        

        blob1476351993873.png




    e)  In the Instance Configuration dialog , select "Named Instance" and type "Kapa32Server". Then click Next.


        blob1476352312338.png




    f )   In the Server Configuration Dialog, change the account name for SQL Server Database Engine , from  NT AUTHORITY\ NETWORK service to NT AUTHORITY \ SYSTEM and click Next.


        blob1476353709166.png



    g ) In the Database Engine Configuration dialog, select " Mixed Mode ( SQL Server authentication and Windows authentication) " option and enter password " kapa32 " . Click Next to continue.


       blob1476354044559.png




    h )  In the Error reporting dialog, just click Next.


       blob1476354319607.png




    i ) Finally, you will get a completion confirmation window for the SQL Server setup, just click Close to exit the setup and finish.


       blob1476355290691.png





STEP 3:  Next, please follow the instructions below  to configure the SQL EXPRESS 2008 R2 Server in order to install the KAPA server on it.


     a)  Go to Start -> Programs -> Microsoft SQL Server 2008 R2 -> Configuration Tools -> SQL Server Configuration Manager   and run it


           blob1476360415389.png


     

     b) Once open , click on SQL Server Services and confirm that the states of  "SQL Server (KAPA32SERVER) " and "SQL Server Browser" is  " Running "


           blob1476361059841.png



    c)  Go to SQL Server Network Configuration -> Protocols for KAPA32SERVER. You will find : "Named Pipes" and "TCP/IP" protocols disabled. You need to enable them.


          blob1476361675569.png


       - Right click on them and select " Enable". You should see their Status turn to "Enabled"


          blob1476362023615.png


          blob1476362216639.png



    d) Now you need to configure the  TCP\IP protocol. Double Click on it to open it's configuration window and go to IP Addresses tab.


          blob1476363203376.png


      - On "IP1" and "IPAll" options, you must make sure that the "TCP Dynamic Ports" filed is blank ( delete the zero) and on their TCP Port field , type " 1433" . Then click " Apply"

    

          blob1476363360073.png


    - Click OK on the prompt window that will appear


blob1476363585458.png


    e) Go to SQL Server Services and on the right side of the screen, right click on "SQL Server (KAPA32SERVER) " and "SQL Server Browser" and click on restart, one at a time.


       blob1476363927296.png


  - When both Services have been restarted, you can close the SQL Server Configuration Manager as the configuration for KAPA setup is complete.



STEP 4: Kapa Backup from old Kapa Server and Installation on new Kapa Server.


  Download the KAPA vessel setup from HELINTEC's  FTP Server (http://fs.helintec.com or ftp://fs.helintec.com) or request it from us in CD form.

   

  This setup does not contain a Database or Vessels KAPA Documents. It is only the software without data.

  Kapa Database and Kapa Documents will be transferred on board from the old KAPA server to the new one manually.


  Save the Kapa - Setup folder on the new KAPA server ( ie: desktop or C drive ).


  a)  KAPA Database Backup

    

     From the current ( old ) KAPA on board server, in order to take a database backup, perform the following :


    - Make sure that there are no users connected to KAPA Server ( all KAPA clients on board are closed )


    - Go to :  Start -> Programs -> KapaMPI Application -> Backup KapaMPI database


         blob1476281911854.png


   - You will get a prompt window asking where you want to save the Database backup. Select a location ( ex: desktop ) and click on the "Save" button.


        blob1476365169382.png


  

   - On the next window, click on " Perform Script" button and the database backup file will be created.


        blob1476365213167.png


    - When the process is complete, you will see the following screen. Go ahead and close Kapa Database Backup interface.


   - The Database backup file must be saved inside the new KAPA SETUP folder have downloaded from our FTP server  ( or CD ) and saved on the new KAPA server, inside the folder named " Database"


blob1476282311457.png


    b)  KAPA Documents Backup


         Next , you will need to backup the KAPA documents from the old KAPA server and transfer them to the new installation.

    

       Make sure that there are no users connected to KAPA Server ( all KAPA clients on board are closed )

   

       - On the old KAPA server , go to : C:\Program Files (x86)\Helintec\KapaMPICommon ( for 64 Bit OS) or C:\Program Files\Helintec\KapaMPICommon (for 32 Bit OS)

         and copy the entire contents of the folder " KapaMPI_Documents " as well as the entire contents of the folders "MailIn" and "MailOut"

 

       - The Kapa Documents backup  will be copied to the new KAPA server after the setup has been completed.

 



 

    Step 5:  KAPA Setup on new KAPA Vessel Server


        After having saved the Database backup in the KAPA Setup " database " folder, you are ready to begin KAPA installation on the new Kapa Server.

 

      - Open the KAPA Setup Folder and run the KapaMPISetup.exe

 

blob1476283925822.png


   - Kapa Setup will begin. Click on Next


       blob1476372270947.png


     

   - Next you will be requested to enter a Registration Key to continue. To acquire it please contact HELINTEC S.A. 

     

     You will be asked for the Product ID and you will receive the Registration Key which you will enter in the corresponding field. Then click Next to continue. 

     A prompt window message will inform you that KAPA has been successfully registered.


        blob1476367721796.png


   - On the next screen, select " Use an existing SQL Server 2000 SP3 or greater instance" and from the SQL Server Name Drop down, select the ( "Computer Name"\KAPA32SERVER ) which you installed previously.

     On the Sa password field, type " kapa32 "and click Next.


       

       blob1476368980053.png



   - Now you must select the schedule for KAPA Database will be backed up by selecting Daily or Weekly Backup as well as the Time.

     Also, you can select if you wish to create a new backup file each time or if you wish to overwrite the previous one.


      blob1476369583450.png



   -  Next is the screen that shows the path locations for the various Kapa folders. You can alter them if you need.


      blob1476370788180.png


C:\Program Files\Microsoft SQL Server\MSSQL10_50.KAPA32SERVER\MSSQL\DATA
C:\Program Files\Microsoft SQL Server\MSSQL10_50.KAPA32SERVER\MSSQL\Backup

   - The next screen is the KAPA Client Selection. Here you will select which computers on your workgroup or domain will have permission to install the KAPA client software.

     Click and select the check boxes of the workstations you wish. 

     

     Do not select the Standalone Installation check box as this is intended for Server installations without network connections.


     

     blob1476371186132.png


   -  The validation screen is next which shows the selected setup settings. Click on "Start" and the setup will begin.


     blob1476372188558.png



     blob1476371546896.png



   -  When the setup is complete, you will see the following confirmation screen.


     blob1476372095987.png


  Click Exit to close the setup and finish.


    




Step 6:  Restoring KAPA Documents to new KAPA Server


     Once the KAPA setup has finished, you will need to transfer the KAPA Documents you copied during Step 4-b.


   - On the new KAPA server, go to " C:\Program Files (x86)\Helintec\KapaMPICommon " ( For 64 Bit OS) or  "C:\Program Files\Helintec\KapaMPICommon" ( For 32 Bit OS)

     and paste ( overwrite) the contents of the " KapaMPI_Documents " as well as the entire contents of the folders "MailIn" and "MailOut" you copied from the old KAPA server.


Step 7:  Running KAPA on new Server


     Go ahead and launch KAPA application Client on the new KAPA Server.

     It should run normally and all documents - attachments should be in place.



 Should you face any problems during the migration process or if you need any assistance, please contact HELINTEC support.