Understanding Microsoft SQL Server for Print Release database

Learn about using Microsoft SQL Server for Print Release database.

The Print Release database tables in Microsoft SQL Server are automatically created during installation. During installation, specify the Microsoft SQL Server database server information on the database screen. This process populates the database.properties file with the correct information automatically. In the same directory as the database.properties file, a backup copy of the database_mssql.properties file is stored. The database_mssql.properties file contains variable names that can be used as a template when formatting the database.properties file for Microsoft SQL Server. If you edit the database_mssql.properties for use, then rename it to database.properties.

Notes:
  • Only the database.properties file is used with the solution.
  • Before saving the database.properties file, stop the Lexmark Solutions Application Server service.

When switching from Firebird to Microsoft SQL Server after installation, create the Print Release database in Microsoft SQL Server manually. Delete all the backup files, and then run the LPM installer. Specify the Microsoft SQL Server database information on the database screen.

Note: The LPM data is not migrated to the new Microsoft SQL Server database.

Microsoft SQL Server supported versions

  • Microsoft SQL Server 2022

  • Microsoft SQL Server 2019

  • Microsoft SQL Server 2017

  • Microsoft SQL Server 2016

  • Microsoft SQL Server 2014

Before installing Microsoft SQL Server 2014 or 2012, from the Server Manager, add the following:

  • .NET Framework 3.5 features for Microsoft Server 2012

  • .NET Framework 3.5.1 features for Microsoft Server 2008