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.

SOLUTION :

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\imcas-db.properties 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