Configuring Microsoft SQL Server for database support

Note: If necessary, LPM has some predefined Jasper reports that can be installed. The report files to install vary based on whether the customer data is stored on Firebird or Microsoft SQL Server.

If you are using Microsoft SQL Server to store the Print Release usage data, then before installing the reports, do the following:

  1. From Lexmark Management Console, click the Services tab.
  2. From the Services section, select Reports.
  3. Specify the following:

    • Database driver—When using Microsoft SQL Server, type com.microsoft.sqlserver.jdbc.SQLServerDriver.

    • Database URL—Enter jdbc:sqlserver://<IPAddress>:1433;databaseName=PRINTRELEASE;encrypt=false, where IPAddress is the IP address of Microsoft SQL Server.

      Note: If Integrated Security is used, then add ;integratedSecurity=true; in the URL.

    • Username for external database—The LDD service account user name with read and write access to Microsoft SQL Server.

      Note: If Integrated Security is used, then this setting is optional.

    • Password for external database—The LDD service account password with read and write access to Microsoft SQL Server.

      Note: If Integrated Security is used, then this setting is optional.
  4. Click Apply.