If you go to the security tab on the properties page for sqlSErver, you can change the login requirements from sQL only to a mix of windows/sql. That may fix your problem.



>I have created a crystal report with Crystal Reports.NET .
>
>When I added the tables from the database to the report, I used Integrated Security (Windows Authentication). I have found that trying to SetDatabaseLogon has been prompting me for logon information at run time. I suspected it might be the authentication setting, and recreated the report, adding the tables using SQL authentication and the prompting stopped.
>
>The problem is I have several intricate reports that I would rather not recreate: I'd like to just find some screen where I can set/change the existing authentication.
>
>Does anyone know how to do this, or do I need to recreate the reports?
>
>Thanks,