Error messages when you try to print or print preview a custom report in Microsoft Dynamics SL: "Crystal Print Engine Error 536" or "System Messaage 7014"


Symptoms


When you print a custom report or preview a custom report before you print it in Microsoft Dynamics SL, you receive the following error messages:
Crystal Print Engine Error: 536-Error in File. Unable to connect: incorrect log on parameters.
System Message 7014: Report Execution failed with error 536.
.

Cause


Cause 1

The Trusted Connection parameter in the report file is set to 1. See Resolution 1.

Cause 2

The Open Database Connectivity (ODBC) connection on the workstation is corrupted. See Resolution 2.

Cause 3

The report is pointing to two different databases. See Resolution 3.

Cause 4

The E7F575915A2E4897A517779C0DD7CE login account in SQL Server 2005 or in SQL Server 2008 is disabled or has an incorrect password. See Resolution 4.

Resolution


Resolution 1

To resolve this problem, set the Trusted Connection parameter in the report file to 0 (zero). To do this, follow these steps:

  1. Start Crystal Reports 10 for Solomon.
  2. Click Open, select the custom report, and then click Open.
  3. On the Database menu, click Set Datasource Location.
  4. In the Set Datasource Location dialog box, expand Current Data Source: Properties.
  5. Under Current Data Source: Properties, locate the Trusted Connection: 1 parameter.
    Note If the Trusted Connection parameter is not listed, the Trusted Connection option was not selected when the report was created, and this is not the cause of the error.
  6. Right-click Trusted Connection: 1, and then click Edit.
  7. Type 0.
  8. Click Close.
  9. Click Save.

Resolution 2

To resolve this problem, delete the Microsoft Dynamics SL ODBC connections. Then, let Microsoft Dynamics SL re-create the connections. To do this, follow these steps:
  1. Click Start, click Control Panel, click Administrative Tools, and then click Data Sources (ODBC).
  2. On the User DSN tab, remove any items that point to your Microsoft Dynamics SL application databases.
  3. On the System DSN tab, remove any items that point to your Microsoft Dynamics SL application databases.
  4. Rerun the report in Microsoft Dynamics SL. The ODBC connections are automatically re-created when you run a report in Microsoft Dynamics SL.

Resolution 3

To resolve this problem, reset the data source in Crystal Reports. To do this, follow these steps:
  1. Start Crystal Reports 10 for Solomon.
  2. Click Open, select the custom report, and then click Open.
  3. On the Database menu, click Set Datasource Location.
  4. In the Replace With box, expand Create New Connection, and then expand ODBC (RDO).
  5. Click your Microsoft Dynamics SL database, and then click Next.
  6. Enter your log on information. Do not select the Trusted Connection check box.
  7. Click Finish.
  8. Click the database in the Replace With box. Then, click the database in the Current Data Source box.
  9. Click Update.
  10. If you have multiple databases in the Current Data Source box, repeat steps 8 and 9 for each database.
  11. Click Save, and then exit Crystal Reports.

Resolution 4

To resolve this problem, enable the E7F575915A2E4897A517779C0DD7CE login account in SQL Server 2005 or in SQL Server 2008, and then run the Synchronize All Ownership & Security update scenario in the Database Maintenance (98.290.00) screen in Microsoft Dynamics SL. To do this, follow these steps:
  1. Start SQL Server Management Studio, and then connect to the server that hosts the Microsoft Dynamics SL databases.
  2. In the Object Explorer pane, expand Security, and then expand Logins.
  3. Under Logins, right-click E7F575915A2E4897A517779C0DD7CE, and then click Properties.
  4. In the Select a page pane, click Status, and then click Enabled under Login.
  5. Click OK, and then close SQL Server Management Studio.
  6. In Control Panel, click Administrative Tools, and then click Microsoft Dynamics SL Database Maintenance.
  7. Connect to the instance of SQL Server that is hosting the Microsoft Dynamics SL databases.
  8. Click the Update Database tab.
  9. In the Update Scenarios list, click Synchronize All Ownership & Security, and then click Update Database.
  10. At the bottom of the Database Maintenance (98.290.00) screen, confirm that the progress bar has finished, and then click Close.