Prompt for login credentials using Windows-NT Authentication
From: Nick Tompson (ntompson_at_utas.edu.au)
Date: 05/03/04
- Next message: Kris: "Mixing MDAC versions between Servers and Clients"
- Previous message: Sal Young: "Can't connet to MSDE with Query Analyzer"
- Messages sorted by: [ date ] [ thread ]
Date: 3 May 2004 00:57:48 -0700
Hello,
I am using a SQL Server (MSDE) db, currently configured to only accept
Windows-NT Authentication logins. This has worked well for a while -
much easier to administer. However I have a group of users that have
presented a special problem.
These users have valid logins under a valid Windows Domain ie
<Domain>\<user>. Unlike most users, however, they do not login to the
windows domain when they log into their machines (instead they login
to the local machine). In cases other than mine, when they access
applications/web services that require authentication to the said
windows domain, they are prompted for login credentials (ie
username=<domain>\<user> and password). They can then proceed to use
the application/web service.
With my SQL Server database, however, this does not happen. When they
attempt to login to my database, I am guessing that the server figures
out that they are not currently logged in to the windows domain, so
denies them access outright. They are given no opportunity to enter
their credentials. They are attempting to access the database using
data access pages / OWC10.
Is there any way that I can setup a connection string which allows me
to continue using Windows-NT Authentication, but will prompt users for
login credentials if they are not currently logged in to the required
Windows Domain?
Thanks heaps for your help.
Nick Tompson
- Next message: Kris: "Mixing MDAC versions between Servers and Clients"
- Previous message: Sal Young: "Can't connet to MSDE with Query Analyzer"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
