Hi
I'm afraid you've discovered a bug in our documentation.
If you look at the compatible databases section in the Prerequisite information:
https://help.talend.com/search/all?query=Compatible+Databases&content-lang=en, it says that DSC only supports MySQL and HSQL (Table 1.9 - last table of the page).
However for some reason, we provide a different information in the page you refer to,
https://help.talend.com/search/all?query=%2522Replacing+the+default+database%2522&content-lang=en.
I have opened a documentation issue in our JIRA to fix the documentation accurately:
https://jira.talendforge.org/browse/DOCT-2714
In the mean time we asked our QA to quickly test how possible this is to switch to SQL server.
This seems to work ok. But we didn't roll out the full testing scenarios on DSC for this database for obvious time reason (this is not in the scope), therefore we still can't support DSC on MSSQL.
Here are the configuration steps undertaken by our QA person:
1.create a new database named tdsc_db in SQL Server first.
2.manually config the jboss-4.2.2.GA/server/default/deploy/org.talend.datastewardship.war/WEB-INF/classes/tdsc-database.properties:
tdsc.database.driverClassName=net.sourceforge.jtds.jdbc.Driver
tdsc.database.url=jdbc:jtds:sqlserver:/<YourIP>:1433/tdsc_db
tdsc.database.username=sa
tdsc.database.password=talend
tdsc.database.dialect=org.hibernate.dialect.SQLServerDialect
tdsc.database.connectionProperties=
3.add jtds-1.2.2.jar and sqljdbc4-4.0.jar to jboss-4.2.2.GA/server/default/lib
4.start server.
So conclusion is it seems to work ok with the above settings but we cannot provide any support for it, for now.
Sorry about this, thanks for your understanding.
Elisa