Print Page | Close Window

Crystal Reports 2008 - SQL Server 2008

Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=7153
Printed Date: 18 May 2024 at 12:27pm


Topic: Crystal Reports 2008 - SQL Server 2008
Posted By: WillieK
Subject: Crystal Reports 2008 - SQL Server 2008
Date Posted: 27 Jul 2009 at 1:13am

Hi there,

We are having a problem where certain reports are giving the "incorrect log on parameters" error when trying to execute the SQL Stored Proc that acts as the data source.
The weird thing is that these reports have been working for ages, and now certain reports are giving the error while others are working with no problems on the same database with the same connection string.
To complicate things even further, we tried to replicate the problem at the office, and connecting to one database, the problem appears, changing to another database, the problem goes away.
There seems to be no difference between the two. (as far as settings and connection string goes)
Does anybody have a similar problem or do anybody know what could be causing the problem?
 
Any help would be GREATLY appreciated!


Replies:
Posted By: WillieK
Date Posted: 21 Oct 2009 at 2:18am
The problem was that there is a sub report used in the report and some of the expected parameters were passed through wrongly.
For some reason Crystal gave an unrelated error, as it had nothing to do with "log on parameters", but other parameters instead.


Print Page | Close Window