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\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