Modifying the PrinterOn service to use the new database locations

Once you have completed the migration of the PrinterOn databases, you can configure the PrinterOn server to use the new database locations. To point to the new databases, you need to manually modify the database properties files.

📘 Instructions

To point to the new database:

• In the Configuration Manager, stop the Central Print Services.

• In a text editor, open one of the following files:

  • CODE

    C:\Program Files (x86)\PrinterOn Corporation\Apache Tomcat\lib\cps-db.properties 
    C:\Program Files (x86)\PrinterOn Corporation\Apache Tomcat\lib\imcas-db.properties

• In the properties file, locate the jdbc.url entry.

• Modify the connection string as follows:

  • Modify the server location (by default, set to jdbc:sqlserver://localhost) to point to your SQL Server. The entry must conform to the following syntax:

    CODE

    jdbc:sqlserver://[serverName[\instanceName]:portNumber]]

  • If the login account for the database is a SQL Server account, remove the following property from the connection string:

    CODE

    integratedSecurity=true

• If the login account is a SQL Server account, modify the values of the jdbc.user and jdbc.password settings in the cps-db.properties file to reflect the username and password of the SQL Server account.

• Save the file,

• If necessary, repeat Steps 2 through 6 to modify the other properties file.

• IntheConfigurationManager,restarttheCPS

📋 Related articles