PrinterOn KB Powered By ePRINTit USA

Standalone SQL server - New IMCAS Database - c06300074

These solution steps can be used for customers looking to store the IMCAS SQL database on a remote (SQL server on another machine) SQL database.


Have the DBA create a new database on the remote SQL Server Instance.

Create a new Windows or SQL Server user as the dbowner of the newly created database

Stop CPS Service

Modify the c:\Program Files (x86)\PrinterOn Inc\Apache Tomcat\lib\ file to change the JDBC Url of the database to point to the SQL Server.

If the login account is a SQL Server account then remove the "integratedSecurity=true;" from the end of the connection string, and replace the login and password with the SQL Server credentials If the login account is a Windows account then make that Windows account the account that CPS service starts as.

Start CPS service