Installation

 

The following document outlines the installation procedures for v7 implementations. There are several sections related to the installation procedures.

 

Hardware Recommendations

Physical or Virtual Servers can be utilized as long as the general hardware guidelines are adhered to.  Note that MTech recommends that 64-bit operating systems be used where possible.

Citrix/Terminal Server
Application Server

The Application Server hosts the shared services - locking, caching, web services, multi-language, optimizer, and long running batch processes (reports, projections, period end tasks, etc). The application server role can be combined w/ the Citrix/Terminal Server role.

 

Database Server (MS-SQL Server):
Business Intelligence (BI) Server (MS-SQL Server)
Minimum Hardware Recommendations

The application requires .NET 4.0 framework.

 

                                                1-5 Users                  6-25 Users             25-50 Users       50+ Users

APPLICATION/TERMINAL SERVER:*

                CPU:                        2.0Ghz Dual Core         2.5Ghz Dual Core         2.5Ghz Quad            2x2.5Ghz Quad           

                RAM:                       4GB                               8GB                             16GB                      32GB

                DISK:                        SATA                             SATA                           SATA/SCSI              SATA/SCSI                                                     

 

DATABASE SERVER:

                CPU:                        2.0Ghz Dual Core         2.5Ghz Dual Core         2.5Ghz Quad            2x2.5Ghz Quad

                RAM:                       4GB                              8GB                              16GB                       32GB+

                DISK:                        SATA                            SATA/SCSI RAID            SCSI RAID               SCSI RAID                                                     

 

BI SERVER:

                CPU:                        2.0Ghz Dual Core         2.5Ghz Dual Core          2.5Ghz Quad           2x2.5Ghz Quad

                RAM:                       4GB                              8GB                               16GB                      32GB+

                DISK:                        SATA                            SATA/SCSI RAID             SCSI RAID              SCSI RAID     

 

WAN BANDWIDTH PER TERMINAL/CITRIX SERVER / CLIENT -  approximately 8-12 KBps / user over dedicated digital line (ISDN, DSL, T1, T3, etc)

Locking Service Installation

  1. Install the Locking Service by running LockingSetup.msi. The following will occur during installation:

    1. Locking Service will install into a separate folder

    2. The Locking Service will act as a separate Windows Service.

    3. The service should be configured to run under the NETWORK SERVICE account and should remain unchanged.

  2. Open the LockingWindowsServiceexe.config from the install folder in the step above. Note the port number.

 

 

Record Cache Service Installation

  1. Install the Record Cache Service by running RecordCacheSetup.msi. The following will occur during installation:

    1. Record Cache Service will install into a separate folder

    2. The Record Cache Service will act as a separate Windows Service.

    3. The service should be configured to run under the NETWORK SERVICE account and should remain unchanged.

  2.  Open the RecordCacheWindowsServiceexe.config from the install folder in the step above. Note the port number. 

 

 

Job Scheduling Service Installation

  1. Install the MTechSystems.JobScheduler by running the MTechSystems.JobScheduler.Setup.msi. The following will occur during installation:
    1.  Job Scheduler will install into a separate folder.
    2. The job scheduler will install as a windows service called MT Job Scheduling service.

  2. Configure the MT Job Scheduling Service to run under a USER that has permissions to write and read from the export and import folders. This can be done by clicking on the Log On tab under the service properties and configuring the account via the ‘This account’ field (screenshot below). A domain service account may be created for this purpose.

    3.  

     

  3. Edit the MTechSystems.JobScheduler.Service.exe.config file in the installation folder of the MT Job Scheduling service (Step 1) as follows. Edit the datasource.default.connectionstring value to match the values found in the mtech.cnn.

    4.  

  4.  Edit the Proteinexe.exe.config to reflect the server:port specified from the MTechSystems.JobScheduler.Service.exe.config from Step 9.

    5.  

     

  5. Ensure that the Protein folder and subfolders have read/write/modify permissions for all users that intend to use the program.

