When publishing a Crystal Report that uses SQL Server for the data source, Ripplestone will likely not be able to connection the database to run the report.  Normally the Crystal Report will return an Error 012, stating that the database connection could not be completed.  The problem is that Ripplestone runs under a IIS user, normally Network Service, that has limited permissions.  Since the report is using Integrated Security it uses the IIS user to try and login to the SQL Server database to refresh the report and fails because it does not have permission to login to SQL Server.

To fix this problem you should change the report to use a UserID and Password to login to SQL Server and setup a Database Connection within Ripplestone.  For more information on how to create a Database Connection for a Crystal Report  in Ripplestone visit the Helpful Documents page.