SuiteCRM 8 Beta - Install Questions

Configuration changes required to connect Suite CRM 8 to MSSQL

  1. Change DATABASE_URL in suitecrmrootfolder/.env.local file. ( .env.local file need to be at this path)
    • DATABASE_URL=“mssql://USERNAME:PASSWORD@DBSERVERBANE:1433/DATABASENAME”
  2. Add below entries to the suitecrmrootfolder\public\legacy\config_override.php
    • $sugar_config[‘dbconfig’][‘db_host_name’] = DBSERVERBANE;
    • $sugar_config[‘dbconfig’][‘db_user_name’] = DBUSERNAME;
    • $sugar_config[‘dbconfig’][‘db_password’] = password;
    • $sugar_config[‘dbconfig’][‘db_name’] = dbname;
    • $sugar_config[‘dbconfig’][‘db_type’] = ‘mssql’;
    • $sugar_config[‘dbconfig’][‘db_port’] = ‘1433’;
    • $sugar_config[‘dbconfig’][‘db_manager’] = ‘SqlsrvManager’;