I have problems with Crystal Reports and connecting to SQL Server also. I ended up finding some settings in the report itself that fixed the problem. You might want to take a look at the report. Sorry I am not very specific I am too familiar with crystal reports I just had the job of debugging the problem.