Crystal Report
-
I used the crystal report wizard to connect a Ms SQL Server. During the procedure the wizard requested for the username and password to the database. However, when i run the application and want to pull up a report the page request for the database password. What am i doing wrong? JESA
-
I used the crystal report wizard to connect a Ms SQL Server. During the procedure the wizard requested for the username and password to the database. However, when i run the application and want to pull up a report the page request for the database password. What am i doing wrong? JESA
How did you connect to the database when you developed the code?? If you used Trusted Connection or Windows Authentication, then that connection was made using your windows ID. If this is an ASP.NET app, the code is no longer running under your ID, but is using the ASPNET account. Since the ASPNET account isn't trusted by SQL Server, you get the credentials box asking for a valid login. It could be other things too, but this is a common problem with new people using SQL Server.
A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
2006, 2007