Is it possible to use an existing SQL instance with PrinterOn? - c06234558

You can easily use an existing SQL Server.

The steps are as follows:

1. If you don't want to loose the current printer configuration and print job data in the current install, then you will need to take a backup of the database in the new instance.
2. Have the database administrator .
   • Create a new database (or restore the database from step 1 if that is desired) into the new SQL Server Instance.
   • Create a new Windows or SQL Server user as the dbowner of the newly created/restored database.
3. Stop the Windows Central Print Services Service .
4. Modify the C:\Program Files (x 86)\ PrinterOn Corporation\Apache Tomcat\lib\cps- db.properties file to change the JDBC Url of the database to point to the SQL Server ( see https://msdn.microsoft.com/en-us/library/ms378428%28v=sql.110%29.aspx).
   • If the login account is a SQL Server account you should 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 change the account that the Central Print Services service starts as in the Windows service.
5. Start Central Print Services again.

Watch the logs to make sure it starts up cleanly.

NOTE:

Applies to PrinterOn Enterprise 3.x and later.

The PrinterOn server supports the following versions of SQL Server: SQL Server 2012, 2014 & 2016.