Set up - SequelizeConnectionError: Server requires encryption, set 'encrypt' config option to true

[thibautdehem]

When running the initial Install command with NPM, i receive following error:
Set up - SequelizeConnectionError: Server requires encryption, set ‘encrypt’ config option to true.

I found this, but that’s in plain JS:

Set encrypt to true on Sequelize-cli migrate for MSSQL

I believe it’s a way of adding attribute “encrypt”: “true” in the --databaseConnectionURL

I tried different extensions like below without success
–databaseConnectionURL “mssql://…/dialectOptions:options:encrypt:true”
thanks

[GuillaumeGautreau]

Hello @thibautdehem,

Can you test with the option --ssl true without modifying your databaseConnectionURL?

When creating a project, you can click on “advanced options” and a new checkbox named “Use SSL” will appear, allowing you to generate the right command with the ssl option.

In your case, no need to re-create a project again, but you need to add this option to the command that generates your project.