Using Microsoft SQL Server for Print Release Badge table

To use Microsoft SQL Server for the Print Release Badge table, update the mfpauth database.properties file to point to Microsoft SQL Server.

1. Create the Print Release database in Microsoft SQL Server manually. For more information, see Creating Print Release database for Microsoft SQL Server .

2. Run the LPM standalone installer.

3. Using a text editor, open the database.properties file.

4. Do the following:

   1. If a custom name is used instead of the default column name, USERID, then set database.BADGE.colUserId to the name of the user ID column.

   2. If a custom name is used instead of the default column name, BADGEID, then set database.BADGE.colBadgeId to the name of the badge ID column.

5. Save the file.

6. Restart the Lexmark Solutions Application Server service.

7. After the Lexmark Solutions Application Server process (tomcat7.exe) has fully initialized, set the server online.

8. Repeat this process for all application servers.