Getting Bonita works on mssql server

Q&A
1

I followed all the steps to make Bonita works with Sql Server.
The only issue we have is when we run the system trying to initialize the database but it stopped with this error:
Caused by: org.bonitasoft.engine.platform.SPlatformCreationException: Unable to create platform tables : com.microsoft.sqlserver.jdbc.SQLServerException: Column, parameter, or variable #3: Cannot find data type LONGVARCHAR.
at org.bonitasoft.engine.platform.impl.PlatformServiceImpl.createPlatformTables(PlatformServiceImpl.java:151)
at org.bonitasoft.engine.api.impl.PlatformAPIImpl.createPlatform(PlatformAPIImpl.java:152)
… 29 more

Which mean that the system trying to run H2 script on sql server.

I checked my setenv.bat and it indeed changed to set the DB_OPTS.
in setenv.bat:
set DB_OPTS=“-Dsysprop.bonita.db.vendor=sqlserver”

I am using windows 8.1 and Sql server 2012.

Any clue?

2

You also need to change the dialect in this file:
<bonita.home>\server\platform\tenant-template\conf\bonita-server.properties
Did you do it?