Not able to change the database to ms sql

[kavi]

Hi ,

I want to use my own db with this. how to do it?

I tried by changing it to sqlserver settings as described in userguide.
But of no use. It does not work.
The window flickers and disappears fast.
How to change it to my own database?

Any idea where i am going wrong?

I tried like
in activiti/setup - db=mssql
jdbc.driver=net.sourceforge.jtds.jdbc.Driver
jdbc.url=jdbc:jtds:sqlserver://localhost:1433/activiti
jdbc.username=activiti
jdbc.password=activiti

in activiti/build.properties - db=mssql
tx=standalone
but it does not work. Can you please help me to setup sql server db in my local machine?

Thanks,
kavi

[jbarrez]

have you restared the demo setup? ant demo.stop, ant demo.clean, ant demo.start?

[kavi]

Hi ,
yes i tried with demo.stop demo.clean demo.start but stil i am not able to change the database to mssql

Thanks,
kavi

[uzair_zaman]

Did you get this sorted?
I can easily connect to mysql but it doens't work with msssql.
I am trying to follow the same steps for mssql but it's not working.
I have copied the sqljdbc4 under\apache-tomcat-7.0.67 - Activiti Tomcat\webapps\activiti-explorer\WEB-INF\lib and have changed the db.properties file accordingly:
db=mssql
jdbc.driver=com.microsoft.sqlsever.jdbc.SQLServerDriver
jdbc.url=jdbc:sqlserver://10.10.44.1:1433;databaseName=activiti
jdbc.username=sa
jdbc.password=password

Any suggestions?

[jbarrez]

What's the exception your getting when connecting?