Error in File Crystalreport.rpt Incorrect log on p
I have what seems to be a aspnet sql auth. problem. This same report works fine when I connect it to a MSAccess.mdb version of this SQL Database that I am having problems with. I have seen code that wants you to enter individual Table login info, to solution to give aspnet less restrictions in its access to the system. I believe the problem is this SQL will not give aspnet (login) access to the database. I have seen some posts in the past that would actually hand Crystal reports the entire dataset, Is this a better solution?
Please, I appreciate any and all suggestion, solutions.
Error in File c:\inetpub\wwwroot\CrystalTest\les.rpt: Unable to connect: incorrect log on parameters.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: CrystalDecisions.CrystalReports.Engine.LogOnExcept ion: Error in File c:\inetpub\wwwroot\CrystalTest\les.rpt: Unable to connect: incorrect log on parameters.
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.