Standalone SQL server - New IMCAS Database - c06593903

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 (x 86)\ 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