Page Comparison

...

1. Go to etc folder in Adeptia installation directory: …AdeptiaServer/ServerKernel/etc
2. Take back-up of quartz.properties file.
3. Open quartz.properties file.
4. Go to Configure Datasources group, set the value of org.quartz.dataSource.aBPM.driver as com.microsoft.sqlserver.jdbc.SQLServerDriver.
5. Set the JDBC connection URL in the org.quartz.dataSource.aBPM.URL in this format:
   jdbc:sqlserver://<<Database Server>>:<<port>>; databaseName=<<name of the database>>;
   
   For Named Instance, set the JDBC connection URL in the the org.quartz.dataSource.aBPM.URL in  in the following format: 
   
   jdbc:sqlserver://<databaseServerName>:<port>; databaseName=<name of the database>;instanceName=<name of the instance>
   
   

   where,

   <databaseServerName> is the host name where database server is running.

   <port> port number on which database server is running.

   <name of the database> is the name of the database.

   <instanceName> is the name of named database instance.

   For example,

   jdbc:sqlserver://127.0.0.1:1433;databaseName=backend;instanceName=production

6. Save and exit the file.