SQL Windows Authenication

[JJ]

I have an application that uses Windows Authenication for the SQL access.
However, we have a number of workstations that are shared by users and have
a generic login to the workstation. I would like to be able to prompt the
user for their network userID & password and then authenicate.....not use the
generic login account currently logged in at the workstation.

Does anyone know of a method to handle this? I have had no luck. I know I
could switch to SQL authenication but then that woudl be one more password
the users would have to remember.

Does anyone know of a method? Any help would be appreciated.

 

[Sylvain Lafontaine]

The easiest way would be to ask your users to relog on the workstation using
their own login.

A second possibility would be to use the RunAs command to run the ADP
project. See also the second reference below.

Finally, one final possible solution would be to etablish a named pipe
connection using a trusted connection (this trick is usually used for people
connecting over a VPN without using domains). In your case, it's possible
that the simple fact of etablishing an alias using the Named Pipe protocol
will do the trick but I don't know as I never tried it personnally; see:

http://sqljunkies.com/WebLog/roman/archive/2004/11/28/5296.aspx

http://www.jasonfollas.com/wiki/(X(...Studio on Vista&AspxAutoDetectCookieSupport=1