I am working with VB.net and my back-end database is SQL server 2005. I have created some crystal reports in my VB.net application, however,when I always run the reports, I have to type in the password for the Sql Server, otherwise it doesnt connect me and hence no results are displayed.

This is a major problem as the users cant be issued with the password. I want it to connect automatically when someone has logged on to the application rather than always asking for a password whenever a cystal reportt is ran.

Please note: When I run a form and navigate through forms it connects fine to the database.

Any ideas or advice??

Thank you very much