Currently i am using the MYSQL server as backend database, would like to use the Microsoft Sql Server as backend database, as i know that Jtrac properties file needs to be modified and i have done it for Mysql but wondering how to configure this to connect MS Sql server
database.driver=com.mysql.jdbc.Driver
database.url=jdbc:mysql://localhost/jtrac
database.username=root
database.password=xxxxxxx
hibernate.dialect=org.hibernate.dialect.MySQLDialect
hibernate.show_sql=false
The Hibernate Dialect should be org.hibernate.dialect.SQLServerDialect. Perhaps I have no MSSQL Server you should use google ;-).