Failed to Retrieve Data from Database (Vendor Code: 229) when printing a report in Dynamics SL

| April 19, 2017
plumbline consulting

After installing a PCL Product, you may find that next time you print a report within Dynamics SL you receive the following error message.

Crystal 229 Error

This issue generally indicates that the access rights for the built in SL reporting user are not correct.

Resolution 1:
1. Run the SL Database Maintenance Sync Ownership and Security scenario against the SL application database.

Resolution 2:
1. Run the attached script labeled Shared.sql against the SL system database and all SL application databases.
2. Run the script labeled Permissions.sql against all SL application databases.