Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Password Prompted

Author  Topic 

dr223
Constraint Violating Yak Guru

444 Posts

Posted - 2009-05-21 : 07:24:40

Hi,

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 reportt is ran.

Any ideas or advice??

Thank you very much

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-05-24 : 04:26:02
You can set the password and username for the connectionstring used for the reports.
See www.connectionstrings.com



E 12°55'05.63"
N 56°04'39.26"
Go to Top of Page
   

- Advertisement -