Moving the PrinterOn Configuration database to a standalone SQL server - c06226832

The steps below will allow the administrator of the PrinterOn Enterprise solution to backup the PrinterOn Configuration database and move it from the local SQL Server (SQL Express) to a remote standalone SQL server .

Make a backup of the current PrinterOn configuration database .
To backup the current database use these steps: How to backup the PrinterOn Configuration database.
Have the Database administrator restore the database backup created in step #1, onto the new SQL Server Instance .
Create a new Microsoft Windows or SQL Server user as the dbowner of the newly created/restored database.
Stop Central Print Services (CPS) .
Navigate to the default directory C:\Program Files (x 86)\ PrinterOn Inc\Apache Tomcat\lib
Make a backup of the file cps- db.properties .
Place the backup of the file in a different directory, preferably on another server or storage location.
Edit the cps- db.properties file identified in step #5 and change the details as follows:
1. Modify the SQL server details (jdbc.url= jdbc:sqlserver ) with the IP address or DNS name of the Microsoft SQL server for additional information see Microsoft article here: https://msdn.microsoft.com/en-us/library/ms378428%28v=sql.110%29.aspx
2. jdbc.user = (used to enter the username if the connection to the database will use SQL authentication)
3. jdbc.password =(used to enter the password if the connection to the database will use SQL authentication)
If the connection to the database server uses SQL authentication ; remove " integratedSecurity =true; " from the end of the connection string.
If the connection to the database server uses a Microsoft Windows account
1. Naviate to the Microsoft Windows services panel.
2. Locate the Central Print services service.
3. Change the log-on as for the service to the Microsoft Windows account that has access to the database on the SQL server.
Start CPS service .

NOTE:

Applies to PrinterOn Enterprise 3.x and later.