Updating the database.properties file for Microsoft SQL Server default instances

During installation, LPM version 2.4 or later creates connection strings in the properties files. Create the Print Release database in Microsoft SQL Server manually, and then run the LPM standalone installer. This process populates the database.properties file with the correct information, and then creates the Print Release tables in Microsoft SQL Server automatically.

  1. From Lexmark Management Console, set the application server offline.
  2. From the application server, browse to the <install_path> \apps\printrelease\WEB-INF\classes folder, where <install_path> is the installation path of LPM.
  3. Rename database.properties to database_backup.properties.
  4. Using a text editor, open the database_mssql.properties file.
  5. Do the following:
    1. Search for ${SQLSERVER}, and then replace all instances with the network address of Microsoft SQL Server.
    2. Search for ${SQLDB}, and then replace all instances with the Microsoft SQL Server database name that contains the Print Release database tables.
    3. Search for ${SQLUSER}, and then replace all instances with the Microsoft SQL Server named user that has read‑write‑delete access to the Print Release database tables.
    4. Search for ${SQLPW}, and then replace all instances with the password for the Microsoft SQL Server named user.
  6. Name the file as database.properties.
  7. Save the file.
  8. Restart the Lexmark Solutions Application Server service.
  9. After the Lexmark Solutions Application Server process (tomcat7.exe) has fully initialized, set the server online.
  10. Repeat this process for all application servers.
Note: When only subsets of the Print Release tables are stored in Microsoft SQL Server, copy sections from the database_mssql.properties file to the database.properties file. For example, if only the Print Release statistics data in Microsoft SQL Server is necessary, then from the database_mssql.properties file, copy the database.STATS section. From the database.properties file, overwrite the same information.