TechNote (Archived)

cfreport tag throws an 'Error number 599'

Issue

---

When using the cfreport tag in a ColdFusion application, you may encounter the following error:

 An unexpected error occurred while using the Crystal Engine. Error number 599 ocurred (Cannot open SQL server.). 

This error is misleading, as the problem is not with Crystal Reports. Rather, the Crystal Engine is having problems with the data source that is providing the data for thecfreport tag.

Solution

---

1. Open the report in Crystal Reports.
2. If the report displays correctly, continue to step 3. If not, the issue must be corrected in Crystal Reports before continuing.
3. Run the ColdFusion page containing the cfreport tag.
   
   If it fails, the error is typically caused by the use of a trusted connection to the data source. Please see TechNote 18245 on how to configure ColdFusion MX to work with a trusted connection to SQL Server.
   
   Note: SQL Server trusted connections require using the ODBC Socket Type 3 driver. The recommended option is to use SQL authentication, in order to use the Microsoft SQL Server Type 4 JDBC driver.

Additional Information

---

Related TechNotes:

• Troubleshooting data sources and database connectivity for Windows platforms (TechNote 17115)
• Integrating Crystal Reports with ColdFusion MX (TechNote 18639)
• ColdFusion MX 6.1 (Windows only): Hot fix for Crystal Reports after upgrading from CFMX to CFMX 6.1 (TechNote 18931)
• ColdFusion (All versions): cfreport error (TechNote 17096)
• ColdFusion MX: Enabling Microsoft SQL Server trusted connections (TechNote 18245)

Search Support

---