Configuration changes required to connect Suite CRM 8 to MSSQL
- 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”
- 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’;