Hamza
20 December 2021 12:29
1
Trying to connect the CRM to MSSQL server (which is on windows server) through ubuntu.
(MSSQL configurations are already working on suiteCRM7 on same server)
But getting issue when i try to connect it through SuiteCRM8 installation.
using command: ./bin/console suitecrm:app:install
tried with host: 192.168.10.13 (didn’t worked)
PLEASE Help Thanks.
config of suitecrm7:
‘db_host_name’ => ‘192.168.10.13’,
‘db_host_instance’ => ‘HAMMNET_SQL’,
‘db_user_name’ => ‘HMR-SQLService’,
‘db_password’ => ‘*******’,
‘db_name’ => ‘suitenew’,
‘db_type’ => ‘mssql’,
‘db_port’ => ‘’,
‘db_manager’ => ‘SqlsrvManager’,
‘collation’ => NULL,
‘charset’ => NULL,
Hamza
22 December 2021 08:52
2
Hi @Hamza
Sorry for the delay in replying. We are in a holiday season so people may take a bit more in replying. My self included.
MSSQL is not officially supported on SuiteCRM 8 at the moment.
However, have a look at the following post:
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_confi…
Hope it helps
Hamza
25 December 2021 11:38
4
@clemente.raposo No worries, Thanks for replying
I’ll try this one, did you know when will this officially out?
Enjoy the holidays.
Hi @Hamza ,
Thank you.
Don’t know, sorry. We still have a good amount features to port from legacy views to suite 8 views.
I don’t think it will be very soon, unfortunately.
However, planning is not my area, so I may be wrong.
Hi, we would need to know if there is any news regarding SQL SERVER support for SuiteCRM 8. In particular, we would like to know if SQL SERVER support is in your roadmap.
could you kindly tell me if there are any updates about it? thank you