- You are running Microsoft Dynamics SL 7.0 or Microsoft Dynamics SL 2011.
- You use a custom Crystal Reports report.
- You log on by using Windows Authentication.
Get SQL Query failed Report: C:\Program Files\Microsoft Dynamics SL\Usr_Rpts\03730DET.RPT
Crystal Print Engine Error: 709 - Error in File C:\Program Files\Microsoft Dynamics SL\Usr_Rpts\03730DET.RPT:
The table could not be found.
Cause 1This error occurs because the following conditions are true:
- The Crystal Reports report uses one or more custom tables or custom views.
- Either the E7F575915A2E4897A517779C0DD7CE Microsoft SQL Server user or the MSDSL SQL Server application role does not have the required permissions to the custom table or to the custom view. See Resolution 1 in the "Resolution" section.
Cause 2An Open Database Connectivity (ODBC) connection is set up incorrectly to use Windows Authentication instead of SQL Server authentication. When you first run a Crystal Reports report on a new workstation, an ODBC connection is created for the Microsoft Dynamics SL system database and for the Microsoft Dynamics SL application database. This connection should be set up to use SQL Server authentication, even if you use Windows Authentication to log on to Microsoft Dynamics SL. See Resolution 2 in the "Resolution" section.
Resolution 1Assign the appropriate rights to the custom table or to the custom view. To do this, follow these steps:
- Start Microsoft SQL Server Management Studio.
- Expand Databases, expand the Dynamics SL database, and then expand Tables or Views.
- Locate the custom table or the custom view in the list.
- Right-click the custom table or the custom view. Then, select Properties.
- In the Select a Page pane, click Permissions.
- Click ADD, type MSDSL, and then click OK.
- For the Select permission, click to select the Grant check box.
- Click ADD.
- Click Browse. Then, click to select the check box next to the E7F575915A2E4897A517779C0DD7CE user.
- Click OK two times.
- For the Control permission, click to select the Grant check box.
Resolution 2To resolve this problem, delete the ODBC connections, and let Microsoft Dynamics SL re-create the connections. To do this, follow these steps:
- Click Start, click Settings, and then click Control Panel.
- Click Administrative Tools.
- Click Data Sources (ODBC).
- On the User DSN tab, remove any entries for the Microsoft Dynamics SL system database and for the Microsoft Dynamics SL application database.
- On the System DSN tab, remove any entries for the Microsoft Dynamics SL system database and for the Microsoft Dynamics SL application database.
- Log on to Microsoft Dynamics SL again, and then try to use the report again. The User DSN entries should be re-created automatically.