new server installation - .:: betta global systems

New Server Installation

Revisión: 13/10/2014

New Server InstallationI

Contenido

Parte I Introduction 1

Parte II

Opening Ports 3

................................................................................................................................... 31 Access to the Advanced Security Firewall

................................................................................................................................... 52 Opening ports

Parte III Create & Share Repositorio folder 8

................................................................................................................................... 81 Create & Sharer

................................................................................................................................... 132 Assigning unit R

Parte IV Installation & Configuration 18

................................................................................................................................... 181 Installation

................................................................................................................................... 222 Configuration

................................................................................................................................... 243 Config. Modo

................................................................................................................................... 254 Crear las Tablas del Servidor

................................................................................................................................... 295 Companies Administration

.......................................................................................................................................................... 30Create Companies

.......................................................................................................................................................... 33Import Companies

.......................................................................................................................................................... 37Updating companies

................................................................................................................................... 406 Ceate a shortcut of Millennium setup

................................................................................................................................... 417 Install the service

................................................................................................................................... 438 Exiting from system

Introduction 1

© 2014 Betta Global Systems

1 Introduction

The sequence of steps in this document are described in a simple and detailed way,for you as a user, can make use of this information and take advantage to makeyour job easier. You will be guided through concise explanations accompanied bydemonstrative graphics application usage.

The Server is where the Data Base is physically storage.

Millennium Aduanas server Is where the critical process from system will run.

(Both severs can be run in the same Equipment).

We recommend that the following steps will be done by your IT personal.

Please read this manual before you start downloading the files needed for thesubsequent process of installing and configuring SQL Millennium Aduanas; if youhave questions please contact us via email [email protected]

This manual is only for purposes of consultation, and the examples discussed heremay differ from real situation; it's just a base document to help user of MillenniumAduanas SQL.

This tutorial will show us how to install MSSQL software , it is assume that thecompany have already installed in the server all the configuration, and Visual C++application it's also previously installed.

We assume that you have downloaded Millennium Aduanas Installation icon andVisual C++ is already installed.

Before we start with these steps it's necessary that we have MA_SEVER &MA_DATA Databases already created. The next installation process will create/update tables in mentioned databases, and they will be required to executeMillennium Aduanas system correctly.

You can get these 2 databases of the following three ways:

MA_SERVER :

1.- Create an MA_SERVER totally new on SQL SERVER (New Database)2.- Use MA_SERVER already configured in the server (The one in use from MAv13.2).3.- Pegar un respaldo del MA_SERVER que ya se tiene en una base de datosnueva (Respaldar y restaurar).

New Server Installation2


MA_DATA :

1.- Create an MA_DATA totally new on SQL SERVER (New Database)2.- Use MA_DATAalready configured in the server (The one in use from MA v13.2).3.- Pegar un respaldo del MA_DATA que ya se tiene en una base de datos nueva(Respaldar y restaurar).

last option could require to Import Companie to the new MA_SERVER (you will seehow to do it later in this manual).

Important note:To comply with the mentioned requirements before start the installation process:

http://bettaglobalsystems.com/VersionNueva/Documentos/RequerimientosVersionNueva.pdf

Introduction 3


2Opening Ports

En la siguiente sección se explicará cómo aperturar los puertos necesarios paratrabajar en un esquema Cliente-Servidor con la nueva versión de MillenniumAduanas.

Este proceso se realizará solo en el servidor dónde será instalado el configurador deMillennium Aduanas (Servidor de Millennium Aduanas); Quizas sea el mismo endónde se encuentra la base de datos.

Se recomienda realizar este proceso de la mano con el personal de sistemas.

El siguiente capítulo no es necesario realizarlo si su instalación será de tipoMONOUSUARIO.

2.1 Access to the Advanced Security Firewall

The following process may vary depending on the version of windows that utilize.

Access the Control Panel.

Then we enter System and Security.



Then to Firewall / Advanced settings.

Opening Ports 5


2.2 Opening ports

on the next screen he have to choose Indbound rules / New rules

Then we choose port and press next

Then we choose specific local ports and we type in 24620,24621; press next.



in the next section we choose allow connection and press continue.

The following section needs to be configured with the help of the IT department as itcan be variable according to the operating rules and permissions for each company;we suggest marking the first 2 options, Domain and Private.

Opening Ports 7


Then assign the name: Millennium Server to name of our rule and will click Finish.



3 Create & Share Repositorio folder

The following section describes how to create the repository folder and then share it

This process is performed only on the server where the Setup of MillenniumAduanas (Millennium Aduanas Server) is installed; Maybe it's the same which thedatabase is (single user config).

3.1 Create & Sharer

To create repositorio folder we need to go to Start menu ( ),then do a click on Computer.

Get in Drive C:/ (it can be another unit, depends on the server config).

Create & Share Repositorio folder 9


Create a folder named "Repositorio":

Once that the folder is created do a right click on it.

then go to the Share tab



now click on "share" option



Here are the names of users (or clients) who will be connecting to server MillanniumAduanas; we can look through the list or add one pressing "Add" button.

The next step is to position ourselves on the user you will be given permission andyou select the option reading and writing:



This process should be done for each Client user. to finish press Share:

Then will appear a windows confirming the Repositorio folder shared, just pres Ready.



3.2 Assigning unit R

To assign repositorio folder to a unit we need to go to Start menu (

), then do a click on Computer.



on the next window we need to do a click on Map network drive option.

When the next window appears Select in Drive section the unit R (The letter are isjust a recommendation, it can be any available unit)



Then do a click on Browse



