Installation of eWay-CRM on Terminal Server

Description

The article describes the installation of eWay-CRM on the terminal server with SQL instance installed on another server.

Version

All versions of eWay-CRM

Difficulty

Medium

Resolution

  1. First, you need to prepare a higher version SQL instance (not Express) that is installed on a different server than the terminal.
  2. Give public and dbcreator permission to each user so eWay-CRM will be able to create the database.
  3. Also it is required to have UNSAFE ASSEMBLY permission on master database, so that eWay-CRM can create CLR procedures.

    USE [master]
    GRANT UNSAFE ASSEMBLY to [DOMAIN\user]
  4. CLR procedures are loaded from eWay.Core.SqlClr.dll file that must be manually copied from the eWay-CRM install folder to the same place on SQL Server, if SQL Server is installed on different server.
  5. On the terminal in C:\Program Data\eWay-CRM create the config.ini file. Values user and password should be skipped. In that case Windows Authentication will be used.

    [database]
    server=EWAY-TERMINAL\EWAYSQL
    user=sa
    password=eWay-CRM123
  6. Now, you can start eWay-CRM and sign users into their accounts.