Configuring the Application

  1. Extract the contents of the application. (example: Protein_v7xx_date) archived to a folder (example: D:\MTECH\V7_PROD)
  2. Edit the mtech.cnn to reflect the SQL Server instance and the database name. If the <USELOCKINGSERVICE> and <USESCHEDULINGSERVICE> tags are not present, add them manually per the following screenshot.

    3.  

     

  3. Edit the proteinexe.exe.config.

    1. Set the data path of the application if installing a version 7.15 or later.

      2.  

    2. Replace svr-as1 with the servername where the appropriate service is installed.  Replace the port number with the appropriate port for the service.

     

     

     

  4. Ensure that the Protein folder and subfolders have read/write/modify permissions for all users that intend to use the program.

Configuring the Database

  1. Open SQL Management Studio.
  2. Create new login by selecting Security>Logins.
  3. Click on any user and right-click to select 'New Login'

    4.  

     

     

  4. In the Login screen, enter the following:

    1. Login Name: mtech

    2. Select SQL Server Authentication

    3. Enter password: coffee (Please contact techsupport@mtech-systems.com if a different password is required.

    4. Uncheck Enforce password policy

    5. Click OK

     

     

  5. Create new database by selecting Databases

  6. Right-click and select 'New Database'

    7.  

     

  7. Enter Database name: V7_Test

  8. Click OK

    9.  

     

  9. Click on Security > Logins

  10. Double-click on the SQL login ‘MTech’

  11. Click User Mapping on the left

    1. Select the Database that is to be mapped – V7_Test in this example.

    2.  Select db_backupoperator

    3. Select db_datareader

    4. Select db_datawriter

    5. Select db_ddladmin

    6. Select public

    7. Click OK

     

     

  12. Go to Databases> V7_Test > Security > Schemas

  13. Right-click and select New Schema

    14.  

     

  14. Enter the Schema name “mtech”

  15. Click 'Search'

    16.  

     

  16. Click 'Browse'

    17.  

     

  17. Choose the login 'mtech'

  18. Click OK

    19.  

     

  19. Go to Security>Logins>mtech

  20. Click User Mapping on left

  21. Click 'Default Schema'

  22. Click 'Browse'

  23. Select mtech schema

  24. Click OK

    25.  

     

  25. Select v700_Test database

  26. Run the query 'Grant showplan to mtech'

 

 

 

Enable MSDTC Access

This section contain instructions for the following:

 

Windows XP/Windows Server 2003/2003R2

  1. Click Start

  2. Click Run

  3. Type dcomcnfg to launch the Component Service Management console

  4. Click to expand Component Services

  5. Click to expand Computers

  6. Right-click My Computer

  7. Select Properties

  8. Click MSDTC tab on My Computer Properties dialog

  9. Select Security Configuration option to display Security Configuration dialog

    10.  

     

  10. Check the Network DTC Access option and the other options identified in the screen shot

  11. Click OK to restart the MSDTC service

    12.  

     

  12. Windows Firewall should be enabled to allow access to MSDTC.exe

  13. Select Control Panel>Windows Firewall>Exceptions

  14. Click Add Program>Browse

  15. Navigate to \Windows\System32

  16. Select MSDTC.exe

 

 

Vista/ Windows 7 / Windows 2008 Server

  1. Click Start

  2. Click Run

  3. Type dcomcnfg then click OK to open Component Services

  4. In the console tree, click to expand Component Services

  5. Click to expand Computers

  6. Click to expand My Computer

  7. Click to expand Distributed Transaction Coordinator

  8. Click local DTC

  9. Right-click local DTC and select Properties to display Local DTC Properties dialog

    10.  

     

  10. Select Security tab

  11. Set the following options on the Security tab

  12. Click OK

    13.  

     

  13. Windows Firewall should be enabled to allow access to MSDTC.exe (http://technet.microsoft.com/en-us/library/cc753510.aspx)
  14. Select Control Panel>Windows Firewall
  15. Select Change Settings to display the Windows Firewall Settings
  16. Click the Exceptions tab
  17. Check the box for Distributed Transaction Coordinator
  18. Select OK

 

Troubleshooting Transaction Coordinator errors

Distributed Transaction coordinator errors may be encountered in the form of errors such as the following. Visit http://msdn.microsoft.com/en-us/library/aa561924.aspx  for tips on how to resolve issues with MSDTC.