We have to select in the Shared unit before from server and found Repositoriofolder, then do a click on Finish.



This will create a new icon under Computer screen



4 Installation & Configuration

Next section explains how to install and configure Millennium Aduanas.

This process will be realized in the server/client in where the setup of MillenniumAduanas is installed and the application. (Millennium Aduanas server). It could bethe same equipment in which the Data base is physically storage.

4.1 Installation

Do double click on the Millennium Aduanas executable icon, It will make appear nextwindow, where the process will start:

Installation & Configuration 19


Press Siguiente to continue with the installation....

In the next screen you should press Instalar option to begin with the installation.



To finish we do a click on Cerrar, Then will appear the configuration window.



4.2 Configuration

Under Base de Datos tab we need to fill up the next fields :

Servidor Millennium: Leave it EMPTY.

The next fields are required:

Proveedor: SQL ServerServidor: The namef of SQL Server instance. Usuario: admin, the one created in SQL Server,Contraseña: mbettaglo, the one created in SQL Server,Base de Datos: MA_SERVER_1, (This Data Base should be created previously inSQL server manually), (The name can be TEST_SERVER)

Press Probar Conexión.

If the connection was successful you will see the next message, If it wasn't we mustcorrect the fields mentioned.



In Repositorio we must select the repositorio folder, it can be in drive c:\Repositorio(if this is a server) or unit R (if this is a client)

In server (c:/repositorio) we must not to press Validar Repositorio, this option isonly for clients configuration.



then press Guardar. if the connection was successful

4.3 Config. Modo

Next step will be is to go to Config. Modo tab; we will choose in it the configurationmode in which our installation will be.

Servidor Maestro: Both servers are (Data base & Millenium server) physicallyinstalled in the same equipment. (Client would be required)Servidor Cluster: Database server and Millennium server are physically on 2different equipments. (Client would be required)

NOTE: WE ARE CONFIGURING THE M.A. SERVER, IT IS IMPORTANT NOT TOSELECT ESTACIÓN DE TRABAJO OPTION.



4.4 Crear las Tablas del Servidor

Now go to Servidor tab and do a click on Crear Base de Datos Option.



Next window will create/Update tables in the Data Base (DB: MA_SERVER)

Click on Crear option.



Importante leer recuadro azul.

On the next screen we need to press Crear Tablas button.



It is normal for these tables are missing, they are new and they are necessary forMillennium Aduanas new version.

At the end we can check the database in SQL Server and can see the list of fileswith their basic data.



4.5 Companies Administration

Up to this point we have prepared our database server (MA_SERVER); the nextpoint is to prepare the database operation (MA_DATA) Creating, Importing orupdating them.

For this we will click on the Empresas tab.

If the business you're looking IS NOT IN THE LIST you must perform the following:

a) If the company is brand new (you just gave New Database in SQL Server and iscompletely empty (no tables)) you will need to click on the Crear Empresa button



(This option is basically for new customers of Betta Global Systems) .

b) If your company is a previous backup or already operating tables created youmust click Importar Empresa

Empty list.

If the company is already in the list, continue to Chapter Updating companies.

4.5.1 Create Companies

donde ingresaremos la base de datos de operación (MA_DATA nueva), el códigoque sera asignado a la empresa y el nombre.Clicking on Crear Empresa will make appear the next screen where we are going toset up the database operation (MA_DATA new), the code and name will be assignedto the company.



At the end we do a click on Crear.

After processing the information:



Will apepar the next screen that will create the operative tables of the system; Do aclick on Crear Tablas button.



You will see a confirmation message when it is done :

If you use these steps, it won't be necessary to Update nor Import companies ;Go straight to Create shortcut chapter.

4.5.2 Import Companies

To import a company do a click on Importar Empresa.



in the next screen we must fill up the next iformation:

Base de Datos: Name of the data base in operation that we want to link.Código de Empresa: New code for the company



Now click on Importar.



when it finish you will see next message:



4.5.3 Updating companies

YOU NEED TO DO THIS PROCESS FOR EACH COMPANY THAT APPEAR ONTHE LIST.

Here it is important to note that the database that is on the list, have a differentversion from the setup screen; for these cases (and future updates) It must benecessary to update and make match all databases versions with the setup screenversion.

Select the company from the list and press Actualizar.



NOTE : if we expand Actualizar button we can find "actualizar todas" option, Itmakes to all companies in the list be updated:

Next process will be done:



At the end you will see a tables list that will need to be created in the DB of theoperation.

Do a click on Crear Tablas.



It is normal for these tables are missing, they are new and they are necessary forMillennium Aduanas new version.

At the end you can see that the Data bases and the setup screen have the sameversion

Now the DB is updated.

4.6 Ceate a shortcut of Millennium setup

Is important to create a shortcut in desktop from the Setup of Millennium Aduanas ,this is because we will need it to update Millennium aduanas constantly.

Choose Servidor tab and do a click on Crear Acceso Directo.



ports 24620 y 24621 should be previously opened.

this icon will appear on your desktop.

4.7 Install the service

The next step is to install the service in Millennium AduanasEl siguiente paso esinstalar el servicio de Millannium Aduanas.

Go to Servidor tab, do a click on Instalar Servicio option.



This process might take 1 min approximately.

when it finish we will see available next options:

Here we do a click on Iniciar Servicio.



Once that the service is running, you will see on the status box "Corriendo" :

4.8 Exiting from system

It is necessary to comply 100% this manual steps.

If you had any trouble, contact us E-mail via on: [email protected]; If everything went ok just press Salirto exit from setup.

new server installation - .:: betta global systems

Documents