The development was on VS.NET 2003, using the Crystal component that came standard with the IDE.
For some bizarre reason the report had no problems logging on to the local DB for local admin user. Anybody else (including domain admin) were rejected! Any attempts to provide even the correct credentials were rejected.
In the end I gave up and contacted Crystal folks to see if they could help. It was one of the most frustrating experience I've ever had with a tech support/helpdesk. Admittedly I have had helpful assistance from them before but this time it felt like chasing my own tail.
At last I found the culprit! Using localhost turned out to be a bad idea!! For yet another bizarre reason CR automatically create the connection to use Integrated Security, even when you specify the UserID/Password and left the Integrated Security option unticked. Any attempts to provide the credentials programatically were thoroughly ignored.
I had to create the report by specifying a server name, and later when it's loaded into the viewer I then changed it to "localhost" and pass in the appropriate credentials. That seemed to have done the trick! So there ya go.... hopefully someone will find this useful before they end up tearing their hair out like I almost did.
Other related posts:
Logging feature in applications
Add a comment
Please note: comments that are inappropriate or promotional in nature will be deleted.
E-mail addresses are not displayed, but you must enter a valid e-mail address to confirm your comments.
Are you a registered Geekzone user? Login to have the fields below automatically filled in for you and to enable links in comments. If you have (or qualify to have) a Geekzone Blog then your comment will be automatically confirmed and placed in the moderation queue for the blog owner's approval.