Database Login box when running Crystal Report
Posted on 2014-01-22
I'm using Crystal Reports with Visual Studio 2010 and SQL Server 2008r2.
The app I'm developing allows users to select criteria and view reports in a report viewer control. All reports work fine on my machine (of course). When I deploy using click once, to users some of the reports pop up a database login box. Some do and some don't which is perplexing. The reports that pop up the login box are very similar to those that work fine. The reports use stored procedures and I have granted the users connect and execute rights to the database.
These same users use a different app that is set up almost identically and connects to the same server, but a different database and there is no prob with any of those reports.
What can I try here?