Hello Forum,
I am attempting to build a pilot install of SuiteCRM on Ubuntu, using MS SQL Server (MSSQL). TDS is fine and works. The installer will only proceed if I have the DB pre-created in MSSQL, though. Then the installer hangs on Creating Database… If I attempt the install without the database pre-created I get the message:
“The provided database host, username, and/or password is invalid, and a connection to the database could not be established. Please enter a valid host, username and password” and install will not continue. The same happens using the MSSQL sa account, so it is not permissions on the MSSQL side.
Obviously, MySQL is the better choice. I am building some integrations with our ERP (which lives on MSSQL) and I want to have the DBs side-by-side in MSSQL to build views with matching column names. I realize there are other ways, but being most familiar with MSSQL and the ERP DB I am attempting this method. It should work, per documentation. Something is amiss, though.
Any ideas? I have tried both 7.5.3 and 7.6.2
Thanks,
SM