SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-28-2008, 07:08 PM
| ||||
| ||||
 DSN Problems I have a SQL Server 2000 system dsn that uses SQL Server authentication. The DSN does not retain the password field entry I make. I enter the password (the sql login is already there), click next, next then ok. When I reopen the DSN, the password table is blank again. Help appreciated. Thanks, Frank *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it!      |
|
02-28-2008, 07:08 PM
| |||
| |||
| Re: DSN Problems "Frank Py" <fpy@proactnet.com> wrote in message news:3fd614b8$0$196$75868355@news.frii.net... > > I have a SQL Server 2000 system dsn that uses SQL Server authentication. > The DSN does not retain the password field entry I make. I enter the > password (the sql login is already there), click next, next then ok. > When I reopen the DSN, the password table is blank again. Help > appreciated. > > Thanks, > Frank > > > *** Sent via Developersdex http://www.developersdex.com *** > Don't just participate in USENET...get rewarded for it! Passwords are not stored in DSNs, as it would be very insecure. You will need to specify the password (and perhaps username - I'm not sure) at connection time. This is one good argument for using Windows authentication, if that's possible in your case. If not, you will need to investigate how to modify your application to request a username/password from the user. One other possibility would be to use some sort of middle tier, which would use a single DSN for all connections to SQL Server, but this may not be practical or desirable, depending on your application setup. Simon |
|
02-28-2008, 07:09 PM
| |||
| |||
| Re: DSN Problems Yes, I can use Windows Authentication. The person connecting to the DSN is an administrator. So if I use Windows Authentication instead on this DSN, would that be more transparent to the user? The user, who is an administrator needs to run a Crystal Report that is connected to the DSN without being prompted for a username and password each time. Help appreciated. Thanks. Frank *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
|
02-28-2008, 07:09 PM
| ||||
| ||||
| Re: DSN Problems Frank Py <fpy@proactnet.com> wrote in message news:<3fd635b0$0$198$75868355@news.frii.net>... > Yes, I can use Windows Authentication. The person connecting to the DSN > is an administrator. So if I use Windows Authentication instead on this > DSN, would that be more transparent to the user? The user, who is an > administrator needs to run a Crystal Report that is connected to the DSN > without being prompted for a username and password each time. Help > appreciated. Thanks. > > Frank > > > *** Sent via Developersdex http://www.developersdex.com *** > Don't just participate in USENET...get rewarded for it! Yes - using Windows authentication means that no username and password should be required, in the same way as connecting with Query Analyzer or OSQL, for example. Simon |
Linear Mode
